0
In Delphi XE4, SQL Server 12, connected by ADOConnect
.
ADOCommand1.commandText
being 'insert into tabela (a,b,c) (1,1,1)'
It works as expected if a record already exists. But if it is the first record the message appears:
"An empty line cannot be inserted, the line must have at least one defined column value"
Despite the message, the record is included, checked by a later query.
Details are missing but I believe that in the second INSERT no values are passed to the object.
– Motta
I think the correct syntax would be
INSERT INTO TABELA (a, b, c) **VALUES** (1, 1, 1)
, nay?– user7261