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/
