| Sort by:
|
Page 1 of 5 | 1 2 3 4 5 | Next
|
|
|
18 Jan 1993
|
What is a query plan and what can I do with it?
Specifying Query Access Plans in the InterBase Optimizer
|
Borland Staff
|
TI
|
|
|
|
|
24 Jul 2000
|
Creating views that contain the UNION keyword.
Describes how to create a view has a UNION using GPRE
|
Borland Staff
|
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
|
ALTER TABLE . . . DROP CONSTRAINT command drops IBServer
Resolved in Interbase 5.x
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Bug 8445: ALTER TABLE . . . DROP (column) fails when it should succeed
This is a problem with the implementation of views, fixed in Interbase 5.0
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
How do I round a double precision to a whole number
The best way to round a double precision number is to write a UDF to do the rounding
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Import and export new line character to external file
Example for UNIX
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
arithmetic exception, numeric overflow, or string truncation.
Calling Cast can resolve the problem
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
InterBase to InterBase - Cross database Table-data copy using external tables
Example transfering data to a table from an external table
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Insert string parses without error but does not insert values.
Examples of inserting data from one table to another
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Case (insensitive) record searching methods
How to get the search criteria in the WHERE clause to ignore case sensitivity
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
How to use the InterBase SYSTEM tables to select table name information.
How to select metadata information manually from the InterBase system tables.
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Merging heterogeneous columns in a UNION Select
Cast() on extra columns solves the problem
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Performing different types of searches in a WHERE clause
Different ways to use the WHERE statement
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Stopping a lengthy query.
It is not possible to stop or terminate a query, but there are a few alternativesBR>available to address when this situation happens:
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
slower performance on a select statement that retrieves less data
Resolved in Interbase 5.0
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
I/O error for file "c:\temp/iba00206" and sort error
Resolved in InterBase 5.0
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
InterBase Engineers Recommend These Books
Various book titles on the usage of SQL and Networking
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
What is the SQL-equivalent of GDML's FIRST clause
There is no single SQL command that replaces the FIRST clause
|
Borland Staff
|
FAQ
|
|
|
Connect with Us