First time! (This will be quick)

[Degenerate]

IPT assignment is due in about 4 weeks and the teacher has dont nothing. So,
i decided that i will try and learn some things first. Anyway:

The database i am making is a simple one that monitors stock in a warehouse.
Ofcourse, you can order and send goods out. So i have done the Conceptual
Schema and the tables headings and columns are all ready.

I played around with Delphi for about 4 hours now. I realised that i will
need a main window with links to other forms. So, not getting complicated
here, i want something like a form with these fields (text, number and
dropdown) that will allow the user to enter the information about each
order. What is the basic idea that i have to use to move the data from these
fields once i created them, to store in the tables??

Thanks you.

 

[Alphathree33]

I'm a little foggy on what you want to do, exactly, although if you make it clearer I can definitely help you.

 

[Degenerate]

well.. its getting bad.. the teachers said that this year we are using Delphi first. But the problem is that they dont know it either! so we have to figure it out ourselve.

Anyway, It is all a clody thing for me to. but i know how to:
- Create the tables using SQL in Database desktop
- Edit (select, insert, update, delete) tables using SQL in database desktop.

A more general question is what would i need to know (basically) to intergrate the SQL tables with the forms (interfaace) of Delphi? The basic ideas...

 

[datalink7]

First time! (This will be quick)

Probably. But I heard you get better as you do it more.

 

[Degenerate]

okay.. i spent like 2 hrs just reading hekp files and online books. I seem to find that using BDE is good.

- So i created a table named "product.db" using database desktop. It was the populated with some sample data.
- Went into Delphi and created a TQuery. And in its properties, SQL, i tried to type in what i learnt was a select command and it says file not found or something.
- I went back to databse desktop and made a SQL there and ran it sucessfully. I saved that SQL file

Now how do i get it to work in Delphi (say like on a button)? Is the SQL in delphi the same?