[RBG7-L] - Re: [No Subject]

[Bill Downall]

Steve,
the syntax of SHOW VAR "expects" a variable after the word var. You 
don't need to "dot" it. In fact, when you "dot" it, R:Base thinks you 
want the variable NAMED whatever the current value in the variable is.

You typed:
        SHOW VAR .vconstraintname
If you:
        SHOW VAR vconstraintname
You will see '#60' is the name of the constraint.
Then all you have to do is:
        ALTER TABLE Charges DROP CONSTRAINT #60
(or, in a program:)
        ALTER TABLE Charges DROP CONSTRAINT .vConstraintname
Bill
Steve Breen wrote:

Bill,
I finally worked it down to this.
What do you think.
R>sel sys_index_name into vConstraintName from sys_indexes where 
sys_table_id +
 = (sel sys_table_id from sys_tables where sys_table_name = 'Charges') and +
sys_column_name = 'chargetype' and sys_foreign_key <> 0
R>show var .vconstraintname
-ERROR- Variable #60 is not defined. (  20)

 

Stephen Breen
CDI Services, Inc.
<http://www.911roadrepair.com>