You have used the syntax from a different SQL compatible system. R:Base follows:
CREATE TABLE artist_keywords+ (+ artistkeys_id INTEGER NOT NULL PRIMARY KEY,+ keyword TEXT 50 NOT NULL UNIQUE,+ ) CREATE TABLE artistkeys_ln+ (+ catalog_id INTEGER FOREIGN KEY REFERENCES catalog,+ artistkeys_id INTEGER FOREIGN KEY REFERENCES artist_keywords + ) David Torre <[EMAIL PROTECTED]> wrote: >Hi all, > >I'm trying to use the following commands to create some tables that have a >PK/FK relation. I already have a table "catalog" that has the "catalog_id" >PK. For some reason, the tables are created fine in the DOS version, but >in the Windows version, I get an error message using the exact same >code. Now this is a problem because I have a command module that runs fine >in the windows version, but runs out of memory in the DOS version. Any ideas? > >CREATE TABLE artist_keywords+ > (+ > artistkeys_id INTEGER NOT NULL UNIQUE,+ > keyword TEXT 50 NOT NULL UNIQUE,+ > PRIMARY KEY (artistkeys_id) > ) > >CREATE TABLE artistkeys_ln+ > (+ > catalog_id INTEGER,+ > artistkeys_id INTEGER,+ > FOREIGN INDEX (catalog_id) REFERENCES catalog (catalog_id),+ > FOREIGN INDEX (artistkeys_id) REFERENCES artist_keywords (artistkeys_id)+ > ) > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > -- __________________________________________________________________ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
