2. ASPRunnerPro General questions
  3. Stored procedure support
This topic is locked

Stored procedure support

 		5/20/2009 7:45:31 AM
ASPRunnerPro General questions
A
 admin author

Hi,
I am getting following error when i am using stored procedure, while it's showing proper result of sql query on "Edit Sql Query" page in asp runner pro. But after building code it displays the following error. I am using SQL server 2005.
Does ASP Runner pro supports stored procedure
Error Type:

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)

[Microsoft][SQL Native Client][SQL Server]Incorrect syntax near the keyword 'top'.

/sales/sales_list.asp, line 637
Sami
J
 		Jane 5/21/2009

Sami,
Unfortunately ASPRunnerPro do not support stored procedures on the Edit SQL query tab.
A
 		admin author 5/21/2009

Sami,

Unfortunately ASPRunnerPro do not support stored procedures on the Edit SQL query tab.


Hi Jane,
You are right but i have created stored procedres in MS SQL Server and just executing stored procedure while creating view in ASP Runner Pro. This way it should work as per ASP Runner documentation.
J
 		Jane 5/22/2009

Hi,
you need to create a view that calls stored procedure in the database directly.
G
 		gsxrian 6/27/2009

Hi,

you need to create a view that calls stored procedure in the database directly.


Does anyone have an example of how to do this ?

Thanks
A
 		admin author 6/29/2009



Does anyone have an example of how to do this ?

Thanks


I tried a lot and found that It is not possible as we can call stored procedure in the view.
sami