Hi!
No way but parse query for SPT cursor and look for source tables, as well as query SQL Server for ID fields. Quite complex stuff.
BTW, with this approach you can have cursor returned by stored procdure, but updatable into SQL Server table. OR, have ANY query with ANY complexity, and make cursor updatable, if resulting cursor match to source table and fields.
>
>I wonder if there is any way to provide defaults for required parameters besides ALIAS() for parameter 1? Perhaps naming conventions?
>
>I am making good use of your class. Thank you.
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.