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.
> --------------------------------------------------------------------------
----
> 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.
----------------------------------------------------------------------------
--
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.
------------------------------------------------------------------------------
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.
