|
Iniciado por Sebastian Arnold, jul., 01 2011 3:24 PM - 4 respostas |
| |
| | | |
|
| |
Publicado em julho, 01 2011 - 3:24 PM |
I'm just wondering. I do a simple project with an analysis and two or three tables in WinDev Mobile 16. I generate the analysis and: I can't create the tables! 'Create the data file' in the menue is always grayed out.
If I check my connection everything seems to be ok.
Do you really want to tell me that I have to create the tables by myself, copy them to the phone and extract it with fExtractResource()?
TIA Sebastian
-- http://arnoldconsult.de |
| |
| |
| | | |
|
| | |
| |
Membro registado 11 mensagems |
|
Publicado em julho, 29 2011 - 1:14 PM |
I have exactly the same problem - di you find a solution ... I am using sqlite3 command line to do "create" commands so that the database matches the analysis .. pretty pointless |
| |
| |
| | | |
|
| | |
| |
Membro registado 11 mensagems |
|
Publicado em julho, 29 2011 - 1:15 PM |
Curiously, my app HAS to copy the database and fextractresource() it as otherwise it simply wont work ... the examples provided with WinDev Mobile don't seem to need to ..... they obviously know something I don't but I can't find it in the doc, tutorials, help, forum, google search, ....... it would be helpful if the examples were more transparent |
| |
| |
| | | |
|
| | |
| |
Publicado em julho, 29 2011 - 3:40 PM |
Robert,
A few days ago I got an answer from support:
IF you create HyperFileSQL tables IN the analysis, you must Use
HOpenConnection AND HChangeConnection.
IN your CASE, you just Use : HCreationIfNotFound.
This is because I took a look into the examples as well. So the trick seems to be, you create the tables in your analysis with plain HyperFileSQL tables.
Then you build a switch in your project code like this
IF InAndroidMode() THEN
IF HDescribeConnection(MyConnection1,"","","YouDataBase.sqlite","",hAccessSQLiteAndroid,hOReadWrite) = False THEN Error("Unable to describe the connection", HErrorInfo(hErrMessage)) EndProgram(True) END
IF HChangeConnection("*",MyConnection1) =False THEN Error("Unable to change the connection", HErrorInfo(hErrMessage)) EndProgram(True) END
END
IF HCreationIfNotFound("*") =False THEN Error("Unable to create the data files", HErrorInfo(hErrMessage)) EndProgram(True) END
BTW, better put this in a global function so you can use it in any other Android project.
HTH Sebastian
-- http://arnoldconsult.de |
| |
| |
| | | |
|
| | |
| |
Publicado em outubro, 27 2011 - 7:48 PM |
Hi, Same problem for me. I did create the files with SQLite Maestro. After that from Windevmobile 16 using WDMP was OK, but i couldn't see any record!! From windev16 i cannot write or read any record in the Sqlite file !! Nicolas
Sebastian Arnold a écrit dans le message de news <bf97fa31b423ab4fbe7f3d4f8f56685f@news.pcsoft> :
I'm just wondering. I do a simple project with an analysis and two or three tables in WinDev Mobile 16. I generate the analysis and: I can't create the tables! 'Create the data file' in the menue is always grayed out. If I check my connection everything seems to be ok. Do you really want to tell me that I have to create the tables by myself, copy them to the phone and extract it with fExtractResource()? TIA Sebastian -- http://arnoldconsult.de |
| |
| |
| | | |
|
| | | | |
| | |
|