DataLoad Community

[rwatson]

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

[David]

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:-

[rwatson]

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

[David]

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

[rwatson]

Hi David

No need to apologise. Thanks for your assistance, greatly appreciated.

Cheers
Renay