error in "insert into"

Thema durchsuchen

Ansicht

Themen-Optionen

Ein Thema von question · begonnen am 19. Dez 2013 · letzter Beitrag vom 19. Dez 2013

Vorheriger Beitrag

Nächster Beitrag

Neutral General

Registriert seit: 16. Jan 2004
Ort: Bendorf
5.219 Beiträge

Delphi 10.2 Tokyo Professional

AW: error in "insert into"

19. Dez 2013, 08:39

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.

Michael

"Programmers talk about software development on weekends, vacations, and over meals not because they lack imagination,
but because their imagination reveals worlds that others cannot see."