I'm trying to write some datasets to a Access Database by using the UcanAccess-Driver as recommended here in the forum. This works quite well. The Database-File is used as an Input-File for another Software-Tool which checkes for the required data columns.
On table in this database is used to draw different schematics in the UI of the Software-Tool.
Therefor the required schema looks like:
ID, rX:1, rX:2, rX:3, rY:1, rY:2, rY:3
Using the "Database SQL Exectutor" Node with the following Statement:
CREATE TABLE [IntGrfcon]
The Table is succesfully generate within the Access Database. But when writing the Data via the DatabaseWriter with the same Column names I get the Error Message:
Execute failed: UCAExc:::3.0.4 unexpected token: rX:1
I tested also the "Database SQL Exectutor" Node with the INSERT Statement. Using the Quatation Characters "[" & "]" like in the example below, everything works.
INSERT INTO IntGrfcon ([colon:1])
At the moment I use some VBA Code in Access to rename the column after the data is write to the database and before importing into the softwaretool.
So is there a possiblity adapt the DatabaseWriter to use "[ ]" as quation charators ?