Close rbase and reopen. reconnect db try again Dennis McGrath Software Developer QMI Security Solutions 1661 Glenlake Ave Itasca IL 60143 630-980-8461 [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bruce A. Chitiea Sent: Wednesday, July 03, 2013 12:00 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Error 2801: Reference table does not exist
All: RBGeX95(64) 9.5.2.20611 The codes: 'ALTER TABLE TransTest2 ADD FOREIGN KEY (glCodeID) REFERENCES glCode' and 'ALTER TABLE TransTest2 ADD FOREIGN KEY (glCodeID) REFERENCES glCode (glCodeID)' ... elicit the error message: 'The referenced table does not exist (2801)' The referenced table and columns most certainly do exist, all data types match. ?? All thanks, Bruce --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
