Re: Last dbase 4 question
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
RE: Last dbase 4 question
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 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, ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214978 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Last dbase 4 question
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 records were deleted and you wanted to recover the disk space. Howie --- On Monday, August 15, 2005 10:52 AM, Connie DeCinko scribed: --- Note, that will hide the deleted records, however they will still exist in the database until you run a pack routine. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214991 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
Last dbase 4 question
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 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214924 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Last dbase 4 question
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 Message- From: CFDEV [mailto:[EMAIL PROTECTED] Sent: Saturday, August 13, 2005 6:13 PM To: CF-Talk Subject: Last dbase 4 question 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 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214928 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
RE: Last dbase 4 question
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 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 Message- From: CFDEV [mailto:[EMAIL PROTECTED] Sent: Saturday, August 13, 2005 6:13 PM To: CF-Talk Subject: Last dbase 4 question 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 ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214930 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Last dbase 4 question
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 this by ColdFusion? Pat ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:214931 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