HELP-----Insert into

Article View: comp.databases.ms-sqlserver

Article #132

Back to comp.databases.ms-sqlserver Previous Next

#132

From: Thomas
Date: Wed, 14 Jul 1999 00:00

34 lines
1378 bytes

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

Technical Details

Message-ID: <7mh1db$oh7$1@news.inet.tele.dk>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff490,7744181f07638e26,start
X-Google-Attributes: gidff490,public
X-Google-Thread: 104de1,7744181f07638e26,start
X-Google-Attributes: gid104de1,public
From: "Thomas" <helligso@post6.tele.dk>
Subject: HELP-----Insert into
Date: 1999/07/14
Message-ID: <7mh1db$oh7$1@news.inet.tele.dk>
X-Deja-AN: 500787131
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
X-Complaints-To: Department of Abuse <abuse@news.inet.tele.dk>
X-Trace: news.inet.tele.dk 931924203 25127 195.249.155.52 (14 Jul 1999 03:50:03 GMT)
Organization: Customer of Tele Danmark Internet
NNTP-Posting-Date: 14 Jul 1999 03:50:03 GMT
Newsgroups: comp.databases.ms-sqlserver,cz.comp.microsoft.sql