Hi all!
I’ve looked for this for a couple of days. I’m hoping someone will see what is causing this error.
The operation Insert cannot accept the arguments: , [Instructions], [CRCData], [Blah Blah Blah]
I have several SQLite Inserts set up the same way that work just fine. This one does not:
I drop and then re-create the table at the beginning of Screen1:
CREATE TABLE IF NOT EXISTS Instructions (‘id’ INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, ‘CRCData’ TEXT);
The data comes from Airtables and is put into the global “lstInstructions” and then fed into the local “list” in the insertTblInstructions proc:
Any help would be greatly appreciated!
-Kevin
Rogerio_Rios
(Professional Support)
#2
What are the Values ?
Where is It ?
If you want to record N records, you have to do Insert N times…
Thanks for your reply!
That is the value, only one record, only one item in the list.
global Instructions = “Instructions”
global CRCData = “CRCData”
The table name is “Instructions” and the column name is “CRCData” in both the Airtables base and the SQLite DB.
-Kevin
Rogerio_Rios
(Professional Support)
#4
Have you tested whether they are a list?
So it works:
Yep. The values were NOT a list, but the variable was… I changed it to a text variable and the problem went bye-bye.
Thanks for your help!
-Kevin
1 Like
system
(system)
Closed
#6
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.