I am opening a form that is attached to a paradox table. When I exit or
close() the form I want to delete the table. The table is located in the
users private folder. If I try to delete it, it says it is 'cannot perform
this operation with table open'. Well I don't have the form open, so why am
I getting this error and why can't I delete the table.

Thanks for any help.
Dan

Hi Dan,

if it is a temporary table, just name it like __mytable.db.

Paradox is deleting tables automaticly when you close it.

The form can't delete the table, because it is attached to the table. so
if You want to go this way, first get the table out of your datamodel
and then delete it.

Thies


Dan schrieb:

Dan,
as Thies said. But then you might have some problems with the uiObject that
was bound to the table.
Wouldn't empty() the table do the same thing for you? And then it doesn't
matter that it is part of your datamodel.

Egbert, 18:03 in Germany

"Dan" <megaflex (AT) bellsouth (DOT) net> schrieb im Newsbeitrag
news:443fbdf2 (AT) pnews (DOT) thedbcommunity.com...

I open a selection form that has several display choices. I select choice
one to open a form associated with a newly created table (___shdwtble.db)
and an SQL created table for a client server database (__updatetag.db). The
form is created from a SQL server and placed in my private folder and the
form is displayed, OK. There are two tables in the data model and linked
together in a one to many relationship. I exit the form, back to my calling
form and I cannot delete either table, even though the form is closed. If I
select "Close All" in the development software, I can delete the tables
manually. The reasons I want to delete it so the table will be recreated and
refresh the data when I return to the choice one display. Does that clarify
the situations?

Thanks for you comments,
Dan
"Thies Grimm" <thies.grimm (AT) epost (DOT) de> wrote

Are you using Paradox the Application? Or just Paradox the Table Format?


--

Tony McGuire
"It's not about having enough time. It's about priorities."
___________________________

I am using a paradox table in a form view. It is an application.

Dan

"Tony McGuire" <png.paradoxcommunity@com> wrote

"an" application.

But is it Paradox?

Or, perhaps, Delphi?

Are you trying to delete the table with code? Through a feature in the
application? Windows Explorer?


--

Tony McGuire
"It's not about having enough time. It's about priorities."
___________________________

I am trying to delete in code Opal. ie- if fs.findfile() then fs.delete().
It doesn't delete in code, I try to delete from paradox file display for
priv folder also. If I select "Close All" even though there is nothing
showing in Paradox, I can delete the file. Something seems to be holding it
open and I can't figure out how to close it.

Thanks

Dan


"Tony McGuire" <png.paradoxcommunity@com> wrote

Try using a table variable to delete. See the table methods in
ObjectPAL help.

NOTE: You will need to close the form or remove the table from the
data model and close any table, UIObject or TCursor variables that
were attached to the table.

Liz


Dan wrote:

Evidently I was "Hiding" a form attached to the table and couldn't see it,
i.e. "hide". This was causing the problem. Thanks for the help.

I need to get a real job!

Thanks
Dan

"Liz McGuire" <liz (AT) paradoxcommunity (DOT) com> wrote