Devart Forums

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

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