Hi,
SQLUpdate property of TMSQuery is only working when CursorType is ctDefaultResultSet.
How can i working SQLUpdate property CursorType is ctKeySet?
SQLUpdate property of TMSQuery
Re: SQLUpdate property of TMSQuery
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
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
Yes it works. Thank you.
Re: SQLUpdate property of TMSQuery
hello,
Glad to see that the problem was solved. If you have any other questions, feel free to contact us.
Glad to see that the problem was solved. If you have any other questions, feel free to contact us.