SQL Lite Command not Working

[dementor]

I am able to Query the Data from the SQL but When giving Command to Insert the Data It is showing False

All Type are TEXT for the table

[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 …

[Andrew_Hannell]

These are the Slingshot nodes- right ?

In the post @SeanP included- I noted that you need to use the ‘command’ node for an insert query.

I’m not sure why this is, as in normal SQL parlance a ‘query’ is any kind of code/commands- i.e SELECT, INSERT, UPDATE, TRUNCATE etc
Maybe is is the more usual meaning of a query just being an interrogation i.e SELECT

As @SeanP noted- you need to get the concatenation connect- the SQL query string will need quotes around text values- also detailed in the linked post

[Andrew_Hannell]

Should have added- it can be useful to copy/paste the SQL output string from Dynamo into a tool where you can run SQL queries- it may give a meaningful error or help in troubleshooting