when I put this statement in TOracleScript, can the component detect this statement as a whole to be pass into onCommand event ?
merge
into contract a
using customer b
on (a.cust_id = b.cust_id)
when matched then
update set a.desc = b.profile,
a.customer_name = b.cust_name,
when not matched then
insert values ( b.profile,
b.cust_name);
And, do you have any idea when MERGE feature will be included in your next release ?
Reagards
Aik Hooi