🚀 go-pugleaf

The SQL should read "Insert Into Shippers Values (%s, %d)".  You don't need
parentheses around the values clause.  With the parentheses it is trying to
interpret what is enclosed as a list of column names...

Thomas wrote in message <7mh1db$oh7$1@news.inet.tele.dk>...
>Hello
>
>I have a problem whit insert into and I have try this
>and get this error massage
>
>Ncorrect syntax near the keyword 'values'
>I uses Delphi3 and sql server 7.0
>
>what have I done wong?
>please  help
>
>
>procedure TForm1.Button1Click(Sender: TObject);
>begin
>with th do
>        begin
>           try
>             Close;
>             SQL.Clear;
>             SQL.Add(Format('Insert Into
>Shippers(Values(%s,%d)',['Thomas',12345]));
>              Prepare;
>              ExecSQL;
>          Except
>             On Exception do
>                raise;
>          end;   {try-except}
>     end;  {with}
>
>end;
>
>
>
>:-) Thomas
>
>