|
FOROS PROFESIONALES
WINDEV, WEBDEV y WINDEV Mobile |
| | | | | |
| Inicio → WINDEV 2024 → when i have create combo box through datafile in windev mobile 17 |
| when i have create combo box through datafile in windev mobile 17 |
| Iniciado por guest, 08,ene. 2015 07:00 - 6 respuestas |
| |
| | | |
|
| |
| Publicado el 08,enero 2015 - 07:00 |
Sir I have create combo box through DataBase in windev mobile 17
The 'COMBO_Location' control cannot be initialized, the following HyperFileSQL error occurred:
=============================
native SQLite access error.
Error Number = 30
Unable to open or read <Order_12> file.
<Order_12> file not found.
=============================
**********************************************
----- Technical Information -----
What happened?
The 'COMBO_Location' control cannot be initialized, the following HyperFileSQL error occurred:
=============================
native SQLite access error.
Error Number = 30
Unable to open or read <Order_12> file.
<Order_12> file not found.
=============================
Error code: 10085
Level: fatal error (EL_FATAL)
WD55 error code: 3001
Dump of the error of 'wpobj.dll' module (17.0.542.33).
Identifier of detailed information (.err): 10085
Debugging information:
IEWDSQLITE=8.3
Module=<WDSQLITE>
Version=<17.0.27.0>
Provider: WinDevSQLite
Data source: Discovery.db
Database: Discovery.db
Connection time-out: 30
Command time-out: 30
Unicode supported: 1
Page code of WL: 1252
Page code of the connection: UTF-8
Additional Information:
EIT_LOGICALTABLENAME : <Order_12>
EIT_NATIVECODE : <30>
EIT_INFOCLIENT : <3.7.12.1> |
| |
| |
| | | |
|
| | |
| |
| Publicado el 08,enero 2015 - 09:45 |
Hi,
if this happens the first time you start your app, then you need to run HCreationIfNotFound(*) once to create the database.
It could also be that you are referring to a wrong file. I Always use HDescribeConnection and HChangeconnection as mentioned in hits post <a class="ExternalLink" rel="nofollow" target="_blank" href="http://27130.foren.mysnip.de/read.php?27131,144948,144953#msg-144953">http://27130.foren.mysnip.de/read.php…</a> |
| |
| |
| | | |
|
| | |
| |
| Publicado el 09,enero 2015 - 08:40 |
sir
i have returned your solution to provid to problem that code have written in the row selection of combo box filed but same error generated
Why do you need to change the connection?
Use the SQLite connection from/in the analysis!
I'm not sure if it will work in WM but this is how I access SQLite data in WinDev 17:
sConnectionName is string = "CNT_ACCESS"
sAccessType is int = hOReadWrite
sSourceName is string = "C:\MyProjects_WM17\New\Exe\New.db"
sDatabaseName is Data Source= ""
sUserName is string = ""
sPassword is string = ""
IF HDescribeConnection(sConnectionName, sUserName, sPassword, sSourceName, sDatabaseName, hNativeAccessSQLite, sAccessType) THEN
IF HOpenConnection(sConnectionName) THEN
HChangeConnection("*","CNT_ACCESS")
Info("Connection created. Change of connection performed")
ELSE
Error(HErrorInfo())
END
ELSE
Error(HErrorInfo())
END
sir i have written this code in combo box row selection of combo box filed but the have same error problem
The 'LIST_Order1234' control cannot be initialized, the following HyperFileSQL error occurred:
=============================
The HyperFileSQL files are not supported in Android.
Use some SQLite files.
=============================
**********************************************
----- Technical Information -----
What happened?
The 'LIST_Order1234' control cannot be initialized, the following HyperFileSQL error occurred:
=============================
The HyperFileSQL files are not supported in Android.
Use some SQLite files.
=============================
Error code: 10085
Level: fatal error (EL_FATAL)
WD55 error code: 4012
Dump of the error of 'wpobj.dll' module (17.0.542.33).
Identifier of detailed information (.err): 10085
Debugging information:
IEWDHF=32.182
Module=<WDHF>
Version=<17.0.185.0>
Additional Information:
EIT_LOGICALTABLENAME : <Order_1234> |
| |
| |
| | | |
|
| | |
| |
| Publicado el 09,enero 2015 - 08:45 |
I'm not sure if it will work in WM but this is how I access SQLite data in WinDev 17:
sConnectionName is string = "CNT_ACCESS"
sAccessType is int = hOReadWrite
sSourceName is string = "C:\MyProjects_WM17\New\Exe\New.db"
sDatabaseName is Data Source= ""
sUserName is string = ""
sPassword is string = ""
IF HDescribeConnection(sConnectionName, sUserName, sPassword, sSourceName, sDatabaseName, hNativeAccessSQLite, sAccessType) THEN
IF HOpenConnection(sConnectionName) THEN
HChangeConnection("*","CNT_ACCESS")
Info("Connection created. Change of connection performed")
ELSE
Error(HErrorInfo())
END
ELSE
Error(HErrorInfo())
END
And you need maybe HCreationIfNotFound, if you use the database for the first time, so the needed tables would be created. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 09,enero 2015 - 12:48 |
sir
please see the message and reply the answer |
| |
| |
| | | |
|
| | |
| |
| Publicado el 09,enero 2015 - 16:29 |
Rahul,
I would use a sqlite viewer like <a class="ExternalLink" rel="nofollow" target="_blank" href="http://sqlitestudio.pl">http://sqlitestudio.pl</a> and check if the table isn't really there, apart from WM
If you are still testing in the simulator the database is somewhere in de exe-map under your project-map.
On the device you can browse using the native file-explorer and "share" the database to yourself, i.e. by mail.
Apart from that my guess is still you did "forget" to create the files inside the database by using HCreationIfNotFound(). Because by default WM does not do that for you. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 09,enero 2015 - 20:37 |
Hi Rahul
You state:
i have returned your solution to provid to problem that code have written in the row selection of combo box filed but same error generated
Why do you need to change the connection?
I donnot use windev mobile yet but I think adding the connection code in rowselect isnot the palce to do so. I think it is better to profide this code in an initialisation proces.
row select selects a row and if a file isnot availeble a row isnot availeble as well.
regards
allard |
| |
| |
| | | |
|
| | | | |
| | |
| | |
| |
|
|
|