The RB Data workspace (DADE) currently supports parameterized query linking for the SQL where clause. So that will not work for a stored proc call.
You might consider creating a custom dataview template. For an examples check out Demos\EndUser\Custom DataViews and Demos\EndUser Databases\SQL Server\ADO\StoredProc. The latter contains examples of custom dataviews that call stored procs.
- Nard Moseley Digital Metaphors www.digital-metaphors.com
Best regards,
Nard Moseley Digital Metaphors www.digital-metaphors.com
Comments
The RB Data workspace (DADE) currently supports parameterized query linking
for the SQL where clause. So that will not work for a stored proc call.
You might consider creating a custom dataview template. For an examples
check out Demos\EndUser\Custom DataViews and Demos\EndUser Databases\SQL
Server\ADO\StoredProc. The latter contains examples of custom dataviews that
call stored procs.
-
Nard Moseley
Digital Metaphors
www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com