Go into the standard windows ODBC settings and edit the datasource settings.
View the extended options. One of the options will be Show Deleted Rows.
This is on by default. Uncheck that setting and you should be good to go.
HTH,
--
Howie Hamlin - inFusion Project Manager
On-Line Data
Note, that will hide the deleted records, however they will still exist in
the database until you run a pack routine.
-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]
Sent: Monday, August 15, 2005 7:35 AM
To: CF-Talk
Subject: Re: Last dbase 4 question
Go
Right - but that setting will cause the problem where deleted records are
returned by a query which is in response to the original question. Also,
deleted record space may be reused during record inserts so packing the
database manually would not usually be necessary unless a large number of
As I recall, that's by design. Dbase tags the record as deleted until you
do a cleanup (purge/compact). Then it finally comes out of the database.
Constanty Connie DeCinko III
Web Architect, Webmaster, Web Developer
Lone Jet Enterprises
Glendale, Arizona
www.LoneJet.com
-Original
Do you know if there is a way to do this by ColdFusion?
Pat
-Original Message-
From: Connie DeCinko [mailto:[EMAIL PROTECTED]
Sent: August 13, 2005 21:44
To: CF-Talk
Subject: RE: Last dbase 4 question
As I recall, that's by design. Dbase tags the record as deleted until you
do
You want to pack the database. See if this works. It does in .NET.
Select * from table;pack
-Original Message-
From: CFDEV [mailto:[EMAIL PROTECTED]
Sent: Saturday, August 13, 2005 7:01 PM
To: CF-Talk
Subject: RE: Last dbase 4 question
Do you know if there is a way to do
6 matches
Mail list logo