BorlandTalk.com

Dwayne · Guest

Hello "M0L0Ch"

M0L0Ch>>I have to design a database application, anyone knows a good
tutorial/link/doc about ways of planning and designing a good database
application? I've found nothing useful searching the net..general database
programming tutorials are also appreciated..many thanks in advance!!<<

This depends upon your Database application. What is your
Application supposed to do? What kind of data? What variables will the
Database hold?.
Make a list of all the data that will be stored in the Database.
Example:
Name,
Address
City
State
Zipcode
SSN
Birthday
etc.

Find out how long each of these variables will be (or guess on the
Maximium length).

Store your names and stuff that has numbers AND letters in a
alphanumeric. And store data that has only numbers in either numeric
fields, boolean fields, or whichever format fits the data the best.

Dwayne

M0L0Ch · Guest

hello all,
I have to design a database application, anyone knows a good
tutorial/link/doc about ways of planning and designing a good database
application? I've found nothing useful searching the net..general database
programming tutorials are also appreciated..many thanks in advance!!

Dwayne · Guest

Hello "M0L0Ch"

when I start the "helper" form to add values I already have dbEdits filled
with values of the current line in the grid, and if I change them to add
values,I have a new line ok but that previous row also change! what I've to
do as to "disconnect"

Try Adding a DBNavigator to your form. connect the DBNav source to
the file you are adding and editing. Then you can add, subtract, go to
first and last records etc.

Dwayne

Jayme Jeffman Filho · Guest

Hello M0L0Ch,

Here you have some links on database design :

Database modeling

http://www.phpbuilder.com/columns/barry20000731.php3
http://www.edm2.com/0612/msql7.html
http://hotwired.lycos.com/webmonkey/backend/databases/tutorials/tutorial3..html
http://www.utexas.edu/cc/database/datamodeling/
http://www.cs.sfu.ca/CC/354/zaiane/material/notes/Chapter7/node1.html

SQL Language

http://www.sqlcourse.com/

I've just tried all of them to check they still exists .I hope they can help you.

Best regards.

Jayme.

"Dwayne" <myfrienddr (AT) yahoo (DOT) com> wrote

M0L0Ch · Guest

thanks to all I've already started, but I'm facing other problems.. I'm
using interbase, and the user should fill a DBGrid with values..to help
this, I've done a little form with many DBEdit, one for all fields in the
grid so the user inserts values in the dbedits and all is added to the
grid..the same if the user wants to modify a particular row in the grid. all
is ok as making the user modify values, but not for entering them,because
when I start the "helper" form to add values I already have dbEdits filled
with values of the current line in the grid, and if I change them to add
values,I have a new line ok but that previous row also change! what I've to
do as to "disconnect" DBedits from the grid if I want to add values?
I also need to check if some values are added twice, I've to check each one
programmatically or there is a quickier way to do this with some database
feature?

another basic question: I've seen that I can add lines or values by using
the dbGrids's methods and also using the table's methods (IBTable) what is
better??

as I said I'm using interbase, I'm creating my interbase tables using
database desktop of borland..I've seen that I cannot change the "header
fields" (the fixed records on top) once I've made the table unless I make a
new one..is there a way?and is there a way to use spaces and special
charachters like "%" and others?

hope you understand, sorry if I've posted lots of questions and for my
strange/bad english! Smile

many thanks in advance to all!!

M0L0Ch · Guest

thank for your tip! but.. isn't there another way? like simply letting me
put values as if dbEdit were a standard edit?

"Dwayne" <myfrienddr (AT) yahoo (DOT) com> wrote

Dwayne · Guest

"M0L0Ch" <noemail (AT) nospam (DOT) com> wrote

thank for your tip! but.. isn't there another way? like simply letting me
put values as if dbEdit were a standard edit?<<

You can do exactly that. Use a Edit ASCII field to input your data,
and when you press another button, it will automatically add it to your
database. and/or update your database. It is a little more cumbersome.

You can put on your DBNavigator (in the Event tab) something like
Before Action call AppendRecord ,save all of your Edit fields to the proper
DBFields, then call a Post() command.

Or you can Make a little "Button, put a "Add Record" on it and do
it that way. There are many ways how to do it.

But! if you click on the "+" button of the navigator, all of this
is basically done for you....New record spot is made, the DBEdits are clear
and read for you to enter data, and when you are done, you hit the checkmark
and the record is saved...Without re-writing over other data in the DBfile.

Dwayne

Dwayne · Guest

thanks for your help, actually I'm using an insert() before showing the
form, so data-aware edits can modify the newly created line..
I have other basic questions in the interbaseexpress newsgroup..any help
would be very appreciated!!
thanks in advance!

Insert() will work just fine too. I prefer RecordAppend(), but
if Insert words well with you, and doesn't slow you down... great! use it.

Dwayne

M0L0Ch · Guest

thanks for your help, actually I'm using an insert() before showing the
form, so data-aware edits can modify the newly created line..
I have other basic questions in the interbaseexpress newsgroup..any help
would be very appreciated!!
thanks in advance!

"Dwayne" <myfrienddr (AT) yahoo (DOT) com> wrote