Zeoslib Portal

Thanks for the hint. I'm converting from old sql statement and overlook the merge statement in oracle.
I shall look into this again.
Thank you once again.

I have a joined query, table A left join table B display on single dbgrid. table A data are fixed data and table B is blank initially and pending for user to update. By using updatesql, I'm able to insert / modify table B with the statement in insertSQL and modifySQL. Example with following code, af...

Hi, Just started to switch over to Zeoslib. Everything works fine. I have a question regarding ZUpdateSQL. In BDE or (SQLdirect), I'm able to trigger the updatesql to do an insert using (Query1.UpdateObject as TUpdateSQL).Apply(ukInsert); example below: procedure TForm1.Query1AfterEdit(DataSet: TDat...