Board index » off-topic » Error: Detail table(s) exits

Error: Detail table(s) exits


2007-09-05 10:45:11 PM
off-topic10
Hi Group
When executeing this SQL:
ALTER TABLE Class
ADD Promote1No INTEGER,
ADD Promote2No INTEGER
I get this error message "Detail table(s) exist". Not on all copies of the
database. I runs ok in many locations, but at 2 locations so far, I get this
error message.
Can anybody help me? I use BDE 5.2.2.
Thanks
Jacob
 
 

Re:Error: Detail table(s) exits

Jacob
If you're using Paradox tables,
you probably have Referential Integrity declared for those tables. Remove
the RI, alter the table, and add the RI back.
--
Bertil Isberg - CTECH
Paradox buglist:
online: hem.bredband.net/bertilisberg/
"Jacob Havkrog" < XXXX@XXXXX.COM >skrev i meddelandet
Quote
Hi Group

When executeing this SQL:

ALTER TABLE Class
ADD Promote1No INTEGER,
ADD Promote2No INTEGER

I get this error message "Detail table(s) exist". Not on all copies of the
database. I runs ok in many locations, but at 2 locations so far, I get
this error message.

Can anybody help me? I use BDE 5.2.2.

Thanks
Jacob