Board index » delphi » Detail table operation failed <Table Name>

Detail table operation failed <Table Name>

Hi,
what it's the reasone of this error [Detail table operation
failed <Table Name>] and how can i solve it at designe time
(i mean with help of Database desktop) and run time
(programmaticly)

thanks

Nima,

 

Re:Detail table operation failed <Table Name>


What database are you using? What operation are you performing on the detail
dataset that failed? Is that the complete and exact text of the error
message?

--
Bill

Re:Detail table operation failed <Table Name>


Hi,
my database is paradox.the case of error is always like this:
5 users works with database,after a while one user close
App and when he/she wants to open it again this error occured!
database is resided on Win NT4, size of the datatbase is 305 M
and local share is true for all BDEs, OptLock has been disabled
for Win NT4.
after this error, i try to open masters table with database desktop, but agian this error ocurred.
"Detail table operaion failed. members.db"
My Master tables are Business, Graduations, Cities and detail
table is Members,
relations are

BusID  -----  BusID
CityID -----  CityID
GrdID  -----  GrdID

Block size of Master tables are 2048 and Detail table is 16384

thanks
nima,

Re:Detail table operation failed <Table Name>


Hi,
I forgot to tell you something that might help you to detect
the error.

as i siad all users are working with DB without any error, just
after one user close APP and then wants to open it agian. but
all other users are still working with db without any error and
can post records to detail table!
but after closeing the App they can not open it again too,
because of that error.
when i want to open master tables with database desktop
agian this error occured so i could  not open them and any
changes to the structure of detial table is impossible because
of that error.
in order to solve this problem, i usually open database desktop,
copy detail table to on another folder, and delete it from the
database in order to delete referential integrity.
after that i can open master table without any error.
and know i create all referential integrity agian.
but this way is too lengthy, i thinks it might be some better
solution to overcome this problem (even programmaticly).

thanks
nima,

Re:Detail table operation failed <Table Name>


After this error has occured to one user try opening the detail table with
DBD and see what error message you get.

--
Bill

Re:Detail table operation failed <Table Name>


Hi,
i can open the detail table with DBD without any error.

tahnks

nima,

Re:Detail table operation failed <Table Name>


That is very strange. The only times that I have encountered that error is
when the detail table or one of its indices is corrupt. The only other thing
I can think of is that the referential integrity definition is corrupt but
it is hard to image how that could happen since the .VAL file where it is
stored is not updated as your application runs. Other than a hardware
problem the only thing I can suggest is that you make sure the BDE on
_every_ machine is configured as described in
http://community.borland.com/article/0,1410,15247,00.html .

--
Bill

Other Threads