| Sort by:
|
Page 1 of 2 | 1 2 | Next
|
|
| Borland Staff |
|
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
|
|
|
|
|
24 Jul 2000
|
Dropping a procedure generates invalid request BLR error
This error is produced when a stored procedure calls another stored procedure,<br>but with the wrong number or type of parameters.
|
Borland Staff
|
FAQ
|
|
|
Connect with Us