How to delete company data

tbelliard · December 11, 2003, 1:43pm

Hello, I’d like to know how I can delete the data from The Light Company. If I delete TLC the data remain in the tables ? How can I do, is there a SQL script available ? Regards. Thierry

hua · December 12, 2003, 2:03am

That is easy!! I think you can not directly do this. 1,delete all database 2,reinstall; 3,restore a blank database.

tbelliard · December 12, 2003, 8:04am

Hi, yes it’s seems to be easy but if I have other data from other company I need to export data and import data from company I exported. Thanks

danang_ismu · December 12, 2003, 8:59am

hi Thierry, you mean you need to delete all the TLC company ? how about if you directly delete the company ? regards, Danang Ismu

ValS · December 12, 2003, 1:19pm

Metod: 1. Export all data. 2. Import data without transactions. How you can do this: 1. Export all data. (also you can export data with created Def.group p.2 of course ) 2. Create Definition groups: in tabkes groups take of - transactions; - worksheetline; - worksheetheader; 3. Import the data whit created Def.group.

tbelliard · December 30, 2003, 2:10pm

Thanks everybody, The solution I kept : export data from all companies I need except TLC, restore of application and database (empty !) import of companies I exported at step 1. Thanks