The only issue I have with SDT is convincing the powers to be the price is worth it.
James E Harvey Corresponding Officer/M.I.S. Hanover Shoe Farms, Inc. www.hanoverpa.com office: 717-637-8931 cell: 717-887-2565 fax: 717-637-6766 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jeff Johnson Sent: Wednesday, August 08, 2012 8:11 AM To: [email protected] Subject: Re: corrupted table and database issues On 08/08/2012 04:27 AM, James Harvey wrote: > Thanks for the link, this utility looks interesting, and I see that > version 2008b includes a DBC testing and repair option. > > The error number returned when trying to open the corrupted table was 1683. > The cdx lost three indexes, and one field name was truncated by one > letter (pk_hshealth to pk_hshealt). > > DBC problems have been the bane of my existence over the years, as > they don't happen very often, but when they do it seems like it takes > voodoo to get them fixed. > > James E Harvey > Corresponding Officer/M.I.S. > Hanover Shoe Farms, Inc. > www.hanoverpa.com > office: 717-637-8931 > cell: 717-887-2565 > fax: 717-637-6766 > > John: Looks like the table was "freed" and the field was cut down to 10 characters. Years ago I was bugged by one field that had 11 characters. Since then I have always kept to 10 in order to add / remove and swap tables in and out of the dbc. Stonefield Database Toolkit is a dependency of my applications. I just had a customer delete the dbc and several tables and even a few cdx's for good measure. I was able to restore the missing pieces and run the stonefield repair utility and was back up and running in very little time. > Jeff > > --------------- > > Jeff Johnson > [email protected] > (623) 582-0323 > > www.san-dc.com > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
