U++ forum: Welcome to the forum

Re: sqlite.sch syntax with multiple tables [message #1343 is a reply to message #1325]

Tue, 28 February 2006 14:23

mirek
Messages: 14266
Registered: November 2005

Ultimate Member

wilho wrote on Mon, 27 February 2006 17:20

I'd be gratefull if someone could give me an example of sch -file with multiple tables specified. Seems that I can't create one properly.

TABLE_(SIMPLE_TEST1)
   INT_     (ID) PRIMARY_KEY
   STRING_  (NAME, 200)
   STRING_  (LASTNAME, 200)
   INT_     (BDATE)
END_TABLE
TABLE_(SIMPLE_TEST2)
   INT_     (ID) PRIMARY_KEY
   STRING_  (NAME, 200)
   STRING_  (LASTNAME, 200)
   INT_     (BDATE)
END_TABLE

won't work

The culprit is the '_' - you can use it only with the first appearance of name, it is a "signal" to create SqlId constant for the name.

While I do not exactly like this issue, the only alternative is to provide manual declaration of all database names.

Mirek

Report message to a moderator