How to Set Up a C++ Builder or Delphi Form to View InterBase Data

By: Borland Staff

Abstract: Simple steps to create a form and view table data

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

Solution:
1.  Make sure SQL Link for InterBase is installed on your computer.
2.  Set up a BDE alias to point to InterBase database.
	a.   Bring up BDE Administrator.
	b.   Select Object | New from the menu.
	c.   Select  "INTRBASE"  from the "DataBase Driver name" list.
	d.   Enter a name for the BDE alias. 
	e.   Enter the path to the  database in space next to  "SERVER NAME" 
	f.    Enter your InterBase user name in the "User Name" space.
	g.   Select Object | Apply to save the alias.
	h.    Exit BDE administrator.


2.   Start C++ Builder or Delphi

3.   Create a new form by selecting File | New | Form from the menu.

4. Place a Ttable object on the form.
	a.   Click on the  "Data Access"  tab on the component palette.
	b.   Click on the Ttable object.
	c.   Click on the form to place the Ttable object on the form.  

5.  Define the Ttable object to be a table in the  InterBase database.
	a.   Hit    to bring up the Object Inspector.
	b.   Click on the "DatabaseName" property.
	c.   Click on down arrow that appears.
	d.   Select the database alias you created in step 1.
	e.   Click on TableName property.
	f.    Select the table name from your database's list of tables.


6.   Put a DataSource on the form.
	a.   Click on Data Access Tab.
	b.   Click on DataSource button.
	c.   Click on the form to place the DataSource on the form.
	d.   Hit  to get to the Object Inspector.
	e.   Click on the space next to the  "DataSet" property.
	f.    Select the Ttable object created earlier from the drop down list.

7.   Put a DBGrid on the form.
	a.  Click on "Data Controls" tab	on component palette.
	b.  Click on DBGrid object.
	c.   Click on form to place the dbGrid on the form.
	d.   Hit  to get to the Object Inspector.
	e.   Click on DataSource property.
	f.     Select DataSource created earlier.

8.  Activate  the Ttable object.
	a.  Click on Ttable object.
	b. Hit  to get to object Inspector.
	c. Click next to "Active" property.
	d.  Select   "True" from drop down list.
	

9.  Press  to compile and run the form.  

Server Response from: ETNASC04