Stored Procedures


Articles

Sort by: Page 1 of 2 | 1 2 | Next
DateTitleAuthorType
12 Jul 2000 Introduction to InterBase Stored Procedures and Triggers
The heart of client/server application development is using stored procedures and triggers effectively. This session will provide a complete, practical, example-based introduction to these topics.
Conference Speaker White Paper
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
24 Jul 2000 Error when running isql script: -Token unknown - line 4, char 2 -when
Error occurs due to improperly written Stored Procedure or Trigger
Borland Staff FAQ
24 Jul 2000 Does InterBase support DATE literals, if yes how do I use them?
Does InterBase support DATE literals, if yes how do I use them?
Borland Staff FAQ
24 Jul 2000 Joining two stored procedures
Example using employee sample database
Borland Staff FAQ

Server Response from: ETNASC04