WinDev 14 native MySQL driver

Does anyone knows how to get rid of GPF fault of WD14MSQL.dll when using hReadFirst/last() ? I have to finish the project (started on WD12) but support doesnt answer to my question. here is the error detail:

Error at line 2 of Global Declarations of FRM_AT04Display0 process.
HReadFirst function called.
Unexpected system error.
If this error systematically occurs in the same conditions, contact PC SOFT Hot Line and specify:
- the error circumstances,
- a window, a project or the code lines used to replicate the problem,
- the details below.

Détails techniques :

Module : WD140MSQL.DLL
Version du module : 14.00Ag
VI : 80A140029
Adresse de base : 29660000
Erreur systčme : Access violation (GPF)
EIP = 29668B36
OS : Windows Longhorn Service Pack 1(6.0.6001)

Technical Information

Project : HISATKnin

Dump error of module <WD140VM.DLL> <14.00Qd>.

- WL Call:
Processing <FRM_AT04Display0>, line <2>, thread <0>
Function <HReadFirst>, syntax # <3>

- Level: fatal error (EL_FATAL)

- Error Code: 1020

- WD55 Error Code: 0

- No system error code

- No system error message

- What happened?
Unexpected system error.
If this error systematically occurs in the same conditions, contact PC SOFT Hot Line and specify:
- the error circumstances,
- a window, a project or the code lines used to replicate the problem,
- the details below.

Détails techniques :

Module : WD140MSQL.DLL
Version du module : 14.00Ag
VI : 80A140029
Adresse de base : 29660000
Erreur syst&#269;me : Access violation (GPF)
EIP = 29668B36
OS : Windows Longhorn Service Pack 1(6.0.6001)

- Debug Information:

Détails techniques :

Module : WD140MSQL.DLL
Version du module : 14.00Ag
VI : 80A140029
Adresse de base : 29660000
Erreur syst&#269;me : Access violation (GPF)
EIP = 29668B36
OS : Windows Longhorn Service Pack 1(6.0.6001)
Registres :

EIP = 29668B36 EBP = 0012C2A8
EAX = 000000F0 EBX = 01BE9514
ECX = 00000000 EDX = 01BE94FC
ESI = 000000F1 EDI = 02608B1C

Pile des appels :

[WD140MSQL.DLL (29660000), 14.00Ag, 80A140029 ] 29666690 : Execution() + 9382 bytes
[WD140MSQL.DLL (29660000), 14.00Ag, 80A140029 ] 29684F93 : bDLLCompatible() + 93635 bytes
[WD140MSQL.DLL (29660000), 14.00Ag, 80A140029 ] 29684F93 : bDLLCompatible() + 107961 bytes
[WD140MSQL.DLL (29660000), 14.00Ag, 80A140029 ] 29684F93 : bDLLCompatible() + 105228 bytes
[WD140MSQL.DLL (29660000), 14.00Ag, 80A140029 ] 29684F93 : bDLLCompatible() + 116389 bytes
[WD140MSQL.DLL (29660000), 14.00Ag, 80A140029 ] 2966A267 : GeneralParam() + 97677 bytes
[WD140MSQL.DLL (29660000), 14.00Ag, 80A140029 ] 2966A267 : GeneralParam() + 73968 bytes
[WD140MSQL.DLL (29660000), 14.00Ag, 80A140029 ] 2966A267 : GeneralParam() + 74763 bytes
[WD140HF.DLL (25460000), 14.00Ibb, 01A140029v] 254FD46D : nGetProperty() + 635644 bytes
[WD140HF.DLL (25460000), 14.00Ibb, 01A140029v] 254FD46D : nGetProperty() + 328224 bytes
[WD140HF.DLL (25460000), 14.00Ibb, 01A140029v] 254A2DAC : bDLLCompatible() + 242353 bytes
[WD140HF.DLL (25460000), 14.00Ibb, 01A140029v] 254A2DAC : bDLLCompatible() + 77965 bytes
[WD140HF.DLL (25460000), 14.00Ibb, 01A140029v] 254A2DAC : bDLLCompatible() + 159648 bytes
[WD140HF.DLL (25460000), 14.00Ibb, 01A140029v] 254A2DAC : bDLLCompatible() + 159124 bytes
[WD140HF.DLL (25460000), 14.00Ibb, 01A140029v] 254A2DAC : bDLLCompatible() + 88167 bytes
[WD140VM.DLL (25E60000), 14.00Qd, 01A140029v] 25E78C40 : TermLibrary() + 112242 bytes
[WD140VM.DLL (25E60000), 14.00Qd, 01A140029v] 25FA0CA0 : DeclareProxy() + 308600 bytes
[WD140VM.DLL (25E60000), 14.00Qd, 01A140029v] 25E78C40 : TermLibrary() + 43680 bytes
[WD140VM.DLL (25E60000), 14.00Qd, 01A140029v] 25E78C40 : TermLibrary() + 1248 bytes
[WD140VM.DLL (25E60000), 14.00Qd, 01A140029v] 25EA4B00 : EXT_pszGetMessageErreurDelegue() + 148064 bytes
[WD140VM.DLL (25E60000), 14.00Qd, 01A140029v] 25EA4B00 : EXT_pszGetMessageErreurDelegue() + 148064 bytes

Fonction (7,10)

- Attached Information:
EIT_LOGICALTABLENAME : <clist>
EIT_PILEWL :
Global Declarations of FRM_AT04Display0 (FRM_AT04Display0), line 2
EIT_COMPOSANT :

EIT_DATEHEURE : 10/07/2009 09:45:37

- Identifier in .err: 1020


Message forwarded from pcsoft.us.windev

Remenber: if you think tech support does not answer your mail it's because :
- they don't receive it
- or, you don't receive their mail (did you chek your junk box)

My opinion is that tech support always answers received mails

Robert

Hi,

Try and trap the error with:

IF ErrorOccurred = True THEN
// Full message of the main error
ErrorInfo(errFullDetails)
END


If this does not trap the error then the problem is your table.
1. Check that it has a primary key
2. Use hReadFirst and hReadLast on other tables (simple code and description tables with a primary key)
3. Might try to recreate the table.

Unfortunately, though I am using WD12 and not 14, I do have a lot confidence in the MySQL driver. I have gotten such errors before, but the problem was invariably from me.

Happy hunting

issah