PC SOFT

GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEVWEBDEV e WINDEV Mobile

Inicio → WINDEV Mobile 2024 → SQLite Android and WM 16 error
SQLite Android and WM 16 error
Iniciado por Maurizio Ettori, nov., 14 2011 10:59 AM - 2 respostas
Publicado em novembro, 14 2011 - 10:59 AM
Hi, I have create an SQLite db with a table named CICLI. The test connection to the db is OK.
I have create a form and selected from the menù "create looper"
when I run the application I get the error:

the "TableFichiers" control cannot be inizialized.the following HiperFileSql error:

native SqlLite access error:
error number = 30
unable to open or read <CICLI> file

CICLI file not found

regards,
Maurizio
Publicado em novembro, 22 2011 - 5:46 PM
Hi Maurizio Ettori,

You could use HCreationIfNotFound(CICLI) in the project code (or at least before doing any other database actions on this table). The documentation also tells us you can use HCreation(CICLI)

Regards,
Joey
Publicado em novembro, 23 2011 - 5:47 PM
Hi Joey,

thank you very much! Now, it works! Now we have entered a record succesfully in the table and we can see it.

But I don't understand a thing : the SQLite db file (I suppose it is the file named LARGE-MOBILE.db inside the project folder \LARGE-MOBILE ) is always 0 Kb. And if we try to open it (with SQLite desktop) we get an error message (is not recognized as database file).
But what is the SqLite file and is it possible to open it on the pc desktop?

Thanks!
Best regards,
Maurizio