SQLite Problem in 4.5

[Peter Haworth]

Thanks Bob.  I think the problem may have something to do with NULL  
values in some of the columns coming back from the SELECT.  When I  
fixed them, the SELECT worked fine in LiveCode.  The Firefox plugin  
was one of the utilities I used to check this out and it returned all  
the data correctly, even when there were NULLs in the columns.

Pete Haworth

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

> OK just figured out what the syntax does. I ran this query against a  
> Spiceworks sqLite database, substituting column and table names  
> with  those in the Spiceworks database, and the query worked fine  
> for me. At this point, what I would suggest is getting the sqLite  
> plugin for Firefox and making queries directly against the sqLite  
> database. See what you get then.
>
> 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
>