SQLite Android and WM 16 error - WinDev Mobile 17 - Forums développeurs

Connexion

Accueil → WinDev Mobile 17 → SQLite Android and WM 16 error

SQLite Android and WM 16 error

RÉSOLU

Débuté par Maurizio Ettori, 14 nov. 2011 11:59 - 2 réponses

Maurizio Ettori

http://hostimage.webdev.info/avatars/default.gif

Posté le 14 novembre 2011 - 11:59

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

Vous devez être connecté pour évaluer ce message

Joey Dieleman

Posté le 22 novembre 2011 - 18:46

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

Maurizio

Posté le 23 novembre 2011 - 18:47

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