U++ forum: Welcome to the forum

Re: More .sch files? [message #34816 is a reply to message #34811]

Tue, 13 December 2011 17:52

mirek
Messages: 14267
Registered: November 2005

Ultimate Member

Wolfgang wrote on Tue, 13 December 2011 10:54

I asked my how to make use of more than one .sch file, I mean if I want to use more than 1 sqlite3 database and want to use schema files?

For one it is clear, first I tell which file I want to use

#define SCHEMADIALECT <plugin/sqlite3/Sqlite3Schema.h>
#define MODEL <urlaub/urlaub.sch>

and then

SqlSchema sch(SQLITE3);
    All_Tables(sch);
    SqlPerformScript(sch.Upgrade());
    SqlPerformScript(sch.Attributes());

but I can't see how to specify more than one file for more than one database!

If I understand well where the problem is:

You can specify SqlSession as first SqlPerformScript parameter.

It is true that using more databases is somewhat more diffult, it is recommened to add NOAPPSQL config flag - that kicks out global SQL (and new SQLR), which is usually a source of errors in multidb apps...

Mirek

Report message to a moderator