>Chuck,
>
>I think you are correct. The code for AccPac SQL however looks like a train wreck in my opinion. From everything I've seen it looks like they just wanted to get it out the door anyway they could. Basically a function wrapper for every single FoxPro command and then a massive find/replace. In other words there appears to be no attempt AT ALL to optimize the application for SQL.
>
>On the upside though it did install and run ok and appears to be several times faster than the VFP version with about 1/20th of the network load. So even though the source looks ugly, moving to AccPac SQL has obvious performance advantages.
>
>Greg
>
I agree it did look like they created a SQL function wrapper to FoxPro functions. The code base we looked at they didn't give the actual code in the SQL function that replaced the FoxPro function. Which is IMO the hart of the SQL upgrade.
Charles
"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers