I’m connecting to the database Person in names.nsf with Notes SQL(ODBC,latest version).The following inserts one line:
INSERT INTO Person (FullNameInput, CompanyName,MailAddress) VALUES (‘Test person1’, ‘Testcompany1’, ‘test1@test.com’)
The problem is I can’t insert a second line.
Repeating the same line as above doesn’t work.
Why can I only do 1 insert ? The second one is just ignored !
The strange thing is that I can delete multiple rows at a time …