-
Michał Misijuk
- PowerBuilder
- Tuesday, 10 September 2019 12:37 PM UTC
I have to modify exisiting data import function which works IN LOOP like:
update ( which causing insert into table....).
my goal is to modify it to work like:
add, new column - operation
if operation = 'new' then do as above,
if operation = 'delete' then update column active
if operation = 'update' then update multiple columns
problem is that once a record appear in datastore by insert row command, powerbuilder always generates insert, but i need update.
is there a way, to i don't know - create another datastore, and in every loop iteration add this record there, and then one datastore will be shooting inserts in DB, and the other one - updates?
PS in very tough situation i thought about some temparary table which powerbuilder will be filling and run some procedure on DB which will be working on records from this table.
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.