<App>\StoredProcedures
The StoredProcedures sub-folder contains the latest deployed version of database stored procedure code for each of the database tables used by the application. Changes to the stored procedures will be overwritten when the application is built.
File
|
Function
|
p<App Name><Table>Add.sql
p<App Name><Table>Delete.sql
p<App Name><Table>DeleteRecords.sql
p<App Name><Table>DrillDown.sql
p<App Name><Table>Export.sql
p<App Name><Table>Get.sql
p<App Name><Table>GetList.sql
p<App Name><Table>GetStats.sql
p<App Name><Table>Update.sql
|
The database stored procedures that access the database table.
Examples:
pOMSEmployeesAdd.sql
pOMSEmployeesDelete.sql
|
LoadStoredProcedures.exe
|
An executable file to load the stored procedures into the database. This executable file can be used during the Copy and Run operation when you are moving the application to a different location. You must supply the database name, the user name and password and additional information about the stored procedures.
|