Emptying tables...

[Ruslan Zasukhin]

on 7/13/03 3:11, Chuck at rwc1717 at shaw.ca wrote:

> I have created a database with 5 tables to keep track of report data...
> 
> Two of the tables contain the actual information and the other three have data
> that is 
> used in the report filling in process.
> 
> The latter three tables are what I want to create an client.xml file of to be
> able to use 
> just that info on other machines.
> 
> Is there an easier way than backing up the data...emptying the first two
> tables...creating the client.xml..and then restoring the backup?

Hi Chuck,

You want delete all records in table?
What API you use?

You can do this using SQL:  DELETE FROM T
Or you can use BaseObject.DeleteAll()

To restore tables back you can use ASCII export import


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------