Antonio Linares wrote:Problema solucionado
Al final de AdoRdd.prg hay una serie de funciones de FWH repetidas, que hay que eliminar.
I can not use hb_AdoUpload () shows the error in this line
Error DBCMD/1015 Argument error: DBUSEAREA
Stack Calls
===========
Called from: => DBUSEAREA( 0 )
Called from: D:\ADVRDD\PRG\CLASSES\adordd.prg => HB_ADOUPLOAD( 6394 )
calling program is in this way.
hb_AdoUpload ("D:\ADVSYS\DATA\", "DBFCDX", "MYSQL" .F.)
Thank you buddy, no reference to the problem.
I already downloaded the files, the problem is I can not do the conversion of the .dbf files to SQL
When I open big tables several times during app execution doesn't this lead to
out of memory or very slow opening of that table?
Adordd builds each table recordset only once.
If your table recordsets have million of records you will need enough memory for it and it can easily
reach some hundred MB or more.
When you open that table again the memory consumption its minimum as adordd clones that table set, which
means a kind of pointer to previous open recordset being extremely fast opening it again and very
low on memory use.
hb_AdoUpload ("D:\ADVSYS\DATA\", "DBFCDX", "MYSQL" .F.)
Thanks James
still gives the error
Arerra,
The error message you posted before is occurring in the second line here (6394 in ADORDD.PRG):
if lOverWrite
hb_adoRddDrop( oCn, cBaseDir + aFile[ F_NAME ], , , DBEngine ) // erroring here
endif
But since you are passing .f. for lOverwrite, that line is not being executed, so it must be showing a different error message now. Please post the new error message.
James
Thank´s James
after thinking a lot, put this information in the main.prg and oh yes right gave the upload.
REQUEST DBFNTX
REQUEST DBFDBT
REQUEST DBFCDX
REQUEST DBFFPT
REQUEST ORDKEYNO
REQUEST ORDKEYCOUNT
REQUEST ORDKEYGOTO
REQUEST DESCEND
thank you for your attention
Aferra,
Thanks for posting your solution. I am going to put that in my notes.
James
Indicates the names used for temporary files at SQL level.
It must start by TMP or TEMP but can be "TMPROGER"
These temporary files are mainly used for temporary indexes created in the SQL server as TEMPORARY and automatically destroyed after connection ends.
