PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → Error 70205
Error 70205
Iniciado por Antonio Díaz, 02,feb. 2024 17:44 - 4 respuestas
Miembro registrado
71 mensajes
Popularité : +2 (2 votes)
Publicado el 02,febrero 2024 - 17:44
Hi guys,

I am going crazy with error 70205 when trying to read a record. I've tried it with MS SQL (using ODBC) and realized after much research that I cannot use some H functions with ODBC.

So I switched to PostgreSQL, thinkin it would work since there is a native driver. But to my surprise, I keep getting the same error. Here is my code:

HSeekFirst(MyFile,SomeField,SomeValue)
IF HFound() = True THEN
HRead(MyFile, HRecNum()) *** THIS IS WHERE I GET THE ERROR (NO CURRENT RECORD HAS BEEN DEFINED)

The record is found but the HRead Error still happens. Please help!.. :-(

--

Antonio Diaz
Emphasys Software, S.C.
Miembro registrado
3.358 mensajes
Popularité : +93 (137 votes)
Publicado el 02,febrero 2024 - 18:50
Hi
if the h functions do not work
try to do it with a query
Miembro registrado
71 mensajes
Popularité : +2 (2 votes)
Publicado el 02,febrero 2024 - 21:06
I understand, but is that a common problem? Isn't HSeekFirst supposed to work? May be I am doing something wrong?...

--

Antonio Diaz
Emphasys Software, S.C.
Miembro registrado
126 mensajes
Publicado el 03,febrero 2024 - 09:22
Hi
This is explained in the HRecNum() function documentation

https://doc.windev.com/en-US/…

HFSQL : Available only with these kinds of connection
Non-HFSQL data files :
There is no record number on the data files.
The call to this function triggers a WLanguage error.


As Popoy points out, you have to do it with a query
Mensaje modificado, 03,febrero 2024 - 09:23
Miembro registrado
71 mensajes
Popularité : +2 (2 votes)
Publicado el 04,febrero 2024 - 21:17
Thank you guys, I appreciate your help!

--

Antonio Diaz
Emphasys Software, S.C.