Hello,
In DBFCDX, there is not need to call SET INDEX TO..., indexes are opened automatically. Just:
- Code: Select all Expand view
USE ( cMyPath + "CUSTOMER.DBF" ) NEW ALIAS "CUST"
CUST->(OrdSetFocus("CUST1"))
Nothing more.
I don´t use relations, and I guess there are not used very often.
I tested basic operations already and they seem to work fine. But the true way to test it is with a complete application, which is going to be my next step.
Also, I suggest you to use ACCESS, instead of ADS. Using Access will arrise the pending issues to be solved. Once ADO Works with Access, it Works with every RBDMS, just changing the connection string.
For correct field managment, please review ADOCreateColSQL().
For deleting, FWAdoDelRecord().
For dates, FW_DateToSQL().
For filtering, FW_Filter2Where().
Thank you.