Contents Index Reference database stored procedures ul_add_project system procedure

UltraLite Database User's Guide
  Static Development Model Reference
    Reference database stored procedures

ul_add_statement system procedure


Function 

Adds a SQL statement to an UltraLite project.

Syntax 

ul_add_statement (in @project char(128),
in @name char(128),
in @statement text  )

Permissions 

DBA authority required

Side effects 

None

See also 

ul_add_project system procedure

ul_delete_statement system procedure

Description 

Adds or modifies a statement to an UltraLite project.

project    The UltraLite project to which the statement should be added. The UltraLite generator defines classes for all statements in a project at one time.

name    The name of the statement. This name is used in the generated classes.

statement    A string containing the SQL statement.

If a statement of the same name in the same project exists, it is updated with the new syntax. If project does not exist, it is created.

Examples 

The following call adds a statement to the TestSQL project:

call ul_add_statement(
'TestSQL', 'TestQuery',
'select prod_id, price, prod_name from ulproduct where price < ?' )

Contents Index Reference database stored procedures ul_add_project system procedure