I have to modify exisiting data import function which works IN LOOP like:
get data from text> put into datastore (via INSERT ROW(0) > 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.