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
how to get the update query on Post using TMSQuery?
Re: how to get the update query on Post using TMSQuery?
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
You can send the sample using the contact form at our site: devart.com/company/contactform.html