FiveTech Software tech support forums

by **digicad** » 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 )

by **Antonio Linares** » 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 :-)

by **Antonio Linares** » 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

by **Antonio Linares** » 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

by **digicad** » Tue May 01, 2007 4:43 am

Where I can read good explanation of USRRDD ?

by **Antonio Linares** » 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...

by **digicad** » Tue May 01, 2007 5:31 am

I do it, I try way to build dbcreate

by **digicad** » Tue May 01, 2007 5:55 am

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

by **Antonio Linares** » Tue May 01, 2007 6:53 am

test it

by **Antonio Linares** » 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

by **wmormar** » 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

by **digicad** » 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

by **Antonio Linares** » Tue May 01, 2007 9:29 am

William,

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

by **Antonio Linares** » 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 :-)

by **digicad** » 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

Who is online