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

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
JarekMazur
Posts: 1
Joined: Fri 17 Feb 2006 13:52

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

Post by JarekMazur » Fri 17 Feb 2006 14:01

Hi
How dynamicly create sqlinsert, sqlmodify, sqldelete section in ODAC TSmartQuery as SQL Generator in SmartQuery Editor it does.

Challenger
Devart Team
Posts: 925
Joined: Thu 17 Nov 2005 10:53

Post by Challenger » Fri 17 Feb 2006 15:45

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"

Post Reply