Unfortunately, I doubt that either framework (in fact, any commercial framework) would have the functionality you are looking for. The long and short of it is that you are probably looking at a few hours (or days) of code updates, particurlary to remove the built-in dependance on relations.
Some time ago, I wrote a white paper on migrating applications to SQL Server (in fact, it is still on the EPS web site). One of the problems that I've seen over and over is that there is usually some degree of app rewrite involved. Unless you have a relatively simple app that uses wizard-built forms, this is something that you'll just have to tackle.
Regarding the storage of data into your arrays, you might be able to code that functionality into a data handler class. A psuedocode version might work something like this:
define class aDataHandler
function LoadData
lparameter cSqlString, cCursorName, aArray
local lnResult
lnResult = SQLEXEC(this.iConnection, cSqlString, cCursorName)
if lnResult < 1
else
This.LoadArray(cCursorName, aArray)
endif
return lnResult
endfunc
function LoadArray
lparameter cCursorName, aArray
endfunc
Hope that helps.
Dan LeClair
www.cyberwombat.comSET RANT ON - The Wombat BlogLife isn’t a morality contest and purity makes a poor shield. - J. Peter MulhernDisclaimer: The comments made here are only my OPINIONS on various aspects of VFP, SQL Server, VS.NET, systems development, or life in general, and my OPINIONS should not be construed to be the authoritative word on any subject. No warranties or degrees of veracity are expressed or implied. Void where prohibited. Side effects may included dizziness, spontaneous combustion, or unexplainable cravings for dark beer. Wash with like colors only, serve immediately for best flavor.