G'day Eric, At 01:59 PM 06/12/2001 -0600, you wrote: >So there is no actual constraint created from this.... ok, got it. > >I was assuming that I couldn't drop this table because I had this >'parlance' (that must be french for limitation). When I try to drop >the table the error is 'This table is referenced by a Foreign Key'. >Which I now found which column has a foreign key referenced against it, >but don't know what table is referencing it (how do I find this?). > >What I have is a multi level problem. I can't drop the table because >there's a foreign key, of which I have no idea which table is linked. >Secondly, I cannot just go and ALTER the table because there's another >table in the DB that contains a column name that I want to use in this >table.
In addition to prior posts... I do not know if this is what you are running into or not but in case it is here is the problem and a workaround. I suspect this may have been solved in the latest patch but prior to that R:BASE has an engine level bug which will cause a misreporting of the existence of a foreign key where there is none. Bill is right, R:BASE does not automatically create foreign keys but it will sometimes disallow the deletion of a table (in my case which HAD a foreign key referencing it) which currently has no foreign key. At a wild guess someone may have named the two columns the same, later seen the same names, thought that there should be a PK\FK relationship and created one, realised their mistake and removed it but R:BASE thinks that a link still exists. Warmest regards, Tom Grimshaw coy: Just For You Software tel: 612 9552 3311 fax: 612 9566 2164 mobile: 0414 675 903 post: PO Box 470 Glebe NSW 2037 Australia street: 3/66 Wentworth Park Rd Glebe NSW 2037 email: [EMAIL PROTECTED] web: www.just4usoftware.com.au This email and any files transmitted with it are confidential to the intended recipient and may be privileged. If you have received this email inadvertently or you are not the intended recipient, you may not disseminate, distribute, copy or in any way rely on it. Further, you should notify the sender immediately and delete the email from your computer. Whilst we have taken precautions to alert us to the presence of computer viruses, we cannot guarantee that this email and any files transmitted with it are free from such viruses. ================================================ 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
