FiveTech Software tech support forums

Hola, has confundido filas con columnas.

oRs:Fields:Count : son las columnas de la consulta.

oRs:RecordCount : son las filas de la consulta (Número de registros).

Un saludo.

... more for success or ZERO for failed to located record). Is there a comprehensive list of properties related to ADO recordset open in addition to :RecordCount, :EOF and :BOF?

Buena dia... Ya evaluó directamente el resultado de la condición ? : "oRsVia:State() = adStateOpen .AND. oRsVia:RecordCount > 0 " ... Lo uso así acorde a mi necesidad. LOCAL lGenReg := .f.  ,oBotReg ,oPlaVeh  ,oPlaVeh@ 15,110 GET oPlaVeh VAR oPlaVeh ;         PICTURE ...

oRs:ClassName() = toleauto oRs:Fields:Count() = 103 oRs:RecordCount() = ERROR!!! Error description: Error ADODB.RecordSet:FIELDS/9 l record corrente corrisponde all'inizio o alla fine del file oppure è stato eliminato. Per eseguire l'operazione richiesta ...

Please also try

? oRs:ClassName()
? oRs:Fields:Count()
? oRs:RecordCount()

... se debe que teniendo: nCuenta:=105874 oRs:Source := "Select * from ejemplo WHERE Socio = + '&nCuenta' Order by Socio" nFind:=(oRs:RecordCount) //para saber si esta o no el numero de cuenta del socio Asi me pone como resultado: 1 (si lo encuentra, ya que es código único) Pero se ...

Sometimes oRSet is nil

in your code do:

if oRSet != nil
...
endif

I found the problem
Any solution please ?

Regardsm

Hi

This error is produced on win10 64 bit is produced when some column in recordset contain non english language characters.
The same error is produced too on other methods
oRSet:MoveFirst()
oRSet:Eof()
....
On other versions of WIN is ok

Some solution ?

Best regards,

Thanks for reply Rick

I have try
If oRset:RecordCount() > 0

and many other options

I use Informix database
May be that is the problem with ado and win 10?
or informix odbc driver ?
In any opinion RecordSet produce error on win 10

Best regards.

Avista IF !EMPTY( oRSet:RecordCount ) // Vo sprotivno Znaci e 0  A couple of things .. as you probably know ( perhaps from your comment ) .. oRs:RecordCount() returns a numeric value .. you also may have a syntactical error .. ( ...

Sorry, we need a reduced sample that can be compiled and run without changes. I already try one of my samples and found no problem with RecordCount.

EMG

Thanks for reply Error is produced at this line IF !EMPTY( oRSet:RecordCount ) // Vo sprotivno Znaci e 0 Regards, //----------------------------------------------------------------------------//FUNCTION SnimeniKonekcii() // Da se procitaat snimenite ...

Can we see a PRG sample showing the problem, please?

EMG

... 9200 Time from start: 0 hours 0 mins 6 secs Error occurred at: 13/04/2017, 14:07:45 Error description: Error ADODB.RecordSet/6 DISP_E_UNKNOWNNAME: RECORDCOUNT Args: