Hi!

There is nice article about the comparison of RV and SPT: http://fox.wikis.com Article called "MoreOnRemoteViews".
The SPT is not much more quick that RV. The mixing of RV and SPT is the best approach (RV for data editing and SPT for read-only data queries). However, you can work using SPT everywhere, if you want, there is ability to make SPT cursor updatable no matter which query used to query data for it, just bind local SPT cursor fields with remote tables and fields using properties of the cursor (cursorsetprop function). There is a chapter in MSDN that explains this more.

As about VPM - consult with the developers that use this framework a lot (post another message and make the proper question). As far as I know there are some predefined tables in the database for VPM, and I don;t know if you can move them to the remote server.

HTH.

>Hi Alex
>
>Thanks for your input. May I know under what situation should I use SQL passthru versus VFP remote view. I believe SQL passthru is more data specific but faster. I'm attemting to migrate my current VFP application (in VPM) to client server but would be grateful if u could advise me before I take the plunge. I'm currently using Foxfire and would u be able to recommend report writer that would work well in client server environment.
>
>Best Regards
>>Farouk,
>>
>>VFP functions are different from the ones in T-SQL (the language in SQL Server). So you cannot run a query using SQLEXEC() like the one you posted, because T-SQL does not have a DTOS() function. You would have to change it to using DatePart(). The point of SQL Pass-Through is that you pass queries or commands to the back-end database without being processed by VFP. Therefore you have to pass commands or queries that are valid in the language of the back-end.
>>
>>>>>>>>>>>>>>>>>>>
>>>Eg. I have a table XYZ with primary key Period and another table ABC with primary key , patient_id and a non key field called visit date. ABC is related through cperiod. My SQL statement goes like this :
>>>

SELECT * FROM XYZ,ABC WHERE LEFT(DTOS(visit_date),6)=cperiod

>>>Would the above statement works when I upsize to SQL SErver? Else should I create another field cperiod into ABC but then cperiod is fully derivable from visit date and that we're suppose not to have calculated fields in our table.
>>>>>>>>>>>>>>>>>>>