how to get the update query on Post using TMSQuery?

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
galit
Posts: 19
Joined: Mon 12 Feb 2007 11:07

how to get the update query on Post using TMSQuery?

Post by galit » Thu 27 Aug 2020 21:53

Hello,

is any option to get Update SQL on Post method using DataSet functionality?

for example:
q := TMSQuery.Create(nil);
q.Connection := con;

q.SQL.Text := 'SELECT * FROM STOCK WHERE PART = 'XYZ'';
q.Open;

q.Edit;
q.FieldByName('COND').AsString := 'NEW';
q.Post;

I expect to see before doing Post the following sql
UPDATE STOCK SET COND = 'NEW' WHERE PART = 'XYZ'

Thanks

Stellar
Devart Team
Posts: 496
Joined: Tue 03 Oct 2017 11:00

Re: how to get the update query on Post using TMSQuery?

Post by Stellar » Mon 31 Aug 2020 12:45

Unfortunately, we can't only rely on the issue description. In order for us to investigate this issue, we would need a stable example, including database object creation scripts.
You can send the sample using the contact form at our site: devart.com/company/contactform.html

Post Reply