Page 4 of 14
Posted: Mon Apr 30, 2007 6:11 pm
by digicad
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
![Smile :-)](./images/smilies/icon_smile.gif)
Please notice that the samples source code remains the same
![Smile :-)](./images/smilies/icon_smile.gif)
This is good code
![Smile :)](./images/smilies/icon_smile.gif)
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
by Antonio Linares
Srdjan,
Yes, we plan to reuse the same connection objects for different workareas. It will be implemented soon
![Smile :-)](./images/smilies/icon_smile.gif)
Posted: Mon Apr 30, 2007 7:03 pm
by Antonio Linares
Code: Select all | Expand
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
by Antonio Linares
Code: Select all | Expand
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
Explantion
Posted: Tue May 01, 2007 4:43 am
by digicad
Where I can read good explanation of USRRDD ?
Posted: Tue May 01, 2007 5:28 am
by Antonio Linares
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
by digicad
![Smile :)](./images/smilies/icon_smile.gif)
I do it, I try way to build dbcreate
dbCreate
Posted: Tue May 01, 2007 5:55 am
by digicad
Which function execute when dbcreate execute (aMyFunc[ UR_CREATE]) ?
Posted: Tue May 01, 2007 6:53 am
by Antonio Linares
test it
![Smile :-)](./images/smilies/icon_smile.gif)
Posted: Tue May 01, 2007 6:55 am
by Antonio Linares
Code: Select all | Expand
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
by wmormar
Antonio Linares wrote:Code: Select all | Expand
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
dbCreate
Posted: Tue May 01, 2007 9:06 am
by 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
Posted: Tue May 01, 2007 9:29 am
by Antonio Linares
William,
We are going to do some tests with many records, thanks
Posted: Tue May 01, 2007 9:31 am
by 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
![Smile :-)](./images/smilies/icon_smile.gif)
dbCreate
Posted: Tue May 01, 2007 9:38 am
by 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
![Smile :)](./images/smilies/icon_smile.gif)
Srdjan