...\<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 generated to 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.

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 generated to 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.

...\<App>\StoredProcedures

See Also