U++ forum: Welcome to the forum

Re: Multiple schema files? [message #26962 is a reply to message #26958]

Mon, 14 June 2010 10:13

mirek
Messages: 13980
Registered: November 2005

Ultimate Member

jeremy_c wrote on Sun, 13 June 2010 14:03

Yes, but I am confused as to what your proposed solution is to my problem of wanting to have a log file database and also the static data file.

If I could manage two difference schema files, so that when I create one (say a new logbook) that it does not create all the static database table definitions, I could manage the rest with SQLite's attach/detach methods.

Hm, you want to have each logbook in differenet database?

Well, perhaps with SQLite, not a bad approach...

Quote:

I am just unsure of how to have two schema files that remain independent of each other but usable both usable in the same app.

I am just unsure where lies the problem? In the end, .sch file simply provides a single "All_Tables" *static* function. Use that to provide your own name for your schema function. Then each schema is represented by distinct function. Use it to create scripts, then use scripts to create model in each DB backend...

Report message to a moderator