SQLite Problem in 4.5

[Peter Haworth]

Hi Bob,
The double bar is a concatenation operator, same as the & in LiveCode

Pete Haworth

On Nov 15, 2010, at 2:35 PM, Bob Sneidar wrote:

> Peter, I do not know what the double bars are in an SQL statement.  
> What do they do?
>
> Bob
>
>
> On Nov 13, 2010, at 9:59 AM, Peter Haworth wrote:
>
>> Just ran into a serious problem with and SQLite SELECT statement in  
>> 4.5.
>>
>> I'm selecting data from my database with the following SQLite  
>> statement
>>
>> put revDataFromQuery(,,gDBID,myLine) after tdata
>>
>> myline contains SELECT PlaceID, Name || ',' || City || ',' || State  
>> AS Location FROM Places ORDER BY Name
>>
>> In 4.0, this successfully selects all the correct data.  In 4.5 is  
>> selects only 2 rows.  Same codebase, same database.  Executing the  
>> SELECT in 2 or 3 different SQLite query utilities returns the  
>> correct data
>>
>> Has anyone run into this type of issue with 4.5?
>>
>> Pete Haworth
>>
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> use-revolution mailing list
>> use-revolution at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your  
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-revolution
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>