Oli999
asked on
MS ACCESS ADO SQL QUERY - SYNTAX ERROR IN UPDATE STATEMENT
experts,
what am i doing wrong???
getting syntax error in update statement....
procedure TForm1.Button1Click(Sender
var
crud:string;
result:string;
begin
crud:='1';
result:='300';
ADO.Close;
ADO.SQL.Clear;
ADO.SQL.Add('UPDATE clients SET ');
ADO.SQL.Add('total left = :P_STS' );
ADO.SQL.Add('WHERE clientid = ' + QuotedStr(crud));
ADO.Parameters.ParamByName
Ā ADO.ExecSQL;
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER