SQL Lite Command not Working

[SeanP]

I think it’s probably how your concatenating your command.

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 …