| Sort by:
|
Page 4 of 5 | Previous | 1 2 3 4 5 | Next
|
|
|
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
|
|
|
|
|
24 Jul 2000
|
What is the equivalent of the GDML 'MISSING' keyword in SQL?
The 'Missing' keyword in GDML is equivalent to 'Null' in SQL.
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Getting gds_free & gds_alloc errors
Problem resolved in InterBase 5.0
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
An example of foreign key referencing self table
Example of a straight where field2 is contained in field1
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
How to calculate the age from a date field
A computed column can show the age
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
How to add not null to an existing column
What is the ALTER TABLE syntax to add a not null constraint to a column?
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Listing column names in an InterBase table
What is the SQL command to get the column names for a specific table in an InterBase database?
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
invalid request BLR at offset 13369
Getting the following error while trying to compile a stored procedure script "invalid request BLR at offset 13369 -context not defined (BLR error) "
|
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
|
Ability to create a database using the API call
API call "isc_dsql_execute_immediate()" may set you databse habdles to NULL
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Dynamic SQL Error: Token unknown
InterBase version 4.0 and onwards, is pretty strict about the usage of reserved words in any SQL statements..
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Information on how to use the dow() UDF
Getting the error .."error 171: function dow() could not be matched..
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Display of sort info on Query Plan
The optimizer does consider the cost of sorts
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Inserting and Updating through a view - no triggers involved
SQL examples of updating a view.
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Select distinct doesn't return correct row count
Using a plan or creating an index fix the problem
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Do changes in the table's definition propagate the changes to the view?
Changes in the table do not propogate to views that use the table.
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
How to Concatenate Strings in InterBase
|| is the concatenation operator
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
How to prevent users from creating tables
Remove the D from the license file on the server or periodically delete them.
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
A Possible Cause of "Token Unknown SQL code 104" Errors When Creating Tables
THis error uccurs if you use a keyword as a table name.
|
Borland Staff
|
FAQ
|
|
|
|
|
24 Jul 2000
|
Multiple rows in singleton select occurs when attempting an update
This error occurs if a subquery returns more than one rows in an UPDATE statement.
|
Borland Staff
|
FAQ
|
|
|
Connect with Us