The TZUpdateSQL does not save generated sql
Posted: 18.04.2009, 21:07
I set up my TZquery with connection and sql porperties. Also associate with the updatesql.
Then, in updatesql i do a double click, click in the "Get table fields", "Select primary key" and check the option "quote field names" before click in the "Generate SQL". Every thing goes ok (excpt to the insert sql wich generate the params without the : as the first chars, but i will check this later).
When i click ok to close the updatesql sql editor and open again, my sql is gone.
I need to generate the sql again, copy all to a text editor and past in the respective properties DeleteSQL, InsertSQL, ModifySQL.
What do i need to do do to fix this problem ?
Then, in updatesql i do a double click, click in the "Get table fields", "Select primary key" and check the option "quote field names" before click in the "Generate SQL". Every thing goes ok (excpt to the insert sql wich generate the params without the : as the first chars, but i will check this later).
When i click ok to close the updatesql sql editor and open again, my sql is gone.
I need to generate the sql again, copy all to a text editor and past in the respective properties DeleteSQL, InsertSQL, ModifySQL.
What do i need to do do to fix this problem ?