HExecuteQuery Problem

Hi:

I am new to WinDev Mobile 12 and have just finished my first mobile application. After much trial and error, I have managed to learn the proper process to create and deploy setup files but am still having an issue with the application.

It is worth noting that in test on the development station (actual test or Debug on the dev computer), the application runs beautifully.

When I try to deploy it to the PocketPC however (an HP iPAQ 211 w/ Windows Mobile 6), the application crashes the first time a query is called using HExecuteQuery. This happens when the user attempts to log in from the sign-in screen.

I've added popup windows to verify the the application is loading the query parameters correctly and that it is actually getting to the HExecuteQuery statement.

When the HExecuteQuery is called, the application freezes briefly then presents the dreaded WinCE501bException error.

error data for this is below...

EvntType: WinCE501bExceptio
AppName: MSA_DOC.exe
AppVer: 1.0.0.0
AppStamp: 4836cd7c
ModName: wp120hf.dll
ModVer: 12.0.11.700
ModStamp: 48b50c11
Offset: 001c6fe4
OwnName: MSA_DOC.exe
OwnVer: 1.0.0.0
OwnStamp: 4836cd7c

Exception Information

API Cur Process: 0x00000000
API Cur Thread: 0x00000000
API Own Process: 0x00000000
Info Flags: 0x0000000C
Current Process: 0x44ff7266
Faulting Thread: 0x4509772E
Owner Process: 0x44ff7266
Code: 0x00000002
Flags: 0x00000000
Record: 0x00000000
Address: 0x012c6FE4
Parameters: 0

System Information

OS Version: 5.2.1711.3
LCID: 1033
CPU Architec: 5
CPU Type: 2577
CPU Level: 4
CPU Revision: 1
Machine: 0x01C2
OEM String: hp iPAQ 210
Platform: PocketPC
Platform Ver: 4.0

Module List

Name
NK.EXE
Gwes.exe
MSA_DOC.exe
Wp120sql.dll
Wp120std.dll
Wp120obj.dll
Wp120hf.dll
Wp120img.dll
Wp120vm.dll
Shutil.dll
Tshres.dll.0409.mui
Tshres.dll
Shlwapi.dll.0409.mui

My Code for the sign-in button is below... Any help would be most appreciated. I'm pretty sure I am missing some DLL or there is some other silly problem. I installed the PC Soft framework separately on the iPAQ and have directed the application to use the existing framework during installation. I also tried to load the framework files with the executable but had the same problem.

Note that in the code snippet below I have removed the code for the popup windows I used to verify that the application was reaching the HExecuteQuery statement.

****** Code snippet follows ******

ResExecute is boolean = False

QRY_GetUserID.User = EDT_User
QRY_GetUserID.Password = EDT_Password


ResExecute = HExecuteQuery(QRY_GetUserID)


IF ResExecute = True THEN

HReadFirst(QRY_GetUserID)

IF QRY_GetUserID.User_TableID > 0 THEN

gsUser = QRY_GetUserID.UserID
gsUserID = QRY_GetUserID.User_TableID
gsUserRole = QRY_GetUserID.Role_Name
gsUserName = QRY_GetUserID.UserName
gsAdminGroup = QRY_GetUserID.GroupAdminID

// Get Clinic Name

QRY_GetClinic.User = gsUserID

ResExecute = HExecuteQuery(QRY_GetClinic)

IF ResExecute = True THEN

HReadFirst(QRY_GetClinic)


gsClincName = QRY_GetClinic.Clinic_Name
gsHospital = QRY_GetClinic.Hospital

// Open Branding Page
Use(WIN_Branding)

END

ELSE

// display error message

Error("The selected user name and password could not be found. ")

END



ELSE

// display error message

Error("Hyper File error: " + HError())


END


***** End code snippet *****

Any help would be very much appreciated!!!

thanks!
John Rushing
jrushing@jprushing.com

Une application faite avec WDMobile 15 se joint à des données HyperFile Classique en rpc (WDServerRPC.exe) qu'on trouve sur un Serveur. J'éprouve à des légères les tableaux dell' ; analyser et je ne réussis pas à lancer Requette ou Leggere ou écrire sur ces tableaux ou de base des données. M'envoyez-vous un code d'exemple qui va derrière la fenêtre d'Initialisation et le code qui va derrière le Bouton ? En Italie pas esistone Guides ou Livres pour Windev. Pour il est très difficile trouver matériel utile, me reste seul le Forum Saluts Monde

mondoc@tiscali.it