Gracias por todo AntonioAntonio Linares wrote:Problema solucionado
Al final de AdoRdd.prg hay una serie de funciones de FWH repetidas, que hay que eliminar.
ADORDD FAQs
Re: ADORDD FAQs
Un saludo
___________________________________________________
La mente es como un paracaídas, solo funciona si se abre
Harbour 3.2.0dev (r1601050904) , Fivewin 16.04
___________________________________________________
La mente es como un paracaídas, solo funciona si se abre
Harbour 3.2.0dev (r1601050904) , Fivewin 16.04
Re: ADORDD FAQs
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.)
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.)
Re: ADORDD FAQs
João Santos - São Paulo - Brasil
Re: ADORDD FAQs
Thank you buddy, no reference to the problem.
Re: ADORDD FAQs
https://github.com/AHFERREIRA/adordd/bl ... adordd.prg
https://github.com/AHFERREIRA/adordd/bl ... adordd.prg
https://github.com/AHFERREIRA/adordd/bl ... adordd.prg
João Santos - São Paulo - Brasil
Re: ADORDD FAQs
I already downloaded the files, the problem is I can not do the conversion of the .dbf files to SQL
- James Bott
- Posts: 4654
- Joined: Fri Nov 18, 2005 4:52 pm
- Location: San Diego, California, USA
- Contact:
Re: ADORDD FAQs
I am not clear on this. If every user has their own copy of all the databases in memory, then how do those databases get updated in real time when other users change them? If this doesn't happen, then how can this design be useful?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.
James
FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10
- James Bott
- Posts: 4654
- Joined: Fri Nov 18, 2005 4:52 pm
- Location: San Diego, California, USA
- Contact:
Re: ADORDD FAQs
Aferra,
hb_AdoUpload ("D:\ADVSYS\DATA\", "DBFCDX", "MYSQL", .F.)
James
You are missing a comma before the last parameter. It should be:hb_AdoUpload ("D:\ADVSYS\DATA\", "DBFCDX", "MYSQL" .F.)
hb_AdoUpload ("D:\ADVSYS\DATA\", "DBFCDX", "MYSQL", .F.)
James
FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10
Re: ADORDD FAQs
Thanks James
still gives the error
still gives the error
- James Bott
- Posts: 4654
- Joined: Fri Nov 18, 2005 4:52 pm
- Location: San Diego, California, USA
- Contact:
Re: ADORDD FAQs
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
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
FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10
Re: ADORDD FAQs
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
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
- James Bott
- Posts: 4654
- Joined: Fri Nov 18, 2005 4:52 pm
- Location: San Diego, California, USA
- Contact:
Re: ADORDD FAQs
Aferra,
Thanks for posting your solution. I am going to put that in my notes.
James
Thanks for posting your solution. I am going to put that in my notes.
James
FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10
- James Bott
- Posts: 4654
- Joined: Fri Nov 18, 2005 4:52 pm
- Location: San Diego, California, USA
- Contact:
Re: ADORDD FAQs
Temporary Indexes
From the manual:
I have a program that generates unique filenames for temp indexes, based on what existing temp names already exist. So, there is no way to know what those filenames will be until the program is running.
It is not clear to me if the TMP and TEMP are just prefixes for filenames (like TEMP001.CDX) or if that is the complete filename. Or, do I have to specify all of the exact filenames that will be used for temp indexes? When you have 5-10 users that all have to generate multiple temp indexes, I'm not sure how exact filenames can be known before compiling the program.
Any hints on how I can resolve this will be appreciated.
James
From the manual:
I am not sure what the above means.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.
I have a program that generates unique filenames for temp indexes, based on what existing temp names already exist. So, there is no way to know what those filenames will be until the program is running.
It is not clear to me if the TMP and TEMP are just prefixes for filenames (like TEMP001.CDX) or if that is the complete filename. Or, do I have to specify all of the exact filenames that will be used for temp indexes? When you have 5-10 users that all have to generate multiple temp indexes, I'm not sure how exact filenames can be known before compiling the program.
Any hints on how I can resolve this will be appreciated.
James
FWH 18.05/xHarbour 1.2.3/BCC7/Windows 10