Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 7 of 7 total |
EDBTable.Empty?? |
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. |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |