Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Questions about upsizing to SQLServer
Message
From
11/03/2004 16:50:26
 
 
To
10/03/2004 01:49:44
James Chan
Objectmastery Pty Ltd
Hawthorn, Australia
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00884727
Message ID:
00885392
Views:
10
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

* you'll have to pass the array in via reference

* assume the connection is open and available as a property of the class
local lnResult

lnResult = SQLEXEC(this.iConnection, cSqlString, cCursorName)
if lnResult < 1 
   * error handling code here
else
   This.LoadArray(cCursorName, aArray)
endif

return lnResult

endfunc

function LoadArray
lparameter cCursorName, aArray

* your array loading routine goes here

endfunc
Hope that helps.
Dan LeClair
www.cyberwombat.com
SET RANT ON - The Wombat Blog

Life isn’t a morality contest and purity makes a poor shield. - J. Peter Mulhern
Disclaimer: 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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform