How can i empty the whole foxpro db table using any trigger or stored procedure
+2
A:
The only way to empty a FoxPro table is first by getting exclusive access (ie no-one else has the file open and you can USE yourTable EXCLUSIVE): then you can use the ZAP command.
Stuart Dunkeld
2010-10-23 13:24:29