rustytec
VP-CART New User
Australia
113 Posts |
Posted - September 13 2006 : 17:28:50
|
Hi skynet104,
You could run an SQL delete query that will remove the records from the table.
BYZ has a freebie Advanced SQL Execution tool that will allow you to do it. Becareful though, it is very powerful and there is no return from any action done.
You can find it from these great guys at: http://www.bigyellowzone.com/shopexd.asp?id=114
You would probably run the following to remove the full contents of the table:
"Delete * from searchresults" ~(without the "'s)
or if you only wanted to remove up to a certain ID or date :
"Delete * from searchresults where ID < 40000" ~(without the "'s)
- just edit the '40000' to be whatever amount of records you want to delete.
or:
"Delete * from searchresults where rdate <= #21/08/2006#" ~(without the "'s)
The only thing if the database is an access database then the records are removed, but the database still holds a 'memory' of deleted records until it is compacted. SQL does not have this problem.
With an access database you might need to download it in the end and run a compact. It is mentioned in other posts, however that on occassions running a compact may reset the internal table counters.
Best check with support on this prior to running a compact, but the above SQL will certainly remove the records.
cheers
Russ rustytec
|
|
|