database 1

[fergmj]

I need to create a database (very small one) for a project I am working on with BCB 5.0. My program controls the recording of DSS channels. I want the Database to keep track of the recording start and end times and what receiver is being used. That way if someone (through the program) asks to record at 11pm, the database can find an available receiver to record on. There would be an IP address dedicated to each reciever and when the database finds a free receiver, it would corelate the IP address with the open receiver and send the commands.

Any help would GREATLY be appreciated.

Thanks in advance.

Mindy

 

[2ffat]

It really depends on what you need. For one or two users, the "native" DB that Borland's BDE uses is fine. This, BTW, is Paradox.

If you are planning to have multiple users and may need record locking, try MySQL or InterBase. Both use GNU-like licenses which makes then free unless you sell the product for a profit. Check out their forums here and also their websites.
MySQL:

http://www.mysql.com

. There are some interfaces for BCB 5 available.
InterBase:

http://www.interbase2000.org

or

http://www.borland.com

. This is Borland's own database. Only version 6.x is "freeware."

For really robust applications, you may have to go with a commercial product like Oracle, Sybase, or MS SQL.

IMHO, try MySQL or InterBase first. You really can't go wrong for the price. ;-)
James P. Cottingham

http://www.ivcusa.com

 

[fergmj]

James -

I plan to use the Paradox 7 database included with BCB 5.0. I have a client/server app and I need to find a way to get started with what will be a VERY simple database. How do I even get started?

Thanks.

Mindy

 

[2ffat]

First, set up BDE. You should try to download the lastest version from Borland. The download version is an update so you should make certain that you have installed the version that came with your BCB (Borland C++ Builder). If you have trouble, put a thread in this forum or check out some of my favorite sites:

http://www.borland.com,

http://www.bcbdev.com,

http://www.bytamin-c.com

.

Once that is done, decide on how to lay out the table structure.

Then decide on how you want the screens to look. All of this should be done before you start to do any programming. Once this is done, post a thread here and I'll help out some more.

Also, I suggested in another thread a good book to get.
James P. Cottingham

http://www.ivcusa.com

 

[fergmj]

Thanks. I got this up and running.

I aprreciate your help.

Mindy