I didn't think of it with JM's original post, but you could walk down sys_Tables with a cursor (excluding "sys_*" sys_table_names and sys_table_type "view") and compare sys_num_rows to sel count(*) for each sys_table_name.
Ben Petersen On 21 Aug 2002, at 8:49, William Mason wrote: > No real way to test for it that I know of in code, unless you can trap the > SELECT COUNT(*) value and then write the LIST TABLE tablename output to a > file and parse your way to the row count value and compate the two. If they > are different, you have a problem. > > William > > ----- Original Message ----- > From: "J.M. GRATIAS" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, August 21, 2002 2:56 AM > Subject: Corrupt Indexes > > > > > > William : > > > > >> > > Just a follow up to the corrupted text indexes - we have been bitten again > > by this bug. I have never in my years of experience with R:Base had so > > many index problems, until (it seems) that we began to use long text > values > > for keys (Text(36)) - perhaps R:Base is having trouble with these. > > << > > > > Yesterday a client complained about a report that print twice the same > > rows. > > They send me a DB backup and the problem comes from a corrupted index on a > > TEXT (4) FK > > No concurrent activity (SET MULTI is OFF and app is installed on the local > > drive). > > > > Using RBW6.5++ (build 1.851xRT03). > > > > An other client had the same problem last month .... > > > > I have the feeling (may by wrong) that the problem is more frequent now > > than it was with older versions. > > > > > > Is there a simple way to detect the problem (AUTOCHK is no help for that) > ? > > It is important for me to detect the problem before printing wrong reports > > .... > > > > To correct it, I ask then to do a RELOAD, which is not a trouble because > up > > to now I have no multi users on the same DB. > > > > TIA, > > > > J.M. GRATIAS, Logimatique > > ================================================ > > 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/ > ================================================ 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/
