Page 1 of 1

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

Posted: Wed 17 May 2006 06:27
by JiguJigu
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

Posted: Wed 17 May 2006 09:13
by Antaeus
These properties are described in MyDAC Help. Also you can refer to this topic of MyDAC FAQ.

Posted: Wed 17 May 2006 09:50
by JiguJigu
ok .. thank's

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

Posted: Thu 18 May 2006 09:46
by Antaeus
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.