Design


Articles

Sort by: Page 1 of 9 | 1 2 3 4 ... 9 | Next
DateTitleAuthorType
21 Jul 1999 Building a Database Driven Dynamic Web Site Using JBuilder and InterBase
We will use servlets to do the dynamic page generation and show how you can rapidly change the look and feel of your Web site by making changes to the database. Look at http://www.mers.com with 820,000 pages online all dynamically driven.
Rob Schieck White Paper
21 Jul 1999 30 Days from Paradox to InterBase
This article reviews the problems, the band-aids, the solutions, and the successes encountered during a large database migration from Paradox to InterBase
Skip Rowland White Paper
21 Jul 1999 Writing UDFs for InterBase under Windows and Linux
A user defined function (UDF) in InterBase is merely a function written in any programming language that is compiled into a shared library.
Conference Speaker White Paper
21 Jul 1999 The InterBase On-Disk Structure
Understanding how InterBase stores data offers some hints for efficient database design. Beyond that, it may explain why there is no simple answer to a simple question like "How big is my database going to be".
Conference Speaker White Paper
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
12 Jul 2000 Writing UDFs for InterBase Using Delphi and C++Builder
A complete demonstration of how to write UDFs using Delphi and C++Builder. Unix and Windows platforms will be discussed.
Conference Speaker White Paper
24 Jul 2000 Example of how to create a foreign key pointing to a compound primary key
Example for InterBase 4.x and later
Borland Staff FAQ
24 Jul 2000 Example of how to use the Union operator
Example for Interbase 4.x and later
Borland Staff FAQ
24 Jul 2000 Object In Use error when adding a foreign key
InterBase 4.x solves the problem
Borland Staff FAQ
24 Jul 2000 Date Arithmetic
Date arithmetic examples for InterBase 4.x and 5.x
Borland Staff FAQ
24 Jul 2000 Too Many Concurrent Executions of the Same Request
Caused by recursive triggers
Borland Staff FAQ
24 Jul 2000 Passing and Returning Dates to a Delphi-created UDF
A Protection Exception or erroneous results may occur if special precautions are not taken
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 Bug No 8447: A For SELECT . . . SELECT in a Stored Procedure drops IBServer
Resolved in Interbase 5.0
Borland Staff FAQ
24 Jul 2000 Indexes Cannot be Created on COMPUTED BY Columns.
Generates error: unsuccessful metadata update, attempt to index COMPUTED BY column in INDEX <name of index>
Borland Staff FAQ
24 Jul 2000 Creating a Boolean/Logical datatype with InterBase
Booleans can be simulated by created a CHAR(1) with a check contraint that allows Y or N to be entered
Borland Staff FAQ
24 Jul 2000 Deleting from RDB$USER_PRIVILEGES is too slow in InterBase 4.0.
The ODS changed from 7.2 to 8.0 between versions, and when the two additional fields (rdb$relation_name, rdb$user) were added to the table (rdb$user_privileges) they were not optimized.
Borland Staff FAQ
24 Jul 2000 general sql error: violation of foreign key constraint
he problem occurs because you are using the incorrect type of Trigger
Borland Staff FAQ
24 Jul 2000 What is a generator?
General description of what a generator is
Borland Staff FAQ

Server Response from: ETNASC01