This topic is locked
[SOLVED]

 Data from Stored Procedure not shown on List page

1/12/2018 8:59:14 AM
ASPRunner.NET General questions
J
jarnurm author

How can I show data from SQL Server's stored procedure on List page?

I found instructions to do that with PHPRunner, but i didn't manage to do it in ASPRunner.NET.

J
jarnurm author 1/12/2018

Thank you from quick help! I'm getting further now.

I found the correct syntax from help file:

  1. Add 'test' table or any other table to the project
  2. Add the following code to List page: CustomQuery event:
    return DB.Query( "EXEC test_proc" );
  3. Add the following code to List page: FetchRecords event:
    return rs.fetchAssoc();