PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEV, WEBDEV and WINDEV Mobile

Home | Recent messages | Connect |  | English US
Home → WINDEV Mobile 2024 → android access sqlite with no analysis?
android access sqlite with no analysis?
Started by jose javier, Nov., 07 2012 12:16 PM - No answer
#1
Posted on November, 07 2012 - 12:16 PM
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
→ Go back to WINDEV Mobile 2024