problem with DB Tools Insert Data VI

[ycg44]

Just beginning to try to use the DB tools in LV11.  The Insert Data VI is giving me errors (-2147217900) just tring to put a cluster of five strings into a table.  I cannot see what I am doing wrong.  Can someone see it.  Screen captures attached.

Steve

[jcarmody]

My first thougt is that "Date" is a protected word in Access, but I can't test it now.  Try changing that and see if it works.

[ycg44]

I changed to a different element in the cluster and I got the same error.  But what difference would that make anyway.  I am just making a cluster of the string contents not the element names?  Right?

Steve

[ben64]

I would try removing the Table part of CalFileTable (anyway you know that CalFile will be a table). Since its a syntax error it would be interesting to see the content of the strings you are writing to the Insert Data.vi.

EDIT: Removing Table from CalFileTable will have no effect.

Ben64 

[jcarmody]

---

@ycg44 wrote:

I changed to a different element in the cluster and I got the same error.  But what difference would that make anyway.  I am just making a cluster of the string contents not the element names?  Right?

Steve

---

...

[Dennis_Knutson]

Of course it matters if you use a reserved name. The SQL statement uses the column name. This is one issue with the db toolkit. It hides the underlying syntax.

[mikeporter]

Where are you creating the table, that is where the error is but I don't see the code. For what it's worth using a reserved word as part of a name that is all one word will not cause a problem. You can't call a table "update" but "data_update" would be fine.

You should consider dropping the DCT for the exact reason Sir Dennis gave... If you are interested there are good alternatives.

Mike...