PC SOFT

GRUPOS DE DISCUSSÃO PROFISSIONAL
WINDEVWEBDEV e WINDEV Mobile

Inicio → WINDEV 2024 → Error 70205
Error 70205
Iniciado por Antonio Díaz, fev., 02 2024 5:44 PM - 4 respostas
Membro registado
71 mensagems
Popularité : +2 (2 votes)
Publicado em fevereiro, 02 2024 - 5:44 PM
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.
Membro registado
3.347 mensagems
Popularité : +93 (137 votes)
Publicado em fevereiro, 02 2024 - 6:50 PM
Hi
if the h functions do not work
try to do it with a query
Membro registado
71 mensagems
Popularité : +2 (2 votes)
Publicado em fevereiro, 02 2024 - 9:06 PM
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.
Membro registado
120 mensagems
Publicado em fevereiro, 03 2024 - 9:22 AM
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
Mensagem modificada, fevereiro, 03 2024 - 9:23 AM
Membro registado
71 mensagems
Popularité : +2 (2 votes)
Publicado em fevereiro, 04 2024 - 9:17 PM
Thank you guys, I appreciate your help!

--

Antonio Diaz
Emphasys Software, S.C.