FiveTech Software tech support forums

Ducth, Rick, You can use adordd together with all of those options (TDatabase classes, adofuncs etc). The biggest advantages of working with adordd is: 1) You dont change the way you are used to work and you dont loose any of the SQL features and performance. 2) You have all information of each reco...

Elvira, ADOVERSION() Returns adordd version hb_adoRddGetConnection( nWorkArea ) Returns the connection for the workarea hb_adoRddGetRecordSet( nWorkArea ) Returns the recordset for the nWorkArea hb_adoRddGetTableName( nWorkArea ) Returns tabe name for the nWorkArea hb_adoRddExistsTable( oCon,cTable,...

I´m changing the browse of all my apps to use xbrowse. One of them use ADO to connect to a MS-SQL database. The folowing code works OK: LOCAL oRs := HB_AdoRddGetRecordSet() IF PegaData( @dData ) IF !empty( dData ) oRs:Filter := "data_release = '" + dToC( dData ) + "'" ELSE oRs:Fi...

consegue usando esta funcao:

oRs := HB_AdoRddGetRecordSet()

Jose Luis, Cuando haces USE con AdoRdd puedes especificar la clausula QUERY: USE ... VIA "ADORDD" QUERY ... Por defecto se usa "SELECT * FROM " Ese query ( aWAData[ WA_QUERY ] ) se usa con el recordset desde AdoRdd: oRecordSet:Open( aWAData[ WA_QUERY ], aWAData[ WA_CONNECTION ] ) Y siempre puedes ac...

Hola David, de momento solo estoy haciendo pruebas, el siguiente código me marca el error al llegar a un registro que contiene Ñ. En la tabla Oracle, que solo tiene dos campos, el campo codigo de ese registro se queda grabado, sin embargo el campo nombre que es el que contiene la Ñ se queda en blanc...

Tienes que comprobar si tu conexión ADO soporta índices:

#define adIndex 0x100000
MsgInfo( HB_AdoRddGetRecordset():Supports( adIndex ) )

You need to check if your ADO engine supports indexing:

#define adIndex 0x100000
MsgInfo( HB_AdoRddGetRecordset():Supports( adIndex ) )

Enrico, Please test this: #define adSeek 0x200000 MsgInfo( HB_AdoRddGetRecordset():Supports( adSeek ) ) If the recordset does not support such functionality then there is no way to use SEEK using ADO. Its an ADO feature/limitation issue It returns .F. with MDB. Can you or anybody else test it under...

Enrico, Please test this: #define adSeek 0x200000 MsgInfo( HB_AdoRddGetRecordset():Supports( adSeek ) ) If the recordset does not support such functionality then there is no way to use SEEK using ADO. Its an ADO feature/limitation issue Regarding the RLock(): Actually ADORDD returns true, because in...

Antonio I loaded up a MS SQL 2005 box and I played around with the same tables as in my 2000 relm. A couple of noteworthy things .. 1) There are no ( structural ) changes in indexing from 2000 to 2005 2) If you set the indexing to Unique and clustered .. the table opens in index order without issuei...

Athayde,

>
HB_AdoRddGetRecordset():Supports( adIndex )
returns .F.
why?
i'm using MYSQL 4.1
>

We don't know it

http://www.w3schools.com/ado/met_rs_supports.asp

> you testing with what GDB?

Access and MySQL (www.freesql.org). Some users are testing with Microsoft SQL too

Antonio,
HB_AdoRddGetRecordset():Supports( adIndex )
returns .F.
why?
i'm using MYSQL 4.1

you testing with what GDB?

Regards

Please try this:

#define adIndex 0x100000

MsgInfo( HB_AdoRddGetRecordset():Supports( adIndex ) )

or ? instead of MsgInfo() if you are not using FWH

> please correction OPEN for support others Querys not only DEFAULT

We plan to do it but using a different code

Rick, http://www.w3schools.com/ado/prop_rs_index.asp "This property is used together with the Seek method to create an indexed display of records and to use the Seek method to search these indexed records, but few providers supports this property and method. Use the Supports method to determine whet...