SQLite Can't Connect

[Andrew_Hannell]

Isn’t this the same question that you already asked in a different post (and I’ve already answered) ?

In SQL syntax, column names with spaces need to be enclosed in square brackets. As I’ve said, the simple solution is to not use spaces in column names. Otherwise, put your column names in square brackets in Dynamo.

Put a watch node on your SQL.InsertInto node and you will see that it is not properly formed SQL
it needs to be:
Insert into TABLE([Field 1]) values ('xxxx1234')
not
Insert into TABLE(Field 1) values ('xxxx1234')

How to send data from Revit to SQLite database

As Jacob suggested- you need to use the SQLite_Command node (not query) [20180425%20Dynamo%20sqlite] Your code block node is red because the syntax to build the SQL query string is not correct. You need to concatenate everything to form the SQL Fields whose data may contain spaces need to be enclosed in a ’ character, and need to be enclosed in " for Dynamo to treat it literally- so yours would be something like: "insert into DR_Schedule (RoomElementId,RoomLevel) values (" + RoomElementId …