Page 1 of 1

How dynamicly create sqlinsert, sqlmodify, sqldelete section in ODAC TSmartQuery

Posted: Fri 17 Feb 2006 14:01
by JarekMazur
Hi
How dynamicly create sqlinsert, sqlmodify, sqldelete section in ODAC TSmartQuery as SQL Generator in SmartQuery Editor it does.

Posted: Fri 17 Feb 2006 15:45
by Challenger
The TOraSmart query will automaticaly generate all these SQL statements when neded if you set KeyFields property or include RowID fields in your SELECT SQL statement. For more information please read ODAC help, the topic "Updating data with ODAC dataset components"