Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 7 of 7 total

Fri, Sep 20 2019 5:45 AM	Permanent Link
Ian Branch	OK. I give up. How do you Zap/Empty a Table from an EDBTable? I can't find anything that vaguely looks like it. Regards & TIA, Ian
Fri, Sep 20 2019 9:04 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Ian Not sure I understand you correctly but if its what I think you want you use SQL - EMPTY TABLE tablename (you can also use DELETE FROM tablename but its lots slower) or from inside Delphi DeleteFile(tablename.tableextension) DeleteFile(tablename.indexextension) DeleteFile(tablename.blobextension) making sure you're not using then first Roy Lambert
Fri, Sep 20 2019 11:02 AM	Permanent Link
Yusuf Zorlu MicrotronX - Speditionssoftware vom Profi	Roy Lambert wrote: > > from inside Delphi > > DeleteFile(tablename.tableextension) > DeleteFile(tablename.indexextension) > DeleteFile(tablename.blobextension) > > making sure you're not using then first > But this works only if your server has "File I/O Buffering" not enabled! -- -- Yusuf Zorlu \| MicrotronX
Fri, Sep 20 2019 11:07 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Yusuf >But this works only if your server has "File I/O Buffering" not enabled! I think that's covered in my caveat >> making sure you're not using then first Roy
Fri, Sep 20 2019 5:05 PM	Permanent Link
Ian Branch	Hi Guys, FWIW I am back using XanaNews for this NG. Much Better. I know I can do it in SQL. I was wanting to do it from a EDBTable. Regards, Ian
Sat, Sep 21 2019 8:05 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Ian >I was wanting to do it from a EDBTable. You can't - you can from a TnlhTable - tablename.EmptyTable Roy
Sat, Sep 21 2019 6:58 PM	Permanent Link
Ian Branch	Roy Lambert wrote: > Ian > > > > I was wanting to do it from a EDBTable. > > You can't - you can from a TnlhTable - tablename.EmptyTable > > Roy Ah Ha! Bingo. Cheers.