Access works exactly the same. You need to perform a "Compact Database"
operation to free up the space occupied by deleted records.
Jim
-----Original Message-----
From: Michael O Reilly <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thursday, May 25, 2000 11:20 AM
Subject: RE: DBASE
>Having the deleted records hidden is one thing, but actually getting rid
of
>deleted records is a different issue.
>Unless you PACK a DBF file, the records are only marked as deleted, which
>means that over time the file will become huge.
>Unless I'm wrong, there is no way of automatically PACKing a DBF from CF.
>The Database would need to be taken off-line occasionally.
>I'm currently investigating this problem for a CF site I developed.
>I'd forgotten all about Dbase and the need to PACK the database when a
>Client asked if I could use there preferred database (Foxpro).
>
>Regards
>Michael O'Reilly
>Analyst Programmer
>TransAer
>
>
>
>-----Original Message-----
>From: Howie Hamlin [mailto:[EMAIL PROTECTED]]
>Sent: 25 May 2000 16:25
>To: [EMAIL PROTECTED]
>Subject: Re: DBASE
>
>
>No database removes deleted records immediately. The area is simply
marked
>as deleted. In the ODBC settings for Dbase the default is to show
deleted
>records (why that is the default I'll never understand). Anyway, change
>that setting and then you won't see deleted records in your queries...
>
>HTH,
>
>Howie
>
>----- Original Message -----
>From: Michael O Reilly <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Thursday, May 25, 2000 10:40 AM
>Subject: RE: DBASE
>
>
>> DSN issues aside, I would avoid using DBF's from CF because although
you
>can
>> delete records from the DB with an SQL statement, you have to perform a
>PACK
>> on the table before they are actually physically removed.
>>
>> And guess what, it isn't possible to PACK the DB from Coldfusion
without
>an
>> external application or CFX.
>>
>> Regards
>> Michael O'Reilly
>> Analyst Programmer
>> TransAer
>>
>>
>> -----Original Message-----
>> From: Helge Hetland [mailto:[EMAIL PROTECTED]]
>> Sent: 25 May 2000 15:26
>> To: '[EMAIL PROTECTED]'
>> Subject: DBASE
>>
>>
>> Is it possible to register a dbase in CF admin once and then use the
same
>> dsn name in many directories?
>>
>> I'll have multiple directories/users that will need to use a database
with
>> identical tables but with different content.
>>
>> I need the syntax for something like this:
>>
>> <cfquery name="Testdata" datasource="/www/users/username/db/db.dbf">
>> select bla,bla,bla
>> </cfquery>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
