Hi!
1. Create a connection
2. Create a remote view.
3. Do not select any table in the prompted list.
4. Right click and select "View SQL".
5. Type in siomething like "EXEC sp_MyProc" in the opened code window.
6. Hit Ctrl+S or save from menu or toolbar. Type in view name.
7. Close view designer. WARNING - not a View SQL window, but view designer, and do this ONLY by clicking on the "X" for view designer window WITHOUT activating it at all. Otherwise, VFP8beta will make an attempt to automatically update View Designer by new query content and throw an error.
8. Browse view to see results.
9. You can re-open that view for editing. Now you will see also a set of commands to set up view's properties for fields and view using VFP commands. You can modify them too to meet your needs.
I do not know if it is possible to make it updatable though, because I do not see specifying of tables list for updating in the properties list in View SQL mode. Anyway, do you need view based on SP that is also updatable? I guess it is rarely needed.
Good luck!
>Hi Vlad,
>
>Would you care to share your example ?
>
>Walter,
>
>>Hi!
>>
>>A big work indeed. I was able to create remote view based on SQL Server stored procedure instead of query... COOL!
>>
>>>I've got to concratulate the VFP team for fixing the View designer.
>>>
>>>For the most part I got rid of Eview, Saving it to a PRG, Modifying it, Checking with eview, run it etc. It is so much easier now.
>>>
>>>Thanks again
>>>
>>>Walter,
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.