I renamed the file.
I deleted all the rows.
Still can't get rid of it.
Still can't do a reload.
I will play with it some more -- but this is getting very frustrating.
----- Original Message -----
From: Walker, Buddy
To: RBASE-L Mailing List
Sent: Monday, November 01, 2010 2:09 PM
Subject: [RBASE-L] - RE: Strange Table
Bernie
Have you tried renaming the table. You will have to use the IDQuotes when
doing so. Once it is renamed use the "Design Table" and then look at the keys.
Try dropping the key from there. If that fails then I would suggest unloading
all to a file (test.all) and then edit file and manually remove the structure
and any data for that table. Once done run the file (test.all) to reload the
database.
Needless to say but make sure you are working on a copy of the database.
Buddy
From: [email protected] [mailto:[email protected]] On Behalf Of Bernard Lis
Sent: Monday, November 01, 2010 1:32 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Strange Table
I need to get rid of this table (it seems to be a copy of the customer
table)
If I try to delete it, it says that a col is being referenced.
Please help:
I can't find where this col is being referenced.
R>list constraint for 49ee1862
Table Name: 49ee1862
Id Type Column Name(s) Ref Table Name Ref Column
Name(s)
------ ---------------- ------------------ ------------------
------------------
#55 PRIMARY KEY CustomerNo
Note that there is no ref Table Name and no Ref Col Name
R>list fkeys Doesn't seem to shed any light on this -- unless I don't
know how to interpret the Id#
does the id shown below have any relation to a primary key or merely a
number assigned to a foreign key?
Id Type Table Name References
------ ----------------------------- ------------------ ------------------
#67 FOREIGN KEY ServiceContract OrderHeader
#93 FOREIGN KEY Credits OrderHeader
#78 FOREIGN KEY OrderTrucks OrderHeader
#81 FOREIGN KEY ProposalDetail Proposal
#82 FOREIGN KEY SCSchedule ServiceContract
#83 FOREIGN KEY SCService ServiceContract
#84 FOREIGN KEY SCOrders ServiceContract
#88 FOREIGN KEY OrderRemark OrderHeader
#89 FOREIGN KEY dbdummy2 DBDummy
#90 FOREIGN KEY Debits OrderHeader
#42 FOREIGN KEY Payments OrderHeader
#65 FOREIGN KEY OrderDetail OrderHeader
#63 FOREIGN KEY OldDtl OldHdr
