hi
i am using adoquery to insert value,as i want to insert more values, therefore i have several lines.
but i got the error "false syntax near to ')'"
i have checked my code but i didnt find it why it gives me error,could anybody please help me?

markieren

Code:

        ADOQuery1.Close;
        ADOQuery1.SQL.Clear;
        ADOQuery1.SQL.Add('select msname, msdate,msid,mspid');
        ADOQuery1.SQL.Add(',VZORT,VZID,ZSID,VZORG,VZNAME,NAME_ORG');
        ADOQuery1.SQL.Add(',VZOK,VZIT,MZS');
        ADOQuery1.SQL.Add('FROM TableA') ;
        ADOQuery1.Open;

        ADOQuery2.Close;
        ADOQuery2.SQL.Clear;
        ADOQuery2.SQL.Add('INSERT TableB (msname, msdate,msid,mspid,)');
        ADOQuery2.SQL.Add('(VZORT,VZID,ZSID,VZORG,VZNAME,NAME_ORG,)');
        ADOQuery2.SQL.Add('(VZOK,VZIT,MZS)');
         
        ADOQuery2.SQL.Add('VALUES(:msname, :msdate,:msid,:mspid,)');
        ADOQuery2.SQL.Add('(:VZORT,:VZID,:ZSID,:VZORG,:VZNAME,:NAME_ORG,)');
        ADOQuery2.SQL.Add('(:VZOK,:VZIT,:MZS)');

Hi,

You probably have to remove your brackets in the second and third line of your field and value specification. There's just 1 bracket to open and 1 to close the field/value enumeration.

markieren

Delphi-Quellcode:

ADOQuery2.SQL.Add('VALUES(:msname, :msdate,:msid,:mspid,');
ADOQuery2.SQL.Add(':VZORT,:VZID,:ZSID,:VZORG,:VZNAME,:NAME_ORG,');
ADOQuery2.SQL.Add(':VZOK,:VZIT,:MZS)');

Usually it also is "insert INTO table". But maybe your DBMS supports a slightly different syntax.

Zitat von Neutral General:

Hi,

You probably have to remove your brackets in the second and third line of your field and value specification. There's just 1 bracket to open and 1 to close the field/value enumeration.

markieren

Delphi-Quellcode:

ADOQuery2.SQL.Add('VALUES(:msname, :msdate,:msid,:mspid,');
ADOQuery2.SQL.Add(':VZORT,:VZID,:ZSID,:VZORG,:VZNAME,:NAME_ORG,');
ADOQuery2.SQL.Add(':VZOK,:VZIT,:MZS)');

Usually it also is "insert INTO table". But maybe your DBMS supports a slightly different syntax.

thanks, i have solved it