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
[email protected]
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
