U++ framework: U++ SQL » More .sch files?

Home » U++ Library support » U++ SQL » More .sch files?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Tue, 13 December 2011 17:52

mirek
Messages: 14291
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

[Message index]

		More .sch files? By: Wolfgang on Tue, 13 December 2011 16:54
		Re: More .sch files? By: mirek on Tue, 13 December 2011 17:52
		Re: More .sch files? By: Wolfgang on Tue, 13 December 2011 21:31
		Re: More .sch files? By: mirek on Wed, 14 December 2011 07:19
		Re: More .sch files? By: mirek on Wed, 14 December 2011 08:53
		Re: More .sch files? By: Wolfgang on Wed, 14 December 2011 09:26

Previous Topic:	sql + editstring
Next Topic:	BUG with "Run to cursor (in debug)"

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Sep 17 06:06:37 GMT+2 2026

Total time taken to generate the page: 0.00993 seconds