FiveTech Software tech support forums

Gunther,

Is the problem solved ?

Im looking into indexes with SQLite right now so if you need something please let me know.

Gunther,

You write in a message before that this array are always on first ranking and after this the indexes with INDEX ON... added.

Just lie any other rdd INDEX ON without ADDITIVE clause will clear all the orders prior to creation.

Gunther, USE cTable SET INDEX TO index1,index2,index3 Order focus should be index1. If SET AUTOPEN ON the order focus will be on the first index in the SET ADODBF.. You should only use INDEX ON for temporary indexes as permanent ones should be indicated on SET ADODBF INDEX... If you use INDEX ON... ...

Leandro,

Check at https://github.com/AHFERREIRA/adordd.git

Include adordd.prg and adordd.ch in your project .

Compile ,link .

adordd its not closing the connection when exiting the app. Solution: ado_exit from adordd should be auto called when exiting the app however it seems that without QUIT command thats not true in some conditions. If you want to close all tables,sets and connection place before exiting in your app a c...

Leandro,

There isnt any adordd.lib.
Its adordd.prg you must use.

Where did you get adordd ?

Gunther, 1.) If i fill the index-array the order cannot changing with SET INDEX TO .... In some cases this is required if i will not change the code. Sorry I cant understand what you mean. SET INDEX TO its translated by the preprocessor to ordlistadd() as in clipper adordd SET ORDER to the 1st index...

Gunther,

If you need you can call directly ADODB_CLOSE() in order to close all tables, sets and connection thats what ADO_EXIT does.

I though ADO_EXIT would be called in any circumstance besides errors.

Gunther,

Im trying with

ACTIVATE WINDOW oWnd VALID ;
FimPrograma(ownd,oTimer)

The FimPrograma does not quit and even so the message is shown only ADO_EXIT but without any procs.

Gunther,

How do you exit you app QUIT or simply RETURN ?

Are you using Harbour or xHarbour?

Im using xHabour and app is QUIT.

Gunther,

Here it always gets called!

I don't have any exit procedure.

Placing msginfo("ADO_EXIT "+PROCNAME(1) +" "+ PROCNAME(2)+" "+ PROCNAME(3)+" "+ PROCNAME(4)) in ado_exit It shows that gets called from _QUIT.

I try to upload with hb_AdoUpload() however some tables with a couple of million of records take an eternity to be uploaded. Its impossible! Solution: In this case you have to upload these tables with some other tool. Please try this: //assuming that default rdd is adordd. afiles //files to be uplo...

Gunther,

It should be closed auto by adordd.

When you end your app (x)Harbour auto calls ADO_EXIT that calls ADODB_CLOSE().
This last closes all tables (recordsets) and cached resordsets and after the connection to the server.

Please check the code.
Is it not working?

How do I solve error Called from UR_SUPER_ADDFIELD(0) ?

Solution:

must link tryadordd.prg with addorrd.prg, and not use hbusrrdd.ch from adordd repository (rename it or delete of your project, HB has your own hbusrrdd.ch in HB32dev\include)

Nueva ADORDD acumulación ver 1.0 en https://github.com/AHFERREIRA/adordd.git google translator: Errores corregidos: DBCREATE si existe mesa sólo puede sobrescribir la que como en cualquier otra rdd. Se estaba dando un error. hb_AdoRddFile (cFichero) si rddsetdefault == "ADORDD" que probar ...