SQL Insert Syntax

Bob Sneidar bobsneidar at iotecdigital.com
Fri Jan 5 16:16:12 EST 2018


Can anyone find anything wrong with this sqLite insert statement? 

INSERT INTO arraydata ("rect","controlname","owner","visible") VALUES ('0,43,500,543','image "fresh_snow.png"','card "Main"','false')

It doesn't generate an error, but neither does it insert anything! There is a primary key column that I don't include because it's supposed to auto increment automatically if no column/value is supplied. 

Bob S






More information about the use-livecode mailing list