INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Acces to a BBx DB from Delphi

Acces to a BBx DB from Delphi

(OP)
Hi, i don't know nothing about bbx but....i have a big DB that is normally use with a BBx program....

my father need me to make some personnal report but i only know Delphi. I try the ODBC driver but it's only a demo version and i don't know how to deal with the dictionnary data.

if anybody have information to help me i would appreciate!!

Thanks!!

Sorry for my bad english :/

RE: Acces to a BBx DB from Delphi

a few questions/clarifications:

1) I assume the 'big database' is within the BBx file system.

2) you don't actually need the ODBC driver, there is also an SQL interface within the BBx language that allows you to interface with the data by using SQL commands.

3) depending on your BBx version, the license for the newest (BBj) ODBC driver is included. What is your BBx version?

4) TO interface with the data through SQL (implicit or ODBC), you have to tell the system how your data base is organized. You have to fill the Data Dictionary to do that. Two tools are available: DDBUilder (graphical user interface, comes with every BASIS productr for the windows OS), and ddedit.utl, which is a BB program that resides in the ext/ directory, and serves the same purpose as DDBuilder, but has a CUI interface. You have to describe how your data is organized in terms of files (=tables), fields (=rows) and indexes. After you have done that, you can access the data via ODBC/SQL.

5) Alternatively you can OPEN a file and do a READ RECORD of the data. Then you can make changes to the data and write it back using WRITE RECORD. Check out the online documentation of your BB system to find out more.

Peter Scholz
Soft Service Computer GmbH
pscholz@softservice-computer.de

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close