Here's a suggestion for a new product:
An SQLyte Database - FF Project Generator
What I would have it do:
Through a Q&A Wizzard gather the following infomation
1) Name for Database
2) Number of Tables in the database and their Names
3) The names of the fields in each Table
4) Ask which fields indexes should be created
Once that information is gathered, then the Generator would do:
1) Create the database
2) Build a Skeleton FireFly Project
a) Create one FF Form for each Table
b) On the Form create a TextBox and Label for each Field in that Table
c) Generate code to do: Add Record, Find Record, Modify Record, Browse records, Delete record
d) Do this for each Table in Database
e) Create the FF project directories and as much as possible keep the
code that manipulates the DB in INC files
Such a Database/FF Project Generator would allow a quick way to generate a Skeleton Database Project which could be easily modified to the liking of the programmer. I believe there would be a lot of demand for such a Product. Many novice programmers would like a way to get into simple DB programming and this would open that door for them. Also, many professional programmers could benefit from such a Generator by creating a Database Program in minutes, what might otherwise take hours or days. Time is money. And this would be a valuable Product that saves you time and money.
If such a product was available today I would buy it.
Paul, you of coarse would be the perfect programmer to put such a generator together. You know FF and SQLite/SQLitening better than anyone else.
Rolf, I think you could produce such a product also. How about it?
How many forum members here would be interested in such a product?
Hmm - its worth thinking about it.
That would be very cumbersome and confusing.
To create databases, tables, indexes, etc, why not just use SQLiteExpert?, and speaking of which, take a look at the "demo database" that comes with it (21 tables), now imagine that using your suggestion.
Ivan, I would have to disagree. Yes, you can use SqliteExpert and I do use it. But does SQLiteExpert generate an FF skeleton project with the basic coding to begin accessing the database. No.
I suppose another way would be to have the Generator program read a SQLite database (which was created by what ever means) and generate a skeleton FF program that would have the basic database manipulation functions for each Table in a manor discribed above.
I have used 4th gen Database Programming Languages such as CA-Cliiper. And they do exactly this type of thing. They can take the tedium out of creating a database program. This is especially handy when you just need to get a quick DB put together. With such a program you can have working DB program running in 10 minutes. I see great advantages to this.