FiveTech Support Forums

FiveWin / Harbour / xBase community
Board indexAll discussionsLogin (GitHub)
Board index FiveWin for Harbour/xHarbour New AdoRDD (free)
digicad
Posts: 14
Joined: Sun Apr 29, 2007 02:04 PM
New AdoRDD (free)
Posted: Mon Apr 30, 2007 06: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 )
TO BE or NOT TO BE

Srdjan Dragojlovic
www.digicad.biz
Antonio Linares
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
New AdoRDD (free)
Posted: Mon Apr 30, 2007 06:34 PM

Srdjan,

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

regards, saludos

Antonio Linares
www.fivetechsoft.com
Antonio Linares
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
New AdoRDD (free)
Posted: Mon Apr 30, 2007 07:03 PM
Code: Select all Collapse
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
regards, saludos

Antonio Linares
www.fivetechsoft.com
Antonio Linares
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
New AdoRDD (free)
Posted: Mon Apr 30, 2007 07:54 PM
Code: Select all Collapse
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
regards, saludos

Antonio Linares
www.fivetechsoft.com
digicad
Posts: 14
Joined: Sun Apr 29, 2007 02:04 PM
Explantion
Posted: Tue May 01, 2007 04:43 AM

Where I can read good explanation of USRRDD ?

TO BE or NOT TO BE

Srdjan Dragojlovic
www.digicad.biz
Antonio Linares
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
New AdoRDD (free)
Posted: Tue May 01, 2007 05:28 AM

There is no a good explanation of it,

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

regards, saludos

Antonio Linares
www.fivetechsoft.com
digicad
Posts: 14
Joined: Sun Apr 29, 2007 02:04 PM
New AdoRDD (free)
Posted: Tue May 01, 2007 05:31 AM

I do it, I try way to build dbcreate

:)

TO BE or NOT TO BE

Srdjan Dragojlovic
www.digicad.biz
digicad
Posts: 14
Joined: Sun Apr 29, 2007 02:04 PM
dbCreate
Posted: Tue May 01, 2007 05:55 AM

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

TO BE or NOT TO BE

Srdjan Dragojlovic
www.digicad.biz
Antonio Linares
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
New AdoRDD (free)
Posted: Tue May 01, 2007 06:53 AM

test it :-)

regards, saludos

Antonio Linares
www.fivetechsoft.com
Antonio Linares
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
New AdoRDD (free)
Posted: Tue May 01, 2007 06:55 AM
Code: Select all Collapse
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
regards, saludos

Antonio Linares
www.fivetechsoft.com
wmormar
Posts: 1076
Joined: Fri Oct 07, 2005 10:41 PM
New AdoRDD (free)
Posted: Tue May 01, 2007 08:47 AM
Antonio Linares wrote:
Code: Select all Collapse
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
William, Morales

Saludos



méxico.sureste
digicad
Posts: 14
Joined: Sun Apr 29, 2007 02:04 PM
dbCreate
Posted: Tue May 01, 2007 09: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

TO BE or NOT TO BE

Srdjan Dragojlovic
www.digicad.biz
Antonio Linares
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
New AdoRDD (free)
Posted: Tue May 01, 2007 09:29 AM

William,

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

regards, saludos

Antonio Linares
www.fivetechsoft.com
Antonio Linares
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
New AdoRDD (free)
Posted: Tue May 01, 2007 09: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 :-)

regards, saludos

Antonio Linares
www.fivetechsoft.com
digicad
Posts: 14
Joined: Sun Apr 29, 2007 02:04 PM
dbCreate
Posted: Tue May 01, 2007 09: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

TO BE or NOT TO BE

Srdjan Dragojlovic
www.digicad.biz
Static archive · New replies & topics via GitHub Discussions