Page 1 of 1
SQLUpdate property of TMSQuery
Posted: Sat 28 Apr 2012 10:50
by Zebedee
Hi,
SQLUpdate property of TMSQuery is only working when CursorType is ctDefaultResultSet.
How can i working SQLUpdate property CursorType is ctKeySet?
Re: SQLUpdate property of TMSQuery
Posted: Sat 28 Apr 2012 11:35
by AlexP
hello,
Such behavior is due to that you are using a server cursor (ctKeyset), and UPDATE is "formed" directly at the server. If you want to use the SQLUpdate property with a server cursor, you should set the MSQuery1.Options.CursorUpdate option to False, in this case the SQL specified in the SQLUpdate property will be used
Re: SQLUpdate property of TMSQuery
Posted: Mon 30 Apr 2012 10:21
by Zebedee
Yes it works. Thank you.
Re: SQLUpdate property of TMSQuery
Posted: Mon 30 Apr 2012 10:30
by AlexP
hello,
Glad to see that the problem was solved. If you have any other questions, feel free to contact us.