FiveTech Software tech support forums

Posted: **Mon Apr 30, 2007 6:11 pm**

Antonio Linares wrote: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 )

Posted: **Mon Apr 30, 2007 6:34 pm**

Srdjan,

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

Posted: **Mon Apr 30, 2007 7:03 pm**

Code: Select all Expand view: 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

Posted: **Mon Apr 30, 2007 7:54 pm**

Code: Select all Expand view: 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

Posted: **Tue May 01, 2007 4:43 am**

Where I can read good explanation of USRRDD ?

Posted: **Tue May 01, 2007 5:28 am**

There is no a good explanation of it,

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

Posted: **Tue May 01, 2007 5:31 am**

I do it, I try way to build dbcreate

Posted: **Tue May 01, 2007 5:55 am**

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

Posted: **Tue May 01, 2007 6:53 am**

test it

Posted: **Tue May 01, 2007 6:55 am**

Code: Select all Expand view: 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

Posted: **Tue May 01, 2007 8:47 am**

Antonio Linares wrote:
Code: Select all Expand view
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

Posted: **Tue May 01, 2007 9:06 am**

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

Posted: **Tue May 01, 2007 9:29 am**

William,

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

Posted: **Tue May 01, 2007 9:31 am**

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 :-)

Posted: **Tue May 01, 2007 9:38 am**

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

FiveTech Software tech support forums

New AdoRDD (free)

Explantion

dbCreate

dbCreate

dbCreate