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
