what different using MyUpdateSQL and insertsql, modifcationsql,deletesql in TmyQuery ??

JiguJigu · Post by **JiguJigu** » Wed 17 May 2006 06:27

hi..
I am beginner, and i have some question..

what different using MyUpdateSQL and insertsql, modifcationsql,deletesql in TmyQuery ??

I am using mySql server 5,. delphi7 and CoreLab 3.5

thank's
Jigu

Antaeus · Post by **Antaeus** » Wed 17 May 2006 09:13

These properties are described in MyDAC Help. Also you can refer to this topic of MyDAC FAQ.

JiguJigu · Post by **JiguJigu** » Wed 17 May 2006 09:50

ok .. thank's

Use a TMyUpdateSQL object to provide SQL statements used to update read-only datasets represented by TMyQuery or TMyTable components

Antaeus · Post by **Antaeus** » Thu 18 May 2006 09:46

You are right. Note, you can use one of the following two ways. First, you can use TMyUpdateSQL component. Second, you can use properties SQLInsert, SQLDelete, SQLRefresh, SQLUpdate of TMyTable or TMyQuery components. It has no fundamental importance, but we think that the way without TMyUpdateSQL component is more convenient.