Cannot select when SQL contains more than 1 statement
Original Reporter info from Mantis: s_tarassov
-
Reporter name: Serguei Tarassov
Original Reporter info from Mantis: s_tarassov
- Reporter name: Serguei Tarassov
Description:
When open SQLQuery with SELECT statement preceded by other statements the error is raised:
EDatabaseError : Cannot open a non-select statement
Example of SQL:
CREATE TABLE #sp_server_info(attribute_id int, attribute_name varchar(60), attribute_value varchar(255));
INSERT INTO #sp_server_info EXECUTE sp_server_info;
SELECT * FROM #sp_server_info;
Steps to reproduce:
See attached example, change your server name, instance, user and password.
Mantis conversion info:
- Mantis ID: 20222
- OS: Windows Server
- OS Build: 2008
- Build: 0.9.30
- Platform: Win32
- Version: 2.4.2
- Monitored by: » BigChimp (Reinier Olislagers), » s_tarassov (Serguei Tarassov), » @lacak.sk (LacaK)