Adordd its ready to work at
https://github.com/AHFERREIRA/adordd.git
It has been in development since Feb 2015 and being tested on real application working in parallel with the actual application with ADS and passed all trials.
This app with adordd its now being tested intensive on concurrent access to check locking scheme and exclusive use.
Will report results end next week.
With adordd you can migrate immediately to any SQL server although all the trials have been made only with ADS, MySql and MS Access.
No change code required. Except:
1) As with ADS in index expressions you have to evaluate vars before send it to adordd.
2) Delete records are immediately removed from table and cant be recovered again. So code like:
Delete record recno
BlankRec() //this will not work either comment it or place it before delete.
delete all //this will not work take it from here
while....
if lcondition //change condition to not
recall record //delete each record here
endif
end
Thats it!
But you can do much more:
hb_GetAdoConnection():Execute("CREATE VIEW cView ....")
sele 0
use cView
Browse()
True locks as any other rdd.
Upload tables to any Sql server just like:
use table VIA "DBFCDX"
copy to sqltable via "ADORDD"
Performance its quite good.
No Sql knowledge needed unless you want to use and run sql statements directly from ado functions.
You write code exactly the same as any other rdd.
With adordd we are free from all kind of limitations with tables and index management already in actual and future operating systems and will extend the life of our applications further.
Although ADO it already today an "old" framework I think it will stay around for the next coming years (I hope so)
Ill give support to it as long as you can supply precise ideas and sample code where something has not been foreseen in adordd scope of action.
I hope that it will do the job for you all as it does for me.
