FiveTech Software tech support forums

Anyone tried ADORDD ?
It is the only way to go to SQL keeping exactly the same code.

Hi,

The application its using MDIchild with navigational dlgs inside.
Within each MDIchild it can go forward opening new dlgs replacing the existing one and
backwards closing the actual dlgs and restoring the previous one.
Each dlg has a multiple controls inside.
Each MDIchild keeps track of all ...

This code runs ok on win10 but not on one PC with win 7.
Another app with same code runs ok on both!

cFile := cGetFile32("Ficheiros XML | *.xml|"+;                             "Escolha onde vai gravar o ficheiro",1 &#41 ...

Hi,

What do you use to print dinamic QR Codes ?

Regards
Antonio H Ferreira

Dear Rao,
Happy Birthday!
I wish you many years more and that we are all here to see it!

May be this can be useful:

for n := 1 to nTables oDbTable := oDbTables:Item(n) oDbTable:dllname := "crdb_ads.dll" // or "crdb_odbc.dll" or anyother //Get and delete all connection properties oProp := oDBTable:ConnectionProperties() oProp:DeleteAll() //new con props! replace ...

My main work now with AdoRdd its database with tables between 5.000 and 10.000.000 records building recordsets between 5.000 and 100.000 records and 70 columns in average.
The work its on a 1Gb LAN.

In the bigger tables if the server has indexes for the WHERE clause its pretty fast < 3 Secs ...

Dutch,

Just an idea:



I think "False" must be .F.

New AdoRdd and tryadordd at https://github.com/AHFERREIRA/adordd.git

Dear Rao,

Thanks for the excellent designed trials and information report.
This is crucial information to all of us.

My experience is that with ADO opening a recordset with 500 columns / 2000 rows its slower than opening it with 100 columns / 100.000 rows.
May be with other options FWH and DLP is ...

New AdoRdd at https://github.com/AHFERREIRA/adordd.git

Improved speed DBEval
Cache tables and recordsets enhancement

New AdoRdd at m

Performance enhancement opening tables.

SET RECORDSET OPEN WHERE CLAUSE TO {{"MYTABLE","HBRECNO < 51000" },;
{"MYTABLE2","HBRECNO BETWEEN 1 AND 50000" }}

This SET together ADOWHERECLAUSE( nWa, cNewSql ) enable us to open tables using the set of data we really need without ...

Dutch,

Just as a guide line.

&nbsp; oCrystal := CreateObject&#40;"CrystalRuntime.Application.11" &#41;&nbsp; oReport &nbsp;:= oCrystal:OpenReport&#40; cReport&#41;&nbsp; if&#40;!empty&#40;oReport:ReportTitle&#41;,oReport:ReportTitle,strtran&#40;cfilenopath&#40;alltrim&#40;creport&#41;&#41;,".RPT ...

New AdoRdd at https://github.com/AHFERREIRA/adordd.git

New AdoRdd at https://github.com/AHFERREIRA/adordd.git