Delete contents of table?
Delete contents of table?
Hello all
I've never used dataease before so hoping im in the right place!! I have a customer has it that I work with. They use it to hire out and sell products and gather customer information at there shop. This customer has now opened a new shop and wants the same system.
I have purchased an additional licence and installed DataEase 6.5.3.3158 and took a copy of their existing database. I want to keep all the forms and tables as they are but delete all the content for example I have a table that has a list of products (3000+) and I want to effectively start a fresh but keep the system intact and working without any of the previous sites data in it.
is this possible?
Re:Delete contents of table?
It is rather straight forward but will take a little "programming".
Just open the application in designer mode (catalogue).
Chose
New/Procedure (DQL).
in the DQL you simply write:
delete records in <tablename> .
Compile and run.
This will delete all the records in <tablename>.
You will find a list of the table names at the bottom of the screen.
Repeat for all the tables you want to "empty".
There might be tables that is used for system support so don't delete data in tables that you don't know what do ;-)
Re:Re:Delete contents of table?
Brilliant, thanks for your quick response that has worked.