SQL(ite) question

Bob Sneidar bobsneidar at iotecdigital.com
Tue Jan 14 13:07:03 EST 2020


Pretty sure + means concatenate, otherwise that SQL statement would not work in any I can imagine. 

Bob S


> On Jan 14, 2020, at 10:05 , Klaus major-k via use-livecode <use-livecode at lists.runrev.com> wrote:
> 
> Hi Bob,
> 
>> Am 14.01.2020 um 19:00 schrieb Bob Sneidar via use-livecode <use-livecode at lists.runrev.com>:
>> 
>> The only problem I see here is that it is possible to get a match with the last part of one column and the first part of the next, especially with numerical data, which would be a false positive. 
> 
> AHA, so SQL treats this:
> ... WHERE ((col1+col2+aCol1+aCol2) ...)
> 
> Like this in LC:
> ... WHERE ((col1 & col2 & aCol1 &aCol2) ...)
> ?
> 
>> Bob S





More information about the use-livecode mailing list