error in "insert into"

[question]

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.

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