> 1) getting the data from the files into the database
> 2) getting the data from the database into the listboxes, etc.
>
You probably aught to get a book like Swaine's quickstart guide because these
things are a little more complicated than can be easily explained. Here is an
outline.
1. database file -> database array
A. Open the file ... dialog box....getfolderitem ....
B. Do a SQL select statement to choose which (or all) data to read, this
creates a record set
(assumes you have created a database file already)
C. You check for it not being nil
D. If not, you create a loop to read the data in, line by line, and end
of "eof"
E. Where to put the data? I define a class (like a data structure) and
make an array of them
and read them one by one, expanding the size of the array each time,
so its a completely
variable sized array. This is a little task to learn too.
2. database array -> Listbox
A. Make a method, e.g. "List_Employees"
B. clear the list box contents - delete all rows - so it doesn't append
C. Loop over the array and add one row at a time to the listbox.
There is a certain formatting method to this which is unique.
It took me a long time, and the help of people on this list to get this work
ing. I would suggest starting very small - just make an simple example and get
it to work, the expand later.
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://www.realsoftware.com/listarchives/lists.html>
|