LiveCode Forums.

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.

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 || ' ' || P...

How to know the version of SQLite using Revoluion (Studio 2.0.0) ?
How to update SQLite if necessary ?

Thanks

Edouard

Hello, I am hobbyist developper. I am trying to learm about databases and Revolution. When I create a database with Revolution (with SQLite) and put data into it, after, wher I open this Data Base with Safari (I am under OS X 10.4 PPC), I have some bad characters. For example (I am french): the é (...