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 Solutions, Inc. - www.CoolFusion.com inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server PrismAV - Virus scanning for ColdFusion and BlueDragon applications Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ iMS-Lite - the completely free mail server solution for applications and application servers http://www.coolfusion.com/iMSLite --- On Saturday, August 13, 2005 9:12 PM, CFDEV scribed: --- > > Since some of you seems to have work with dbase before.. when i use > the > delete query my record seems to be deleted but when i download the > dbf file > and open it, i still see my records? how do we completly delete them? > I > remember something about this in flat file database like foxpro and > dbase.. > > Thanks > > Pat > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214974 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54