IBPhoenix Document - Knowledgebase

Home
IPL License
Contact Us

IBPhoenix Development
Documentation
Other Links

Get Involved
Member Websites
Projects
News
Groups, Lists, and Forums
Sites Powered by InterBase®

Main Downloads
InterBase®
Contributed

Research Center
KnowledgeBase
Articles
Examples

Partner Programs

Service & Support
Training & Consulting

IBPhoenix Shop

IBPhoenix Knowledgebase

How To...

Problem: Do not know how to uninstall before upgrading to a newer version since there was no uninstall utility provided with the previous version.

Problem: Don't know how to execute a procedure call in ODBC Test

Problem: Don't know how to use SQLPrimaryKeys in ODBC.

Problem: Don't know how to make a test kit tape on VMS.

Problem: How to upgrade the Visigenic ODBC driver.

Problem: I need to add a user in support.gdb, but not sure how to do it.

Problem: How to add a new team member in support.gdb?

Problem: There needs to be a way to retrieve a fixed number of records from a result set using SQL.

Problem: How to create an InterBase application from the Borland C++ IDE Note: This information applies to Borland C++, NOT C++ Builder

Problem: Need to install a new InterBase internet access license

Problem: Need the steps of switching from one IB to another on one machine.

Problem: How can I disable the LIBS from executing by default from Delphi?

Problem: I can't figure out how to create a database on the fly with the API.

Problem: InterBase does not have a native Boolean/Logical datatype. How can I create one myself?

Problem: Inserting/updating record A (field length (10) with a value from record B (field length (60)) results in a string truncation error.

Problem: How to automate GBAK.

Problem: How to automate GBAK and backup to a DAT TAPE drive

Problem: How to automate GBAK and develop a good backup procedure

Problem: How do I create a generator?

Problem: How do I display the current value for a generator?

Problem: How do I reset the value for a generator?.

Problem: How do I assign a generator to populate my primary key with triggers.

Problem: How to specify my protocol of choice via the connect string.

Problem: How to implement Cross database Table-data copy using QLI.exe

Problem: How to get the search criteria in the WHERE clause to ignore case sensitivity

Problem: How to select metadata information manually from the InterBase system tables.

Problem: How to automate a shutdown of the InterBase Server nightly.

Problem: How to shutdown / start the server manually.

Problem: How to shutdown / start the server manually.

Problem: How to shutdown / start the server manually.

Problem: How to create a static query to exist and be optimized on the server for repeated usage.

Problem: How to delete a record from both the master table as well the associated records from the detail table.

Problem: How to compile the udf example shipped with the 4.x kits.

Problem: Using an ORDER BY clause in a Select statement that uses a UNION clause will produce an error : '-Invalid command -invalid ORDER BY clause'. How do you arrange the r esults of a UNION?

Problem: Windows NT does not come with the TCP/IP protocol already installed. The following instructions show how to install the TCP/IP protocol and get it up and running.

Problem: When a query is running on the InterBase Server it is not possible to stop, halt or terminate the query.

Problem: I would like to transfer data from Paradox tables to InterBase. I do not want to use SQL to perform their conversion from Paradox to InterBase. What are my options?

Problem: Problem is trying to inactivate and delete generators.

Problem: How do I remove or strip the time portion out of the date field

Problem: Shutting Down a Database and Backing it Up using NT

Problem: How can we control the time in which a sweep starts.

Problem: Determining all users available on the database

Problem: How to round a NUMERIC number to an integer number

Problem: How to round a NUMBERIC number to an integer number

Problem: How does one access Local InterBase from a web server application? Customer is using NT and receiving the error message "Unknown user name or password."

Problem: Given an environment with mixed languages, how do you specify a different character set for each client attachment to the database when the application has already been developed and is being deployed to non-native language environments.

Problem: How do I programmatically rollback limbo transactions?

Problem: How do I change the owner of a table?

Problem: How do I digitally sign my java applet?

Problem: Users other than the owner of the database need to be able to alter triggers. Privileges for triggers are not affected by the grant/revoke statements, and only the SYSDBA and the owner of the database can alter triggers.

Problem: How to return the max row size using SqlGetInfo?

Problem: How do I set the BDE DRIVER FLAGS parameter to different values for different a liases? I have several BDE aliases defined and I want the DRIVER FLAGS parameter to be set differently for each of the BDE aliases.

Problem: I need make a reduced version of my database to transport to a development environment. I would like to get the whole definition of tables and some of the registers in a "reduced" file size.

Problem: I need to distribute a database on CD. Is this possible with InterBase? I also need to access the database from machines with InterBase 3.x on it.

Problem: Exporting an internal table to a text file requires that a 'newline' column contain a carriage return.

Problem: How can I transfer data from an InterBase table to a Paradox table with the same field names and data types?

Problem: How do I know InterBase is Y2k compliant

Problem: How to find out the table names in a database.

Problem: How do I configure the Guardian not to restart the server?

Problem: How do I set up the database cache?

Problem: How can I add two strings together in InterBase. When I try to do it, using a "+" symbol, I get a type conversion error.

Problem: How do I get a list of users connected to a database?

Problem: How do I compute the length of a row?

Problem: I would like to restrict users from creating tables. Is there any way I can do this via roles?

Problem: How do you phrase an SQL query for a certain time of day in an IB DateTime field? I would like to be able to query for every record where the time is, say 06:30, irregardless of the date. Is there a way to do that?

Problem: How can I set the client to detect a lost connection quicker.

Problem: Try to concatenate 2 char fields together and can't trim off the spaces trailing the char field.

Problem: How can I update multiple fields in table1 with fields from table2?

Problem: How can I tell if a record was found by a select in a stored procedure?

Problem: I am developing an InterBase application and would like to regression test it against different versions of the InterBase server/client. How can I do this?

Problem: How to shut down the InterBase Service

Problem: In dBase, you could copy the structure of a table to another table. Is there a way to do this in InterBase?

Problem: This document gives step by step instructions on how to view data in an InterBase table from a C++ Builder form.

Problem: The BDE default transaction control is inefficient. How do I take control of my InterBase transactions?

Problem: How do I request help for IT when I need it? What was the reasoning for the sy stem we have now?

Problem: I need to change the datatype of a field that is part of the Primary Key of a table. Can I do this without destroying the table and rebuilding it?

Problem: Is there any way to make a table read-only?

Problem: Is there a way to get the query plan without actually running the query in WISQL?

Problem: How can I track what the BDE client sends to the server?

Problem: This document will show how to quickly and easily make a Delphi form that is bound to a table.

Problem: How can I create a BDE alias in my application so that I dont have to have my users create BDE alias' manually?

Problem: Creating a graphics viewing application for viewing bitmap, icon, and metafiles (*.bmp, *.ico, *.mtf).

Problem: How do I determine the backversions for a non-system table?

Problem: Has anybody got a library or such for accessing the InterBase API via Perl? Or examples of Perl scripts that access an InterBase database, either via the API or via parsed calls to isql?

Problem: Can I create stored procedures in my InterBase database using Delphi?

Problem: I would like to run a query saved in a text file using Delphi. How do I do that?

Problem: Here is a quick walk-through of creating a query with SQL Builder. SQL Builder is an interactive tool that is included with Delphi4 and C++ Builder. It allows a user to creat e an SQL query using a graphical interface. Complete instructions on displaying results using a db Grid component is also covered.

Problem: InterBase does not support "drop generator" syntax.

Problem: How to make a master/detail form in Delphi

Problem: I have just created a table that contains a field with an array of integers defined as one of the fields. How can I access it from my Delphi application using the BDE?

Problem: How do I declare an InterBase UDF with the Database Desktop?

Problem: Creating a Worker Thread for Background Processing

Problem: How to determine if a set of columns have unique values for rows in a table. This may be necessary when trying to create a unique index and it fails claiming that there are duplicate values.

Problem: I'm trying to execute the following query, but can't seem to be able to group by the UDF return value.

Problem: My Delphi application accesses an InterBase table that has several columns with constraints. When my application posts the record, the server is outputting a message for each field that has had its constraints violated, one by one. There are a number of columns with constraints on them. Is there a way to check all the columns at once, and report one message telling the user which columns have incorrect data?

Problem: How can I copy a record from one table to another , using SQL?

Problem: You cannot use BDE to create a database. BDE requires an active database connection in order to execute any statement. But, of course, you cannot connect to a non-existant da tabase in order to issue a create database statement.

Problem: How do I select the system date

Problem: How To Change a Column Length or Type Without Dropping It

Problem: Generators return 64-bit integers in v6.0. So... How do you define a field to use 64 bit integers in v6.0?

Problem: How to contact Merant for support?

Problem: The documentation example in the Programmers Guide for declaring a blob UDF is wrong. How do I really declare a blob UDF?

Problem: What are the steps for setting up a Sequelink Data Source?

Problem: Since there are no VCL controls to add, modify, or delete users for an InterBase server I am not sure how to do this task. The BDE also does not allow me to add, modify or delete users. I need to be able to do this task within a program? How do I do it?

Problem: How can I lock a record in InterBase?

Problem: How to allow users to change their own passwords in InterBase Version: IB 5

Problem: When date fields are displayed in the data aware controls the year is always displayed with 2 digits. How can I display years with 4 digits instead?

Problem: Having problem: storing binary GUID values from IBX or BDE, what can one do to fix it?

Problem: Use the TIBSQLMonitor component to monitor the dynamic SQL that passes through the InterBase server.

Problem: Why do order by queries seem slow and what can be done to improve an order by query?