Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread How to do an EmptyTable
Sun, Jul 22 2007 9:53 PMPermanent Link

Sergei Safar
Hi all,

I am migrating my DBISAM 4 app to EDB 1. How to do a EDBTable.EmptyTable ?

Thank you.

Sergei Safar
Mon, Jul 23 2007 3:13 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Sergei,

<< I am migrating my DBISAM 4 app to EDB 1. How to do a EDBTable.EmptyTable
? >>

You have to use:

DELETE FROM MyTable

This is due to RI and foreign-key constraints.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tue, Nov 6 2007 11:18 AMPermanent Link

R
"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Sergei,

<< I am migrating my DBISAM 4 app to EDB 1. How to do a EDBTable.EmptyTable
? >>

You have to use:

DELETE FROM MyTable

This is due to RI and foreign-key constraints.

--
Tim Young
Elevate Software
www.elevatesoft.com



Tim,

Would I still do this using the TEDBTable component?

Cheers
R
Tue, Nov 6 2007 1:06 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com


<< Would I still do this using the TEDBTable component? >>

You could do it via the TEDBTable component, but it is usually easier to
simply use a TEDBQuery component or the TEDBDatabase.Execute method and just
execute the statement DELETE * FROM MyTable.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image