New AdoRDD (free)

[digicad]

Srdjan,

With this recent ADORDD change now you don't have to care about ADO connections and catalogs as they are automatically created and managed by the ADORDD

Please notice that the samples source code remains the same

This is good code

s_aConnections[ nWA ] = TOleAuto():New( "ADODB.Connection" )
but if you create same connection you must not create new connection.
for this you must save all parameters (server, UserID, Password, database, driver/provider )

[Antonio Linares]

Srdjan,

Yes, we plan to reuse the same connection objects for different workareas. It will be implemented soon

[Antonio Linares]

Code: Select all

2007-04-30 20:58 UTC+0100 Antonio Linares (alinares@fivetechsoft.com)
   * contrib/adordd/adordd.prg
     * ZAP implemented. GO TOP fixed for empty tables

www.fivetechsoft.com/files/adordd.zip

[Antonio Linares]

Code: Select all

2007-04-30 21:58 UTC+0100 Antonio Linares (alinares@fivetechsoft.com)
   * contrib/adordd/adordd.prg
     * IndexKey( n ) support

www.fivetechsoft.com/files/adordd.zip

[digicad]

Where I can read good explanation of USRRDD ?

[Antonio Linares]

There is no a good explanation of it,

You have to read the source, make tests and search...

[digicad]

I do it, I try way to build dbcreate

[digicad]

Which function execute when dbcreate execute (aMyFunc[ UR_CREATE]) ?

[Antonio Linares]

test it

[Antonio Linares]

Code: Select all

2007-05-01 08:48 UTC+0100 Antonio Linares (alinares@fivetechsoft.com)
   * contrib/adordd/adordd.ch
   * contrib/adordd/adordd.prg
     * LOCATE and CONTINUE support
     
   + contrib/adordd/mysql3.prg
     * MySQL LOCATE and CONTINUE sample 

www.fivetechsoft.com/files/adordd.zip

[wmormar]

Code: Select all

2007-05-01 08:48 UTC+0100 Antonio Linares (alinares@fivetechsoft.com)
   * contrib/adordd/adordd.ch
   * contrib/adordd/adordd.prg
     * LOCATE and CONTINUE support
     
   + contrib/adordd/mysql3.prg
     * MySQL LOCATE and CONTINUE sample 

www.fivetechsoft.com/files/adordd.zip

Antonio,

he hecho pruebas cen mysql.

aparentemente todo funciona de maravillas.

Pero, cuando cargo una tabla de aprox. 2000 registros, lanza un error de E_FAIL:RECCOUNT, y desde luego, se cae el EXE.

saludos

[digicad]

Hello Antonio,

I build dbCreate for ADORDD and send to you with small sample.

But I think you must first connect to database and next commands can be

USE
dbCreate
etc..

IF dbCreate is first command Harbour don't know which connection in use

Best regards
Srdjan

[Antonio Linares]

William,

We are going to do some tests with many records, thanks

[Antonio Linares]

Srdjan,

We are considering to use a special string, so DbCreate() may be issued without a USE:

This is an idea: DbCreate( "DBName;TableName;MYSQL", ... )

If I am not wrong, DbCreate() just creates it. It does not open the table

[digicad]

Antonio,
your opinion is good (not wrong) but if we use client/server natural is connect client on server. you must follow this idea : client -> server
in all case I follow you but I like suggesting

Srdjan