View previous topic :: View next topic |
Author |
Message |
rwatson
Joined: 12 Sep 2006 Posts: 5 Location: Perth, Western Australia
|
Posted: Fri Nov 24, 2006 1:34 pm Post subject: Adding Additional Data to field already containing data |
|
|
I'm trying to update a field with additional data when the field already contains data.
The field I'm updating is the Account Name field in the Customers - Summary form. For example the field already contains data ‘123’ and I would like it to be ‘123,124’. I’ve tried a number of variations after getting to the field ie.
‘Ctrl Right’
‘Ctrl e’ and then ‘Ctrl Right’
‘End’
And each time I playback it overrides the data in the field on leaving ‘,124’
Does anyone have a suggestion as to how I can update the field?
Oracle Applications : 11.5.10.2
Thank you
Renay |
|
Back to top |
|
|
David
Joined: 15 Nov 2005 Posts: 97 Location: Near Heathrow Airport, London
|
Posted: Sat Dec 02, 2006 12:15 am Post subject: |
|
|
I think that you might get some help with your question here:- http://www.dataload.net/help/using/editingcells.htm and http://www.dataload.net/help/macro/keystrokes.htm. It seems to suggest that you should use F2 to toggle between overtype and edit modes.
Now, I don't have access to a system today to test this, but I would try something like this:-
Code: | TAB \{F2} {END} ,124 \{F2} |
So you tab into the field which currently holds the value 123, toggle from overtype to edit mode, go to the end of the field, type ',124' onto the end of the 123 (giving 123,124) then toggle back into overtype mode.
Good luck and HTH
David. _________________ When my time comes,
I want to die like my grandfather did:
quietly and in his sleep.
Not kicking and screaming like the passengers in his car.
David K. Dickson
DataLoad Forum Moderator |
|
Back to top |
|
|
rwatson
Joined: 12 Sep 2006 Posts: 5 Location: Perth, Western Australia
|
Posted: Mon Dec 04, 2006 10:04 pm Post subject: |
|
|
Thanks for your advice David
I gave the F2 a whirl and it didn't work, still left me with ',124'.
I also tried the double-clicking into the cell as mentioned in the link and the same thing happened as above.
I have tried a load using DL Classic and editting the field works however it is not reliable, and unfortunately this is not acceptable to my management.
Renay |
|
Back to top |
|
|
David
Joined: 15 Nov 2005 Posts: 97 Location: Near Heathrow Airport, London
|
Posted: Wed Dec 06, 2006 7:40 am Post subject: |
|
|
Renay,
Humblest apologies, I completely forgot that you are using Forms Playback, and gave you an answer that was only appropriate to Macro Load. Forms Playback can not append data to an existing field. However .....
If you can extract (into Excel) the records that need changing, you can then append any data you want using CONCATENATE(a,b,c,....) so that you have a cell containing the new value 123,124 then you can load this using Forms Playback.
Hope this helps more than my last reply.
David. _________________ When my time comes,
I want to die like my grandfather did:
quietly and in his sleep.
Not kicking and screaming like the passengers in his car.
David K. Dickson
DataLoad Forum Moderator |
|
Back to top |
|
|
rwatson
Joined: 12 Sep 2006 Posts: 5 Location: Perth, Western Australia
|
Posted: Wed Dec 06, 2006 5:35 pm Post subject: |
|
|
Hi David
No need to apologise. Thanks for your assistance, greatly appreciated.
Cheers
Renay |
|
Back to top |
|
|
|