Antonio,
Thanks I think see it now its ORDINFO
All locking already finished and it seems 100% compatible
FOR and UNIQUE on indexes are working
Its translate to WHERE clause and DISTINCT CLAUSE in selects.
We are now taking care of :
SCOPES to SELECT WHERE field BETWEEN value1 AND value2
Index clause NEXT translate to TOP n but for ex Oracle its ROWNUM we are checking how to solve these diferences between different SQLs
SEEK and FIND
SQLPARSER that we use already in other applications for ADS that transforms a normal old clipper filter expression to SQL SELECT taking in consideration active index.
I have a deadline for this part of the project to 27.03 so I hope to have all done till Friday and Ill post "clean" code after.
Still Fieldinfo its not working as we want. There are still problems with lenght and decimal places of DBF numeric fields types.
Can you find out with Mr Rao how to know or force that all recordsets are opened with the same connection obj.
This is imperative for transactions for locking concurrency
Now we ve a demand to prevent 100% SQL INJECTION. I have to study this ? Do you or Mr Rao have any ideas?
Cross your fingers as the most dificult part is still to come (RELATIONS)