Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: How To (Forms, Reports, and more) > Stored Procedures

What's New

Scroll Prev Top Next More

The R:BASE 11 has been updated to make Stored Procedure definition easier. The newest features include:

 

Added history for stored procedure searches

 

StoredProcedure_SearchHistory

 

 

Enhanced drop trigger flexibility, to optionally drop a before trigger, or after trigger, separately

 

ALTER TABLE tblname DROP TRIGGER [BEFORE/AFTER] INSERT/UPDATE/DELETE

 

 

 

Stored Procedure features added within versions 10.0 and 10.5:

 

Enhanced edit options for existing stored procedures to modify the source code, arguments, return value, and comment

Enhanced stored procedures unload capabilities to create the .PRO source file, and a .RMD file with the same name containing the PUT command, with full parameters

 

 

Stored Procedure features added within versions eXtreme 9.0, 9.1, and 9.5:

 

Search capabilities to search for text with Stored Procedures

Ability to define a length for text data type return variables in graphic interface

Ability to define a length for text data type arguments in graphic interface

Creation of the stored procedure help file

Support to recognize the full path and file name string using more than 52 characters

 

Stored Procedure features added within versions 7.x, Turbo V-8:

 

Stored Procedures menu added to the Database Explorer

Stored Procedures will now run in memory, rather than temporary files

Support for Plugins

Support for the R:BASE Blob Editor