Need help !! (delete records in db)

[kevin_w]

Hi,


Ok first i gonna set things up:

- I have a kind of maintenance program that make use of a progress db
- This db contains demo records that i want to delete
- Version of progress is 8.3B (and i got no updates to a higher version)
- Program is working as a stand-alone and running under Windows 2000 Pro
- I don't know much about progress, only thing i know progress is a db-prog
- I have only a *.db and *.bi file nothing more ! no *.st, *.df, ...
- I know that the database is not a multi-volume database


So this is what i wanne do, cleaning the database so that i got a new empty db but with the same database schema or tables. I all wanne do this on a easy way because i don't understand command like "FOR EACH table_name", ... The only thing that i have do is starting and shutting down the database in a DOS-window. SO i'm looking for someone who can tell me how to do this step by step and in the easy way, or someone who can do it for me. keeping the above things in mind. I don't think that it is a very time-taking job, and the db and bi file is only 1.9mb zipped so it can be sent by email. Anyone who can help me, i have a lot of previous threads on this forum but non of them make me wise what to do. Please i'm really need help, because i want to use the db for experimental use but first the old records must be out of it.

Thanks,

Kevin

 

[BONO]

Hello,
if u want to create a new empty database monovolume in 8.3 with same schema do this:

- double clic on you're first database(wich is stopped). (Then le data dictionnary is launched)
- from menu , choose tools/data administration (the data administration is launched)
- Then Choose from the menu admin\dump data and definiation\data definition (.df file)
- a window appear, click select some, let * on the fill in and clickok, ok a second tim to valid then choose outut file de stination andclick ok.

- Now u've a df.

- close data administration and data dictionnary

- launch datadictionnary from start menu of windows\progress ...
- Choose create a new empty database.
- Then choose tools\data adminsitration
- then from da, choose admin\load\data definition (.df file) and then valid.


Now u've a new empty database

So then u've to create good icons .pf and .ini file to use it like youwant. There is many ways to create new emty database, so it's thesimpliest for u.

Hope it's help