Stored Procedures


Articles

Sort by: Page 1 of 2 | 1 2 | Next
DateTitleAuthorType
9 Jul 2003 How to reset a generator.
A breif description of how to use the GEN_ID function to reset a generator. Plus a link to a document describing how to use the SET GENERATOR statement to do the same,
Ben Matterson FAQ
31 Mar 2003 Seeing the generator value just inserted.
A breif explanation of how to see the generatro value you just inserted.
Ben Matterson FAQ
31 Mar 2003 Starting transactions in Stored Procedures and User Defined Functions
A brief explanation why you cannot start transactions in stored procedures and user defined functions.
Ben Matterson FAQ
13 Dec 2000 Arrays as parameters to stored procedures
Arrays cannot be used as parameters to stored procedures
Quinn Wildman FAQ
24 Jul 2000 Retrieving the first n records from a result set
It can be accomplished using a stored provedure
Borland Staff FAQ
24 Jul 2000 A Listing of Interbase-specific, and ANSI 92 SQL Standard Arithmetic Operators
A chart that lists the operators supported in InterBase and their order of precedence:
Borland Staff FAQ
24 Jul 2000 Bug No 8447: A For SELECT . . . SELECT in a Stored Procedure drops IBServer
Resolved in Interbase 5.0
Borland Staff FAQ
24 Jul 2000 How to create a stored procedure.
Simple example of creating a stored procedure
Borland Staff FAQ
24 Jul 2000 Input / Output parameters for Stored Procedures
'Column unknown' errors when running stored procedure
Borland Staff FAQ
24 Jul 2000 Calling an IB stored procedure using TStoredProc
Short Delphi example that calls an Interbase Stored Procedure
Borland Staff FAQ
24 Jul 2000 Manipulating Dates Inside a Stored Procedure
Example procedures that add and subtract 30 days to/from today's date
Borland Staff FAQ
24 Jul 2000 Rounding numerical values in a stored procedure
A UDF is the best way to round a numeric value to an integer
Borland Staff FAQ
24 Jul 2000 FOR SELECT --- DO Example
Important items to check when using a "for select -- do"
Borland Staff FAQ
24 Jul 2000 Multiple Rows in Singleton Select error in Stored Procedure
This error occurs when you try to run a select statement in a situation where the procedure only expects to see one value.
Borland Staff FAQ
24 Jul 2000 Select-Suspend procedure behaves differently via InterSolv-ODBC
Workaround is to call the procedure using select rather than execute procedure.
Borland Staff FAQ
24 Jul 2000 How to Update a column in a Table w/ values from another table
Example using Stored Procedure and UPDATE statement
Borland Staff FAQ
24 Jul 2000 How can I tell if a record was found by a select in a stored procedure?
Use the 'exists' operator in the select statement to tell you if the select statement returned any records.
Borland Staff FAQ
24 Jul 2000 How to use 'returning_values' with a stored procedure
Stored Procedures return values in variables
Borland Staff FAQ
24 Jul 2000 Can I alter triggers within a stored procedure?
DDL command are not allowed in Stored Procedures
Borland Staff FAQ
24 Jul 2000 Can I create stored procedures via Delphi or C++ Builder?
Delphi and C++ Builder can create InterBase stored procedures
Borland Staff FAQ

Server Response from: ETNASC04