Bob, Some SQL dialects accept both single and double quotes as string delimiters. Might that be the problem?
Devin On Jan 5, 2018, at 2:16 PM, Bob Sneidar via use-livecode <use-livecode@lists.runrev.com<mailto:use-livecode@lists.runrev.com>> wrote: 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 _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com<mailto:use-livecode@lists.runrev.com> Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode Devin Asay Director Office of Digital Humanities Brigham Young University _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
