Delete records with Memofield?!?

Thread View: borland.public.cppbuilder.database.multi-tier

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Ingo Sigl Wed, 15 Sep 1999 00:00

#1457

Author: Ingo Sigl
Date: Wed, 15 Sep 1999 00:00

13 lines
1090 bytes

I have a Table with a formatted memofield for rtf-text. If I delete
one or all records with 'Table.Delete' the size of the paradox-files
x.db and x.mb are not changing (getting smaller). The DatabaseDesktop
shows that the records are deleted but only if I empty the table
by the DatabaseDesktop the size of the files are correctly.
It is possible that the records are only marked as being deleted
and are still physically present??
How can I actually delete the records??
In the case of tables without memofields it functions correctly.

Thanx a lot for any hints

ingo.sigl@online.de

Re: Delete records with Memofield?!?

#1467

Author: Mark Cashman (TeamB BCB)
Date: Thu, 16 Sep 1999 00:00

25 lines
1452 bytes

Hi, Ingo!

Desktop databases like Paradox often require a "pack" to remove deleted
records. See

http://www.temporaldoorway.com/programming/cbuilder/databaseandbde/packingtables.htm

for more info. Also note that desktop database questions are best asked
in borland.public.cppbuilder.database.desktop. The .multi-tier group is
for questions on multi-tier database problems.

Have a look at

http://www.temporaldoorway.com/programming/cbuilder/newsgroup/index.htm

for more on the groups and their topics.

------
Mark Cashman (TeamB - C++ Builder), creator of The Temporal Doorway at
http://www.temporaldoorway.com
- Original digital art, writing, music and more -
C++ Builder / JBuilder Tips and The C++ Builder Programmer's Webring
(Join us!)
http://www.temporaldoorway.com/programming/index.htm
------

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads