🚀 go-pugleaf

Vladimir I am trying to learn from the example project you put on BDN, but I
am finding the documentation a touch too terse.  Overall, though, I find it
to be a very nice example apparently covering most of what I need to be able
to do.  AND, examining the executable it produces using Dependancy Walker,
it does not require any DLLs other than those provided with Windows (unless
I compile with codeguard active), and this is exactly what I need!

Could I get from you an explanation of the calls involving ADO in the
Database, StoreQuery, AddQuery and AddIndex forms?  What makes understanding
what ought to be happening more difficult is that you didn't set the names
of any of the forms or controls to anything other than their default values.

Could I also get a little advice on a project I'm working on?  I need to
provide a couple of MS Access databases with my application.  The user is
not permitted to change the structure of either, and the one is completely
read only.  The second can have as many instances as posible (imagine a
bookshelf with a dozen recipe books on it, all with the same format but each
having recipes from a different cuisine).  And, if the user wishes to do so,
he can create as many instances of the second database, giving each a
different name of course, as he wishes.  Therefore, I need to get from the
user the filename for the database he wants to create (is you illustrate in
your mainform), but then, without user input, create several tables, the
fields for each table, and logical relationships between tables so that the
database is ready to receive data from the user.  I also need to be able to
enumerate the tables in an existing database, and the field names within a
given table, and then use the result to retrieve selected data from the
database (the actual query will involve a join of several tables, exploiting
logical relationships between tables).

I believe I can do all of this using SQL, but my SQL is more than a little
rusty.  I want the first version of my program to be as simple as is
practicable, using only the basic VCL components shipped with BCB5Pro for
the interface, the STL for the application logic, and and ADO for the
connection to the MS Access databases.  The simpler I can make my program,
the les likely it is that there'll be a significant bug to cause problems
for me, and, with the structure I have in mind, it ought to be simple to
replace the VCL by wxWindows should that eventually prove to be necessary,
as well as replace the ADO technology with something more portable should
that prove to be desirable.

Some other questions come to mind: 1) Can the same thing be done using, say,
MySQL?  2) If so, would it be terribly difficult to copy the contents of an
MS Access database to a MySQL database with the same structure and
relationships?  3) Do you know if ADO is available on Linux, and if it
isn't, how would a program like your example access a MySQL database on
Linux?

Any suggestions would be greatly appreciated.

Thanks,

Ted