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.

 

Reply via email to