U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » sqlite.sch syntax with multiple tables

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

sqlite.sch syntax with multiple tables [message #1325]

Mon, 27 February 2006 23:20

wilho
Messages: 19
Registered: February 2006

Promising Member

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

Report message to a moderator

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

Tue, 28 February 2006 14:23

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

Previous Topic:	SqlArray seems to be broken
Next Topic:	SQL_MySql sample problem [SOLVED]

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sat Apr 27 18:20:55 CEST 2024

Total time taken to generate the page: 0.05005 seconds