It works because SQLite knows that people often mix single quotes and double quotes. So when it sees something in double quotes it first tries to match some identifier to that and if it fails then SQLite considers it as a string constant.
Pavel On Wed, Feb 3, 2010 at 5:20 PM, Ron Hudson <[email protected]> wrote: > Pavel Ivanov wrote: >> String constants should be enclosed in single quotes. Double quotes >> are for identifiers. So in your case you make perfectly legal no-op >> action - update field R with value of field R, i.e. leave field R >> unchanged. >> >> Pavel >> > Thanks Pavel, that works.. > > Hmm I wonder why "insert into checks > values(null,"","value","value",1234.56....);" works... no matter. > > Ron. > > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
