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