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
[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
