Hi James

Unfortunately everyone wants to upgrade their FPW2.6/VFP applications to SQLServer, but want to do it quickly and retain legacy code.

Yes you can do it, but the whole idea between moving to a C/s solution is not to do what was being done with the old app. With local files the data was all there and was sometimes stored in an array for display.

With SQLServer this is utterly inefficient. The bottom line in SQLServer -access should be to only get enough data as is essential. Thus if your form has page frames with different data on other pages, you should not get the data till the user activates the page.

SQLServer is to be used for scalability, not just to update to the latest.

I really cannot see the justification of using file based technology to access a client server.

You gotta bite the bullet and make the change. Legacy code brought into a brand new UBeaut application will still be Legacy.

You gotta balance this legacy code with time and usage and bring the least amount of it into your new app.

I am currently in the process of "Converting" a legacy FPW2.6 app into VFP* SQLServer. The legacy code even uses pessimistic record locking and with >150 users this is a big hassle. Huge arrays are built and displayed in list boxes( > 30000 records per array)This just wont do in C/S.

Maybe we could exchange notes?

I too have developed a framework using CA's since all the current ones used SPT (maybe)

Cheers

Bernard

>Hi,
>
>What I want is to upsize an existing VFP6 application to SQLServer using VFP8. It is a multi-user system. My questions are:
>
>
>1. The existing application currently relies on the "set relation" between tables. There are many code in many places are like:
>

>if ChildTable.Field == n
>   * do something
>else
>   * do different things
>endif
>

>
>What will be the best way to convert codes like above? I know I can first call SQLExec() to get the value of ChildTable.Field. But this means I will need to change a lot of code and make a lot of SQLExec() calls, slowing down the application.
>
>2. The application was originally implemented in Foxpro 2x. It does not use views to update the database. Instead, we built a framework that use arrays as table buffers. Now with VFP8, I can use SPT or Cursor Adapter to read/write remote data. However, I need to keep the buffer arrays because a lot of code are implemented around these buffer arrays. What I want to accomplish is something like
>

>* SPT/CA read data from SQLServer
>* initialise the buffer arrays
>* read events   && existing code
>* update SPT/CA from the buffer arrays
>* update SQLServer via SPT/CA
>

>I wonder if there are any tools or frameworks that can help me accomplish the above? Will frameworks (like MM or VMP) be any use for the above purpose? How?
>
>Thanks in advance