|
| Started by Sebastian Arnold, Jul., 01 2011 3:24 PM - 4 replies |
| |
| | | |
|
| |
Posted on July, 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 |
| |
| |
| | | |
|
| | |
| |
Registered member
11 messages |
|
Posted on July, 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  |
| |
| |
| | | |
|
| | |
| |
Registered member
11 messages |
|
Posted on July, 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  |
| |
| |
| | | |
|
| | |
| |
Posted on July, 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 |
| |
| |
| | | |
|
| | |
| |
Posted on October, 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 |
| |
| |
| | | |
|
| | | | |
| | |
|