SQL Insert Syntax

Devin Asay devin_asay at byu.edu
Fri Jan 5 16:18:56 EST 2018


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 at lists.runrev.com<mailto:use-livecode at 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 at lists.runrev.com<mailto:use-livecode at 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




More information about the use-livecode mailing list