Tom, My take on this is that you need to use the following command:
ALTER TABLE TranHeader DROP CONSTRAINT #1210 -- Jim Bentley American Celiac Society [EMAIL PROTECTED] - email (973) 325-8837 voice (973) 669-8808 Fax ---- Tom Grimshaw <[EMAIL PROTECTED]> wrote: > G'day. > > I have a foreign key constraint numbered #1210 on the column > EntityID in > the table TranHeader. Without success I have tried the following > ways to > drop it and received the following error messages: > > DROP INDEX #1210 -ERROR- #1210 not found ( > 46) > DROP CONSTRAINT #1210 - Syntax is incorrect for > the command > DROP (2045) > DROP INDEX TranHeader.EntityID -ERROR- INDEX not found ( > 46) > DROP INDEX EntityID IN TranHeader -ERROR- INDEX not found ( > 46) > > Doing a search of the R:BASE 6.5++ on-line help says that DROP > CONSTRAINT > is a valid command but it is not in the command index. > > I need to do this programmatically rather than through RBDefine > as it will > be going to my clients as part of a large update. > > Before I report it as a bug: > 1. Am I using the correct syntax? > 2. Do you have an alternate way of programmatically dropping > a foreign key? > 3. If you are using the latest patch (R:BASE 2000 1.855xRT03) > could you > test dropping a foreign key programmatically and verify that > it is not just > my computer and I having a bad KEY day? > > 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 > > "... the control of impulse -- is the first principle of civilization."-- > > Will Durant, > Pulitzer Prize winning philosopher, writer and historian > > the most needed product in the world can be found at > www.thewaytohappiness.org > > 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 > ================================================ > TO SEARCH ARCHIVES: > http://www.mail-archive.com/rbase-l%40sonetmail.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/
