Link to home
Start Free TrialLog in
Avatar of Oli999
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: TObject);

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('P_STS').value := result;
Ā  ADO.ExecSQL;
SOLUTION
Avatar of mokule
mokule
Flag of Poland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Oli999
Oli999

ASKER

total left is a field
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial