anID:=dm.sqlEmails.FieldByName('zID').AsString; // zID is an AutoInc Primary if turnON then dm.sqlEmails.SQL.Text:='UPDATE sqlEmails SET zSent = 1 WHERE zID = '+anID else dm.sqlEmails.SQL.Text:='UPDATE sqlEmails SET zSent = 0 WHERE zID = '+anID;
MySQL? Postgres? Oracle?Is the Server on Linux?
You can't set the SQL of an open dataset (afaik).
Quote from: rvk on March 14, 2017, 11:59:55 pmYou can't set the SQL of an open dataset (afaik).Yes you can. Use property UpdateSQL. But not how HatforCat is using it, but just a query.
Project project1 raised exception class 'EDatabaseError' with message:Operation cannot be performed on an active dataset