| Sort by:
|
Page 2 of 5 | Previous | 1 2 3 4 5 | Next
|
|
|
13 Aug 2003
|
ORDER BY and ROWS in subqueries
ORDER BY and ROWS are not supported in subqueries
|
Quinn Wildman
|
FAQ
|
|
|
|
|
13 Aug 2003
|
Fetching the top rows descending
It is not possible to order results fetched by ROWS with a SELECT. It is pretty easy to do with a Stored Procedure though.
|
Quinn Wildman
|
FAQ
|
|
|
|
|
13 Jun 2003
|
InterBase 7.1 DataType to InterClient 4.0 Type mappings
Datatype bindings between InterBase and Java types
|
Aaron Ruddick
|
TI
|
|
|
|
|
27 Mar 2003
|
Using two databases
You cannot access two databases from the same SQL.
|
Ben Matterson
|
FAQ
|
|
|
|
|
18 Mar 2003
|
Passing character strings to a UDF in a different character set
CSTRING() uses default character set of database if no character set is specified
|
Quinn Wildman
|
FAQ
|
|
|
|
|
27 Nov 2002
|
InterBase PLANalyzer 1.1 Released
InterBase PLANalyzer is a free tool to optimize IB SQL and metadata. Version 1.1 adds support for IB 5.6-7, query cancellation, syntax highlighting, and more.
|
Craig Stuntz
|
Contributed Article
|
|
|
|
|
19 Jul 2002
|
Mathmatical operations on Time and Timestamp data
Various usefull tips for performing calculations in time and timestamp data
|
Quinn Wildman
|
TI
|
|
|
|
|
12 Jul 2002
|
Are Tablenames cases sensitive?
InterBase 6 introduces cases sensativity in all metadata using Delimited identifiers
|
Quinn Wildman
|
FAQ
|
|
|
|
|
25 Jun 2002
|
Renaming a table
How can I rename a table in my database?
|
Ben Matterson
|
FAQ
|
|
|
|
|
25 Jun 2002
|
Reflecting database changes
Chnages to a database are not always immediately seen by other users.
|
Ben Matterson
|
FAQ
|
|
|
|
|
21 Jun 2002
|
Creating a primary key when your table has no unique records
Describes a simple technique to add a key regardless of the format of your data
|
Quinn Wildman
|
FAQ
|
|
|
|
|
21 Jun 2002
|
Arithmetic results different in InterBase 6 and later compared to earlier versions
Dialect 3 treats some numbers using their native format instead of double precision which may cause different results in calculations
|
Quinn Wildman
|
TI
|
|
|
|
|
1 May 2002
|
READ_COMMITTED tranactions can return inconsistent results.
How InterBase tranactions use the Transaction Information Page to SELECT records.
|
Ben Matterson
|
FAQ
|
|
|
|
|
30 Nov 2001
|
Error: Unexpected end of command
Entering a trigger or procedure results in an error due to terminator symbol conflict between the SQL parser and the trigger and procedure language.
|
Ben Matterson
|
FAQ
|
|
|
|
|
24 Oct 2001
|
Why does using an index make my query take longer?
An explanation of what indexes are and how InterBase uses them.
|
Ben Matterson
|
TI
|
|
|
|
|
11 Jul 2001
|
Using Stored Procedures with ODBC
2 examples of executing stored procedures, one that returns a result set, and one that returns a variable
|
Gabe Goldfield
|
FAQ
|
|
|
|
|
17 Apr 2001
|
WHERE clause with greater than 256 ANDs or ORs generates size of optimizer block exceeded error
This error can occur on a SELECT or UPDATE statement
|
Quinn Wildman
|
FAQ
|
|
|
|
|
7 Feb 2001
|
Default values which do not match the datatype of field cause errors on insert
"arithmetic exception, numeric overflow, or string truncation error" or "conversion error" errors can occur.
|
Quinn Wildman
|
FAQ
|
|
|
|
|
18 Jan 2001
|
UNIQUE indexes don't allow NULLs
Even if the index is based on multiple fields NULLs are not allowed
|
Quinn Wildman
|
FAQ
|
|
|
|
|
6 Dec 2000
|
How to insert new lines into external files
Batch Move is the simplest. A simple Delphi example as well.
|
Quinn Wildman
|
FAQ
|
|
|
Connect with Us