PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WINDEV Mobile 2024 → android access sqlite with no analysis?
android access sqlite with no analysis?
Débuté par jose javier, 07 nov. 2012 12:16 - Aucune réponse
#1
Posté le 07 novembre 2012 - 12:16
hi. i have an external sqlite database file that i need to use with windev mobile, i make the connection ok with this code:
----------------------------------------------------------------------
Conex_news..Provider = hNativeAccessSQLite
Conex_news..User = ""
Conex_news..Password = ""
Conex_news..Source = "news.sqlite"
Conex_news..Database = ""
Conex_news..Access = hOReadWrite
Conex_news..ExtendedInfo = "PRAGMA synchronous=0;PRAGMA auto_vacuum =ON;PRAGMA foreign_keys=0;"
IF HOpenConnection(globals.Conex_news)=False THEN
endprogram()
END
----------------------------------------------------------------------
here is all ok but i can do nothing with this, for example:
----------------------------------------------------------------------
mycursor is data source
instr is string="select codeid,name from my_table order by name"
IF HExecuteSQLQuery(mycursor,Conex_news,hquerywithoutcorrection,instr)=False THEN
error(herrorinfo())
END
----------------------------------------------------------------------
here the error returned is that my_table is not in the analysis, then i can't do nothing.

Can i use an external sqlite database without declare the tables in any analysis?
i test same application without analysis and then return that the app have no analysis and can't work with databases...

yes, develop 10 times faster... but 1 week of work and i don't have nothing... with eclipse and android framework in 1 week my app was working fine
→ Revenir à WINDEV Mobile 2024