Welcome! Log In Create A New Profile

Advanced

Deleting Table in db

Posted by JOHN LOW 
JOHN LOW
Deleting Table in db
November 10, 2021 06:26AM
Hi,

I am creating a random table name based on YYYYMMDD_HHMM using HF Classic (and in other DB like MS SQL).

I want the application to delete the physical table when program end.
I can delete the HF Classic using fdelete command as it' a physical file in the folder.

Which command i can use to do the deletion of the table within the MS SQL db?

Thanks & Regards,

JOHN LOW
Re: Deleting Table in db
November 10, 2021 06:41AM
Hi, using WLanguage, you should use HCreation(FileName) ...

Kind regards,
Guenter Predl
office@windev.at
Re: Deleting Table in db
November 10, 2021 08:46AM
Maybe look at DROP TABLE
Re: Deleting Table in db
November 10, 2021 07:11PM
Hi John,

hDeleteFile?

Best regards,
Piet
Author:

Your Email:


Subject:


Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: