Re: [sqlite] [EXTERNAL] Bind Question -- Is this correct?

2018-07-03 Thread Stephen Chrzanowski
Thanks for the replies gents. This just caught me off guard a bit and needed a check. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [EXTERNAL] Bind Question -- Is this correct?

2018-07-03 Thread Hick Gunter
V1 uses the value bound to the SQL Variable while performing the concatenation of the text literal '+', the value cast as text, and the text literal 'hours' V2 expects (wrongly) that the text literal '+:StartTimehours' magically replaces part of the string with the value of an SQL variable