forms 6i duplicate record [message #600274] |
Mon, 04 November 2013 10:28 |
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 |
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 |
|
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.
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 |
|
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
|
|
|