Yet another "The operation Insert cannot accept the arguments" error

Hi all! :grin:

I’ve looked for this for a couple of days. :thinking: 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:

Screenshot_20210325_143247

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:

Screenshot_20210325_142023

Any help would be greatly appreciated! :sunglasses:

-Kevin

What are the Values ?

Screenshot_20210325-200244

Where is It ?

If you want to record N records, you have to do Insert N times…

Thanks for your reply! :smile:

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

Have you tested whether they are a list?

So it works:

sqliteinsert

Yep. The values were NOT a list, but the variable was…:stuck_out_tongue_closed_eyes: I changed it to a text variable and the problem went bye-bye.

Thanks for your help! :smile:

-Kevin

1 Like

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.