LiveCode Forums.

I tried to do this :

• put revDataFromQuery(,,gConID,"SELECT Nom,Prenom FROM PatientsN where Prenom='Hughes' " ) into field 1
That's OK (I have for example this result : DUPONT Hugues,VALENTIN Hugues,MACHIN Hugues, etc... in a table field).

• put revDataFromQuery(,,gConID,"SELECT Nom || ' ' || Prenom FROM PatientsN where Prenom='Hughes' " ) into field 1
The result in a table field is only : D,V,M,etc...

• SELECT Nom || ' ' || Prenom FROM PatientsN where Prenom='Hughes'
used in Sqlite Manager : that's correct -> The result is :
DUPONT Hugues, VALENTIN Hugues, MACHIN Hugues, etc...


What is this problem ?
How is it possible to resolve it ?

Thanks

Edouard

OK. If i write this :
ut revDataFromQuery(,,gConID,"SELECT Nom,Prenom FROM PatientsN where Prenom='Hughes' " ) into field 1
that is correct, I have the good result.