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.
