>>Thanks for the great answer.
>>Is there a way that a remote view made in VFP can access/run a Stored Procedure?
>>
>>The only reason I ask is because multi-user development in SQL is not a problem, compared to a source-controlled DBC from FoxPro. Moving to SQL was going to help us out that way, but not if views have to be still made in VFP.
>
>Would it work better if you used VFP's SQLExec() function to call the SQL Server stored procedure?
Without creating the initial infrastructure (data object) you would have no way of determining what information to send back to the server. Unless you used the "nuclear device" method and updated everyting (every field of every record in the initial selection criteria).
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao