INDBC() can tell me if a table is part of this database.
FREE TABLE can disconnect the table from a database.
How can I tell if this table has a link to a DB that I need to remove?
Issuing FREE TABLE blindly will generate an error if no DB link exists.
There must be something obvious I'm
PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: 24 January 2007 18:00
To: [EMAIL PROTECTED]
Subject: InDbc and Free Table
INDBC() can tell me if a table is part of this database.
FREE TABLE can disconnect the table from a database.
How can I tell if this table has a link to a DB that I need
[EMAIL PROTECTED] wrote:
INDBC() can tell me if a table is part of this database.
FREE TABLE can disconnect the table from a database.
How can I tell if this table has a link to a DB that I need to remove?
Issuing FREE TABLE blindly will generate an error if no DB link exists.
There must
On 1/24/07, henry.dagher wrote:
INDBC() can tell me if a table is part of this database.
FREE TABLE can disconnect the table from a database.
How can I tell if this table has a link to a DB that I need to remove?
Issuing FREE TABLE blindly will generate an error if no DB link exists.
On 1/24/07, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
There must be something obvious I'm missing.
Me, too. I'm not grasping exactly what it is you are trying to
accomplish or what the problem is. Perhaps ADBObjects() is the answer,
though.
--
Ted Roche
Ted Roche Associates, LLC
This might be the long way
local nCount, lDatabases
nCount = ADatabases(lDatabases)
use table
if nCount ADatabases(lDatabases)
?table is part of a database.
endif
Tracy
-Original Message-
INDBC() can tell me if a table is part of this database.
FREE TABLE can
Having a second glance at the code, this would only work if the database of
the table in question was not already open.
Tracy
-Original Message-
This might be the long way
local nCount, lDatabases
nCount = ADatabases(lDatabases)
use table
if nCount
(from a more recent version of the software.
In this case, setup, will not overwrite it)
So, I need to FREE Zardoz if it needs to be freed and then add it to the DBC.
**
If Not Indbc([Zardoz],[Table])
Try
Free Table (goapp.cPathNet + [Data
Sent: 2007-01-24 1:28 PM
To: [EMAIL PROTECTED]
Subject: RE: InDbc and Free Table
Having a second glance at the code, this would only work if the database of
the table in question was not already open.
Tracy
-Original Message-
This might be the long way
local nCount, lDatabases
What do you think of the Try/Catch in my other message? The test went ok.
There are ways around using a Try/Catch, but I don't see a problem using
them.
* before copy of Zardoz
If Indbc([Zardoz], [Table])
Free Table (goApp.cPathNet + [Data\Zardoz])
EndIf
* Copy Free Zardoz table
But isn't the FINALLY the proper place to evaluate loFreeTable?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tracy Pearson
Sent: 2007-01-24 1:55 PM
To: [EMAIL PROTECTED]
Subject: RE: InDbc and Free Table
What do you think of the Try/Catch in my
I understood the Finally as code you want to process even if the catch is
never called, like cleanup code.
Tracy
-Original Message-
But isn't the FINALLY the proper place to evaluate loFreeTable?
___
Post Messages to: ProFox@leafe.com
12 matches
Mail list logo
