SQLUpdate property of TMSQuery

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Zebedee
Posts: 3
Joined: Sat 28 Apr 2012 10:45

SQLUpdate property of TMSQuery

Post by Zebedee » Sat 28 Apr 2012 10:50

Hi,
SQLUpdate property of TMSQuery is only working when CursorType is ctDefaultResultSet.

How can i working SQLUpdate property CursorType is ctKeySet?

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: SQLUpdate property of TMSQuery

Post by AlexP » Sat 28 Apr 2012 11:35

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

Zebedee
Posts: 3
Joined: Sat 28 Apr 2012 10:45

Re: SQLUpdate property of TMSQuery

Post by Zebedee » Mon 30 Apr 2012 10:21

Yes it works. Thank you.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: SQLUpdate property of TMSQuery

Post by AlexP » Mon 30 Apr 2012 10:30

hello,

Glad to see that the problem was solved. If you have any other questions, feel free to contact us.

Post Reply