PLEASE HELP! damaged .dbt files

Dr C{*word*157}te Gamsu

Delphi Developer

Wed, 31 Jul 2002 03:00:00 GMT

PLEASE HELP! damaged .dbt files

Please - can anyone help me?
I've been using dBase files since the beginning of time but just
recently have begun to have inexplicable problems with memo fields - ie
*.dbt files
These include:

*** read and write difficulties
*** the wrong memo field contents being associated with a record or with
one of several memo fields in a record

How od I stop this happening?

Can I retrieve the memo contents and re-link them to the correct record
and correct memo field?

C{*word*157}te

Dr C{*word*157}te Gams

Delphi Developer

Thu, 01 Aug 2002 03:00:00 GMT

Re:PLEASE HELP! damaged .dbt files

Carl,
This has happened on a stand-alone system and on a network system. In each
case, SHARE LOCAL is true!
Any other ideas?
C{*word*157}te

Quote

Carl Caulkett wrote:
> In article <38A5652E.F9A6E...@gamsu.sol.co.uk>, charlo...@gamsu.sol.co.uk
> says...
> > Please - can anyone help me?
> > I've been using dBase files since the beginning of time but just
> > recently have begun to have inexplicable problems with memo fields - ie
> > *.dbt files
> > These include:

> ---8<---

> Hi C{*word*157}te,

> Are these dBase files on a network and does your app access them via the
> BDE. If that's the case, I wonder if it is a LOCAL SHARE issue. Maybe a
> user started digging around in the BDE setup and changed LOCAL SHARE to
> false which would make your data more susceptable to corruption.

> --
> Carl

Dr C{*word*157}te Gams

Delphi Developer

Thu, 01 Aug 2002 03:00:00 GMT

Re:PLEASE HELP! damaged .dbt files

John,
I can well believe my users are being heavy handed and or impatient at times!
:-)
"rebuilding table" will fix.... do you mean i just need to create an empty file
and then copy record by record across? (Keeping my fingers crossed and hoping
you say its as simple as this)
C{*word*157}te

Quote

John Donnewald wrote:
> Some of the biggest culprits are network disconnects, power outages,
> improper database exits, turning off PC, deadly embrace, and most likely
> while in the edit mode for any of the above. It has been my experience
> that, despite what a user may tell you, someone is not exiting their system
> properly. The larger the table, as well as any overhead it may carry with
> it (i.e., several key fields, many memo fields, many validity checks, etc.)
> the more susceptible it is. Especially on a LAN, tables such as this flow
> like a traffic jam, i.e, speeds up, slows down, and once everything catches
> up to it, it speeds up again. It's during that "catch-up" period when a
> table is particularly vulnerable. Hopefully, rebuilding the table will fix
> the problem.

> Dr C{*word*157}te Gamsu wrote:

> > Please - can anyone help me?
> > I've been using dBase files since the beginning of time but just
> > recently have begun to have inexplicable problems with memo fields - ie
> > *.dbt files
> > These include:

> > *** read and write difficulties
> > *** the wrong memo field contents being associated with a record or with
> > one of several memo fields in a record

> > How od I stop this happening?

> > Can I retrieve the memo contents and re-link them to the correct record
> > and correct memo field?

> > C{*word*157}te

> --
> ** Superior software quality and good documentation **
> ** should eliminate the question. Demand it! **

John Donnewal

Delphi Developer

Sun, 04 Aug 2002 03:00:00 GMT

Re:PLEASE HELP! damaged .dbt files

Some of the biggest culprits are network disconnects, power outages,
improper database exits, turning off PC, deadly embrace, and most likely
while in the edit mode for any of the above. It has been my experience
that, despite what a user may tell you, someone is not exiting their system
properly. The larger the table, as well as any overhead it may carry with
it (i.e., several key fields, many memo fields, many validity checks, etc.)
the more susceptible it is. Especially on a LAN, tables such as this flow
like a traffic jam, i.e, speeds up, slows down, and once everything catches
up to it, it speeds up again. It's during that "catch-up" period when a
table is particularly vulnerable. Hopefully, rebuilding the table will fix
the problem.

Quote

Dr C{*word*157}te Gamsu wrote:
> Please - can anyone help me?
> I've been using dBase files since the beginning of time but just
> recently have begun to have inexplicable problems with memo fields - ie
> *.dbt files
> These include:

> *** read and write difficulties
> *** the wrong memo field contents being associated with a record or with
> one of several memo fields in a record

> How od I stop this happening?

> Can I retrieve the memo contents and re-link them to the correct record
> and correct memo field?

> C{*word*157}te

--
** Superior software quality and good documentation **
** should eliminate the question. Demand it! **

Carl Caulket

Delphi Developer

Mon, 05 Aug 2002 03:00:00 GMT

Re:PLEASE HELP! damaged .dbt files

In article <38A60DF2.DBA33...@gamsu.sol.co.uk>, charlo...@gamsu.sol.co.uk
says...

Quote

> Carl,
> This has happened on a stand-alone system and on a network system. In each
> case, SHARE LOCAL is true!
> Any other ideas?
> C{*word*157}te

Any recent software installations, in particular Corel Wordperfect -
version 8 (I think) did strange things to the BDE.

Did you know that the Borland newserver carries a few groups dedicated to
Visual dBase. They all start with borland.public.vdbase. Maybe someone
there may be able to help.

Also I've just done a newsgroup search on "memo dbt" and have found quite
a few postings relating memo corruptions.

Try this page to search deja.news ...

http://www.exit109.com/~jeremy/news/deja.html

HTH,
Carl

Dr C{*word*157}te Gams

Delphi Developer

Sat, 10 Aug 2002 03:00:00 GMT

Re:PLEASE HELP! damaged .dbt files

Ooops! I've been posting from within Netscape and had not set the options.
Thanks for pointing this out to me.

C{*word*157}te

Quote

"Ralph Friedman (TeamB)" wrote:
> In message <38AEBCFD.4BFFD...@gamsu.sol.co.uk>, Dr C{*word*157}te Gamsu
> stated:
> > <!doctype html public "-//w3c//dtd html 4.0 transitional//en">
> > <html>

> C{*word*157}te,

> Please don't post in HTML. As well as going against newsgroup rules, it
> inconveniences everyone whose news reader is not HTML capable. You will
> find the rules at

> http://www.borland.com/newsgroups/guide.html

> Thanks for your cooperation.

> ===
> Regards
> Ralph (TeamB)
> ===