Hi All,
For some reason I was under the impression that I could write a query
statement that contained an expression that combined columns in the
result.
e.g.:
"select FieldA + ',' + FieldB, Field C from tableA"
where FieldA could be a last name and FieldB the first name and
FieldC could be the age. So a row returned in the recordset would
return idxfield(1) = "Edge, Gary" and idxfield(2) = 36.
I've looked through the SQLite.org site and experimented some but
haven't found if SQLite supports this.
Gary
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|