TSQLQuery cannot return set from stored procedure
Original Reporter info from Mantis: forest
-
Reporter name: Boguslaw Brandys
Original Reporter info from Mantis: forest
- Reporter name: Boguslaw Brandys
Description:
Using TODBCConnection TSQLQuery cannot return set from MS SQL Server 2005.
In MS SQL Server user can execute procedure (EXEC &LtPos;procname> <@param> for example) whcih return rows of data exactly like select * from something
SQLDb can execute such procedure but cannot return dataset from it.
In Firebird for example there is distinction between selectable and non-selectable procedures by calling code (select * from procedure(params) or execute procedure) and SQldb works fine here.
Where is the problem ? If I try to Open MS Sql server sql code "exec &LtPos;procedure>"
there is an error Cannot open non-select query
Mantis conversion info:
- Mantis ID: 17050
- OS: windows xp home
- OS Build: 32-bit
- Build: Lazarus 0.9.29 r26819 FPC 2.5.1
- Platform: windows
- Fixed in version: 3.0.0
- Fixed in revision: 19362 (#c7a82a0c)
- Monitored by: » Dirk Fellenberg (Dirk Fellenberg)