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

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 à ...