forms 6i duplicate record [message #600274] |
Mon, 04 November 2013 10:28 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ora1980
Messages: 251 Registered: May 2008
|
Senior Member |
|
|
I am using forms 6i, I want to insert a new record in the form based on an existing record (so I do not have to type all the values)
is there a shortcut key that I can use to copy the entire record and then when I say insert new, I just paste the record I just copied ?
|
|
|
Re: forms 6i duplicate record [message #600278 is a reply to message #600274] |
Mon, 04 November 2013 11:06 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
Lalit Kumar B
Messages: 3174 Registered: May 2013 Location: World Wide on the Web
|
Senior Member |
|
|
ora1980 wrote on Mon, 04 November 2013 21:58I am using forms 6i, I want to insert a new record in the form based on an existing record (so I do not have to type all the values)
1. Why don't you insert as many duplicate records as you need at the first time itself.
2. If point 1 makes no sense, then, you can create a functionality which would simply do - insert into tab select * from tab where <restrict number of records here>;
|
|
|
Re: forms 6i duplicate record [message #600284 is a reply to message #600278] |
Mon, 04 November 2013 11:40 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Right, point 1 makes no sense. Neither does point 2.
Forms does that itself; when you run a form, navigate to an empty record (that would be, by default, the last one within a block. Or, create a new record by pushing the appropriate button in form's toolbar). Then choose "Record" menu and "Duplicate", which would copy contents of the above record into the newly created one.
![/forum/fa/11226/0/](/forum/fa/11226/0/)
As of a shortcut key: see contents of the FMRWEB.RES file (or, possibly, other .RES files you have). For some more info, have a look at Mapping Functional Keys in Forms 6i discussion; it is rather old, but you might find it useful.
[Updated on: Mon, 04 November 2013 11:48] Report message to a moderator
|
|
|
Re: forms 6i duplicate record [message #600300 is a reply to message #600284] |
Mon, 04 November 2013 14:18 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.gravatar.com/avatar/1229663c86eb1a441385fe710cd9116e?s=64&d=mm&r=g) |
mughals_king
Messages: 392 Registered: January 2012 Location: pakistan
|
Senior Member |
|
|
Frnd @littlefoot already explained you brilliantly no doubt about that but my question is to you that your block is multi-record-block 2ndly are you trying to check duplication on multi-record-block like
let suppose you have in your form tabular field
item no.
1001
1001--->here if same num. is comming again should message display "Duplicate Record".if yes then you can check duplication very easily.
anyway as i said @littlefoot is already explaind you. then no need.
Regard
Mughal
[Updated on: Mon, 04 November 2013 14:20] Report message to a moderator
|
|
|