Le 30 mars 06 à 05:51, Norman Palardy a écrit :
On Mar 29, 2006, at 5:03 PM, Gary Edge wrote:
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.
Try :
"SELECT "+ fieldA +","+ fieldB +","+ fieldC +" FROM tableA"
where fieldA, fieldB and fieldC are strings.
@+
--
Thierry NAUZE Saint-Denis de la Réunion
Comparatif Import-Export Gedcom : http://perso.wanadoo.fr/cajun/
Logiciel de généalogie ohmiGene : http://www.nauze.com/
_______________________________________________
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>
