Subject RE: [firebird-support] Changing column type
Author Rick DeBay
Nope :-)

RDB$DEPENDENT_NAME RDB$DEPENDED_ON_NAME
RDB$FIELD_NAME RDB$DEPENDENT_TYPE RDB$DEPENDED_ON_TYPE
------------------------------------------------------------------------
---------------------------------------------------------------
V_INVOICED_CLAIMS INVOICE PHARMACY
1 0
V_INVOICED_CLAIMS CLAIMSPAIDREVERSED
SRVPROVID 1 0
V_INVOICED_CLAIMS INVOICE ACCOUNT
1 0
V_INVOICED_CLAIMS CLAIMSPAIDREVERSED
ACCOUNTID 1 0
V_INVOICED_CLAIMS INVOICE
INVOICE_NO 1 0
V_INVOICED_CLAIMS CLAIMSPAIDREVERSED INVOICE
1 0
V_INVOICED_CLAIMS INVOICE
1 0
V_INVOICED_CLAIMS CLAIMSPAIDREVERSED
1 0
V_AUDITCORRECTION CLAIMCORRECTION AUDITID
1 0
V_AUDITCORRECTION CLAIMAUDIT ID
1 0
V_AUDITCORRECTION CLAIMCORRECTION
1 0
V_AUDITCORRECTION CLAIMAUDIT
1 0
V_AUDITEDCLAIMS CHCPATIENTTYPES GROUP_ID
1 0
V_AUDITEDCLAIMS CLAIMSPAIDREVERSED GROUPID
1 0
V_AUDITEDCLAIMS CHCPATIENTTYPES CHCCODE
1 0
V_AUDITEDCLAIMS CLAIMSPAIDREVERSED
ACCOUNTID 1 0
V_AUDITEDCLAIMS CHCPATIENTTYPES
1 0
V_AUDITEDCLAIMS CLAIMAUDIT CLAIMSTS
1 0
V_AUDITEDCLAIMS CLAIMSPAIDREVERSED CLAIMSTS
1 0
V_AUDITEDCLAIMS CLAIMAUDIT
RXCLAIMSEQ 1 0
V_AUDITEDCLAIMS CLAIMSPAIDREVERSED
CLMSEQNBR 1 0
V_AUDITEDCLAIMS CLAIMAUDIT
RXCLAIMNBR 1 0
V_AUDITEDCLAIMS CLAIMSPAIDREVERSED
RXCLAIMNBR 1 0
V_AUDITEDCLAIMS CLAIMAUDIT
1 0
V_AUDITEDCLAIMS CLAIMSPAIDREVERSED
1 0
V_ADJUSTED_CLAIMS CHCPATIENTTYPES GROUP_ID
1 0
V_ADJUSTED_CLAIMS CLAIMSPAIDREVERSED GROUPID
1 0
V_ADJUSTED_CLAIMS CHCPATIENTTYPES CHCCODE
1 0
V_ADJUSTED_CLAIMS CLAIMSPAIDREVERSED
ACCOUNTID 1 0
V_ADJUSTED_CLAIMS CHCPATIENTTYPES
1 0
V_ADJUSTED_CLAIMS CLAIMAUDIT CLAIMSTS
1 0
V_ADJUSTED_CLAIMS CLAIMSPAIDREVERSED CLAIMSTS
1 0
V_ADJUSTED_CLAIMS CLAIMAUDIT
RXCLAIMSEQ 1 0
V_ADJUSTED_CLAIMS CLAIMSPAIDREVERSED
CLMSEQNBR 1 0
V_ADJUSTED_CLAIMS CLAIMAUDIT
RXCLAIMNBR 1 0
V_ADJUSTED_CLAIMS CLAIMSPAIDREVERSED
RXCLAIMNBR 1 0
V_ADJUSTED_CLAIMS CLAIMCORRECTION AUDITID
1 0
V_ADJUSTED_CLAIMS CLAIMAUDIT ID
1 0
V_ADJUSTED_CLAIMS CLAIMCORRECTION
1 0
V_ADJUSTED_CLAIMS CLAIMAUDIT
1 0
V_ADJUSTED_CLAIMS CLAIMSPAIDREVERSED
1 0
V_CLM_INV_RPT SOLOMON_COMPANY CHC_CODE
1 0
V_CLM_INV_RPT V_CLAIM_FEES
ACCOUNTID 1 0
V_CLM_INV_RPT SOLOMON_COMPANY
1 0
V_CLM_INV_RPT CLAIMSRAW CLAIMSTS
1 0
V_CLM_INV_RPT V_CLAIM_FEES CLAIMSTS
1 0
V_CLM_INV_RPT CLAIMSRAW
CLMSEQNBR 1 0
V_CLM_INV_RPT V_CLAIM_FEES
CLMSEQNBR 1 0
V_CLM_INV_RPT CLAIMSRAW
RXCLAIMNBR 1 0
V_CLM_INV_RPT V_CLAIM_FEES
RXCLAIMNBR 1 0
V_CLM_INV_RPT CLAIMSRAW
1 0
V_CLM_INV_RPT V_CLAIM_FEES
1 0
V_DRUGLIST DRUGQUANTITY NDC
1 0
V_DRUGLIST DRUGLIST NDC
1 0
V_CLAIM_FEES CLAIMSCALCFEES CLAIMSTS
1 0
V_CLAIM_FEES V_ADJUSTED_CLAIMS CLAIMSTS
1 0
V_CLAIM_FEES CLAIMSCALCFEES
RXCLAIMSEQ 1 0
V_CLAIM_FEES V_ADJUSTED_CLAIMS
CLMSEQNBR 1 0
V_CLAIM_FEES CLAIMSCALCFEES
RXCLAIMNBR 1 0
V_CLAIM_FEES V_ADJUSTED_CLAIMS
RXCLAIMNBR 1 0
V_CLAIM_FEES CLAIMSCALCFEES
1 0
V_CLAIM_FEES V_ADJUSTED_CLAIMS
1 0
V_DRUGLIST DRUGQUANTITY
1 0
V_FINALCLAIM CLAIMSPAIDREVERSED CLAIMSTS
1 0
V_FINALCLAIM CLAIMSPAIDREVERSED
CLMSEQNBR 1 0
V_FINALCLAIM CLAIMSPAIDREVERSED
RXCLAIMNBR 1 0
V_FINALCLAIM CLAIMSPAIDREVERSED
1 0
V_DRUGLIST DRUGLIST
1 0
V_DRUGLISTHISTORY DRUGLIST NDC
1 0
V_DRUGLISTHISTORY DRUGLISTHISTORY NDC
1 0
V_DRUGLISTHISTORY DRUGQUANTITY NDC
1 0
V_DRUGLISTHISTORY DRUGQUANTITY
1 0
V_DRUGLISTHISTORY DRUGLIST
1 0
V_DRUGLISTHISTORY DRUGLISTHISTORY
1 0
DRUGLIST_INS_UPDT DRUGLIST
LASTUPDATE 5 0
DRUGLIST_INS_UPDT DRUGLIST
APPLYMARKUP 5 0
DRUGLIST_INS_UPDT DRUGLIST
ACQPRICECHANGED 5 0
DRUGLIST_INS_UPDT DRUGLIST
PRICELIST 5 0
DRUGLIST_INS_UPDT DRUGLIST PRICEWAC
5 0
DRUGLIST_INS_UPDT DRUGLIST PRICEAWP
5 0
DRUGLIST_INS_UPDT DRUGLIST
PRICEACQUISITION 5 0
DRUGLIST_INS_UPDT DRUGLIST
PRICE340B 5 0
DRUGLIST_INS_UPDT DRUGLIST
ACTIVE_FLAG 5 0
DRUGLIST_INS_UPDT DRUGLIST LABEL
5 0
DRUGLIST_INS_UPDT DRUGLIST DRUG
5 0
DRUGLIST_INS_UPDT DRUGLIST
THERACODE 5 0
DRUGLIST_INS_UPDT DRUGLIST GPI
5 0
DRUGLIST_INS_UPDT DRUGLIST
BRANDGENERIC 5 0
V_GRANTEE ADDRESSES KEYID
1 0
V_GRANTEE GRANTEE KEYID
1 0
V_GRANTEE ADDRESSES
1 0
V_GRANTEE GRANTEE
1 0
V_HEALTHCENTER ADDRESSES KEYID
1 0
V_HEALTHCENTER HEALTHCENTER KEYID
1 0
V_HEALTHCENTER ADDRESSES
1 0
V_HEALTHCENTER HEALTHCENTER
1 0
V_PHARMACY ADDRESSES KEYID
1 0
V_PHARMACY PHARMACY KEYID
1 0
V_PHARMACY ADDRESSES
1 0
V_PHARMACY PHARMACY
1 0
TRGCPR_AUTOINC CLAIMSPAIDREVERSED
LINKTOCPR 2 0
TRGCPR_AUTOINC GIDCPR
2 14
TRGCLMADT_AUTOINC CLAIMAUDIT ID
2 0
TRGCLMADT_AUTOINC GIDCLMADT
2 14
INVOICE_ALL_CLAIMS CLAIMSPAIDREVERSED INVOICE
5 0
INVOICE_ALL_CLAIMS CLAIMSPAIDREVERSED
5 0
INVOICE_ALL_CLAIMS CLAIMSPAIDREVERSED DATESBM
5 0
INVOICE_ALL_CLAIMS CLAIMSPAIDREVERSED
SRVPROVID 5 0
INVOICE_ALL_CLAIMS CLAIMSPAIDREVERSED
ACCOUNTID 5 0
INVOICE_ALL_CLAIMS INVOICE PHARMACY
5 0
INVOICE_ALL_CLAIMS INVOICE ACCOUNT
5 0
INVOICE_ALL_CLAIMS INVOICE
INVOICE_NO 5 0
INVOICE_ALL_CLAIMS INVOICE
5 0
INVOICE_ALL_CLAIMS V_AUDITEDCLAIMS
SRVPROVID 5 0
INVOICE_ALL_CLAIMS V_AUDITEDCLAIMS
ACCOUNTID 5 0
INVOICE_ALL_CLAIMS V_AUDITEDCLAIMS
AUDITSTATUS 5 0
INVOICE_ALL_CLAIMS V_AUDITEDCLAIMS DATESBM
5 0
INVOICE_ALL_CLAIMS V_AUDITEDCLAIMS INVOICE
5 0
INVOICE_ALL_CLAIMS V_AUDITEDCLAIMS
5 0
INVOICE_CLAIMS CLAIMSPAIDREVERSED INVOICE
5 0
INVOICE_CLAIMS CLAIMSPAIDREVERSED
5 0
INVOICE_CLAIMS CLAIMSPAIDREVERSED DATESBM
5 0
INVOICE_CLAIMS CLAIMSPAIDREVERSED
SRVPROVID 5 0
INVOICE_CLAIMS CLAIMSPAIDREVERSED
ACCOUNTID 5 0
INVOICE_CLAIMS INVOICE PHARMACY
5 0
INVOICE_CLAIMS INVOICE ACCOUNT
5 0
INVOICE_CLAIMS INVOICE
INVOICE_NO 5 0
INVOICE_CLAIMS INVOICE
5 0
P_REVERSE_CORRECTION CLAIMCORRECTION GROUPID
5 0
P_REVERSE_CORRECTION CLAIMCORRECTION
ACCOUNTID 5 0
P_REVERSE_CORRECTION CLAIMCORRECTION
RSPDISPFEE 5 0
P_REVERSE_CORRECTION CLAIMCORRECTION
RSPPATPAY 5 0
DRUGLIST_INS_UPDT DRUGLIST
DISTRB_CTR 5 0
P_REVERSE_CORRECTION CLAIMCORRECTION
RSPDUEAMT 5 0
P_REVERSE_CORRECTION CLAIMCORRECTION
CALINGRCST 5 0
P_REVERSE_CORRECTION CLAIMCORRECTION
CTYPEUCOST 5 0
P_REVERSE_CORRECTION CLAIMCORRECTION AUDITID
5 0
P_REVERSE_CORRECTION CLAIMCORRECTION
5 0
P_REVERSE_CORRECTION CLAIMAUDIT CHANGED
5 0
P_REVERSE_CORRECTION CLAIMAUDIT
AUDITSTATUS 5 0
P_REVERSE_CORRECTION CLAIMAUDIT CLAIMSTS
5 0
P_REVERSE_CORRECTION CLAIMAUDIT
RXCLAIMSEQ 5 0
P_REVERSE_CORRECTION CLAIMAUDIT
RXCLAIMNBR 5 0
P_REVERSE_CORRECTION CLAIMAUDIT ID
5 0
P_REVERSE_CORRECTION CLAIMAUDIT
5 0
P_REVERSE_CORRECTION GIDCLMADT
5 14
P_REVERSE_CORRECTION RDB$DATABASE
5 0
P_REVERSE_CORRECTION V_AUDITCORRECTION GROUPID
5 0
P_REVERSE_CORRECTION V_AUDITCORRECTION
ACCOUNTID 5 0
P_REVERSE_CORRECTION V_AUDITCORRECTION
RSPDISPFEE 5 0
P_REVERSE_CORRECTION V_AUDITCORRECTION
RSPPATPAY 5 0
P_REVERSE_CORRECTION V_AUDITCORRECTION
RSPDUEAMT 5 0
P_REVERSE_CORRECTION V_AUDITCORRECTION
CALINGRCST 5 0
P_REVERSE_CORRECTION V_AUDITCORRECTION
CTYPEUCOST 5 0
P_REVERSE_CORRECTION V_AUDITCORRECTION CLAIMSTS
5 0
P_REVERSE_CORRECTION V_AUDITCORRECTION
CLMSEQNBR 5 0
P_REVERSE_CORRECTION V_AUDITCORRECTION
RXCLAIMNBR 5 0
DRUGLIST_INS_UPDT DRUGLIST
SUPPLIERCODE 5 0
DRUGLIST_INS_UPDT DRUGLIST NDC
5 0
DRUGLIST_INS_UPDT DRUGLIST
5 0
P_NETPAIDCLAIMS CLAIMSPAIDREVERSED CLAIMSTS
5 0
P_NETPAIDCLAIMS CLAIMSPAIDREVERSED
ACCOUNTID 5 0
P_NETPAIDCLAIMS CLAIMSPAIDREVERSED DATESBM
5 0
P_NETPAIDCLAIMS CLAIMSPAIDREVERSED
5 0
CHECK_73 CLAIMSPAIDREVERSED CLAIMSTS
2 0
CHECK_74 CLAIMSPAIDREVERSED CLAIMSTS
2 0
P_REVERSE_CORRECTION V_AUDITCORRECTION
5 0
CLAIMSPAIDREVERSED_AUDIT CLAIMAUDIT
AUDITSTATUS 2 0
CLAIMSPAIDREVERSED_AUDIT CLAIMSPAIDREVERSED
CLMSEQNBR 2 0
CLAIMSPAIDREVERSED_AUDIT CLAIMAUDIT
RXCLAIMSEQ 2 0
CLAIMSPAIDREVERSED_AUDIT CLAIMSPAIDREVERSED
RXCLAIMNBR 2 0
CLAIMSPAIDREVERSED_AUDIT CLAIMAUDIT
RXCLAIMNBR 2 0
CLAIMSPAIDREVERSED_AUDIT CLAIMAUDIT
2 0
CLAIMSPAIDREVERSED_AUDIT CLAIMSPAIDREVERSED CLAIMSTS
2 0
CLAIMSPAIDREVERSED_CORRECTION P_REVERSE_CORRECTION
2 5
CLAIMSPAIDREVERSED_CORRECTION CLAIMSPAIDREVERSED
CLMSEQNBR 2 0
CLAIMSPAIDREVERSED_CORRECTION CLAIMSPAIDREVERSED
RXCLAIMNBR 2 0
CLAIMSPAIDREVERSED_CORRECTION CLAIMSPAIDREVERSED CLAIMSTS
2 0
DRUGLIST_LASTUPDATE DRUGLIST
LASTUPDATE 2 0
DRUGLIST_DATECHECK DRUGLIST
LASTUPDATE 2 0
DRUGLIST_DATECHECK DRUGLIST
PRICELIST 2 0
DRUGLIST_DATECHECK DRUGLIST PRICEWAC
2 0
DRUGLIST_DATECHECK DRUGLIST PRICEAWP
2 0
DRUGLIST_DATECHECK DRUGLIST
PRICE340B 2 0
DRUGLIST_DATECHECK DRUGLIST
ACQPRICECHANGED 2 0
DRUGLIST_DATECHECK DRUGLIST
APPLYMARKUP 2 0
DRUGLIST_DATECHECK DRUGLIST
PRICEACQUISITION 2 0
DRUGLIST_DATECHECK DRUGLIST
ACTIVE_FLAG 2 0
DRUGLIST_DATECHECK DRUGLISTHISTORY
APPLYMARKUP 2 0
DRUGLIST_DATECHECK DRUGLISTHISTORY
ACQPRICECHANGED 2 0
DRUGLIST_DATECHECK DRUGLISTHISTORY
PRICEACQUISITION 2 0
DRUGLIST_DATECHECK DRUGLISTHISTORY
ACTIVE_FLAG 2 0
DRUGLIST_DATECHECK DRUGLISTHISTORY
DISTRB_CTR 2 0
DRUGLIST_DATECHECK DRUGLIST
DISTRB_CTR 2 0
DRUGLIST_DATECHECK DRUGLISTHISTORY
SUPPLIERCODE 2 0
DRUGLIST_DATECHECK DRUGLIST
SUPPLIERCODE 2 0
DRUGLIST_DATECHECK DRUGLISTHISTORY NDC
2 0
DRUGLIST_DATECHECK DRUGLIST NDC
2 0
DRUGLIST_DATECHECK DRUGLISTHISTORY
2 0
DRUGLIST_DATECHECK DRUGLIST
2 0
DRUGLIST_HISTORY DRUGLISTHISTORY
APPLYMARKUP 2 0
DRUGLIST_HISTORY DRUGLIST
APPLYMARKUP 2 0
DRUGLIST_HISTORY DRUGLISTHISTORY
ACQPRICECHANGED 2 0
DRUGLIST_HISTORY DRUGLIST
ACQPRICECHANGED 2 0
DRUGLIST_HISTORY DRUGLISTHISTORY
PRICELIST 2 0
DRUGLIST_HISTORY DRUGLIST
PRICELIST 2 0
DRUGLIST_HISTORY DRUGLISTHISTORY PRICEWAC
2 0
DRUGLIST_HISTORY DRUGLIST PRICEWAC
2 0
DRUGLIST_HISTORY DRUGLISTHISTORY PRICEAWP
2 0
DRUGLIST_HISTORY DRUGLIST PRICEAWP
2 0
DRUGLIST_HISTORY DRUGLISTHISTORY
PRICE340B 2 0
DRUGLIST_HISTORY DRUGLIST
PRICE340B 2 0
DRUGLIST_HISTORY DRUGLISTHISTORY
PRICEACQUISITION 2 0
DRUGLIST_HISTORY DRUGLIST
PRICEACQUISITION 2 0
DRUGLIST_HISTORY DRUGLISTHISTORY
ACTIVE_FLAG 2 0
DRUGLIST_HISTORY DRUGLIST
ACTIVE_FLAG 2 0
DRUGLIST_HISTORY DRUGLISTHISTORY
DISTRB_CTR 2 0
DRUGLIST_HISTORY DRUGLIST
DISTRB_CTR 2 0
DRUGLIST_HISTORY DRUGLISTHISTORY
SUPPLIERCODE 2 0
DRUGLIST_HISTORY DRUGLIST
SUPPLIERCODE 2 0
DRUGLIST_HISTORY DRUGLISTHISTORY NDC
2 0
DRUGLIST_HISTORY DRUGLIST NDC
2 0
DRUGLIST_HISTORY DRUGLISTHISTORY
2 0
CLAIMFEES_HISTORY CLAIMFEESHISTORY
EFFECTIVE 2 0
CLAIMFEES_HISTORY CLAIMSCALCFEES
EFFECTIVE 2 0
CLAIMFEES_HISTORY CLAIMFEESHISTORY
CHCAMOUNT 2 0
CLAIMFEES_HISTORY CLAIMSCALCFEES
CHCAMOUNT 2 0
CLAIMFEES_HISTORY CLAIMFEESHISTORY
PHARMACYCOLLECTED 2 0
CLAIMFEES_HISTORY CLAIMSCALCFEES
PHARMACYCOLLECTED 2 0
CLAIMFEES_HISTORY CLAIMFEESHISTORY RXSFEE
2 0
CLAIMFEES_HISTORY CLAIMSCALCFEES RXSFEE
2 0
CLAIMFEES_HISTORY CLAIMFEESHISTORY
DISPENSEFEE 2 0
CLAIMFEES_HISTORY CLAIMSCALCFEES
DISPENSEFEE 2 0
CLAIMFEES_HISTORY CLAIMFEESHISTORY CLAIMSTS
2 0
CLAIMFEES_HISTORY CLAIMSCALCFEES CLAIMSTS
2 0
CLAIMFEES_HISTORY CLAIMFEESHISTORY
RXCLAIMSEQ 2 0
CLAIMFEES_HISTORY CLAIMSCALCFEES
RXCLAIMSEQ 2 0
CLAIMFEES_HISTORY CLAIMFEESHISTORY
RXCLAIMNBR 2 0
CLAIMFEES_HISTORY CLAIMSCALCFEES
RXCLAIMNBR 2 0
CLAIMFEES_HISTORY CLAIMFEESHISTORY
2 0
CLAIMFEES_TS CLAIMSCALCFEES
EFFECTIVE 2 0
RXSDRUGPRICING_HISTORY RXSDRUGPRICINGHISTORY
EFFECTIVE_DATE 2 0
RXSDRUGPRICING_HISTORY RXSDRUGPRICING
EFFECTIVE_DATE 2 0
RXSDRUGPRICING_HISTORY RXSDRUGPRICINGHISTORY
PHARMACYCODE 2 0
RXSDRUGPRICING_HISTORY RXSDRUGPRICING
PHARMACYCODE 2 0
RXSDRUGPRICING_HISTORY RXSDRUGPRICINGHISTORY FEESPLIT
2 0
RXSDRUGPRICING_HISTORY RXSDRUGPRICING FEESPLIT
2 0
RXSDRUGPRICING_HISTORY RXSDRUGPRICINGHISTORY
DRUGCOSTCODE 2 0
RXSDRUGPRICING_HISTORY RXSDRUGPRICING
DRUGCOSTCODE 2 0
RXSDRUGPRICING_HISTORY RXSDRUGPRICINGHISTORY SLIDEAMT
2 0
RXSDRUGPRICING_HISTORY RXSDRUGPRICING SLIDEAMT
2 0
RXSDRUGPRICING_HISTORY RXSDRUGPRICINGHISTORY DISPFEE
2 0
RXSDRUGPRICING_HISTORY RXSDRUGPRICING DISPFEE
2 0
RXSDRUGPRICING_HISTORY RXSDRUGPRICINGHISTORY RXSFEE
2 0
RXSDRUGPRICING_HISTORY RXSDRUGPRICING RXSFEE
2 0
RXSDRUGPRICING_HISTORY RXSDRUGPRICINGHISTORY
BRANDGENERIC 2 0
RXSDRUGPRICING_HISTORY RXSDRUGPRICING
BRANDGENERIC 2 0
RXSDRUGPRICING_HISTORY RXSDRUGPRICINGHISTORY PATTYPE
2 0
RXSDRUGPRICING_HISTORY RXSDRUGPRICING PATTYPE
2 0
RXSDRUGPRICING_HISTORY RXSDRUGPRICINGHISTORY CHCCODE
2 0
RXSDRUGPRICING_HISTORY RXSDRUGPRICING CHCCODE
2 0
RXSDRUGPRICING_HISTORY RXSDRUGPRICINGHISTORY
2 0
CHECK_49 MDDB_AAWP GPPC
2 0
CHECK_49 MDDB_GPPC GPPC
2 0
CHECK_49 MDDB_AAWP
2 0
CHECK_50 MDDB_GPPC GPPC
2 0
CHECK_50 MDDB_AAWP GPPC
2 0
CHECK_50 MDDB_AAWP
2 0
CHECK_51 MDDB_GEAP GPPC
2 0
CHECK_51 MDDB_GPPC GPPC
2 0
CHECK_51 MDDB_GEAP
2 0
CHECK_52 MDDB_GPPC GPPC
2 0
CHECK_52 MDDB_GEAP GPPC
2 0
CHECK_52 MDDB_GEAP
2 0
CHECK_53 MDDB_HCFA_FFP_LIMIT NDC
2 0
CHECK_53 MDDB_DRUGITEM NDC
2 0
CHECK_53 MDDB_HCFA_FFP_LIMIT
2 0
CHECK_54 MDDB_DRUGITEM NDC
2 0
CHECK_54 MDDB_HCFA_FFP_LIMIT NDC
2 0
CHECK_54 MDDB_HCFA_FFP_LIMIT
2 0
CHECK_55 MDDB_DIRECTPRICE NDC
2 0
CHECK_55 MDDB_DRUGITEM NDC
2 0
CHECK_55 MDDB_DIRECTPRICE
2 0
CHECK_56 MDDB_DRUGITEM NDC
2 0
CHECK_56 MDDB_DIRECTPRICE NDC
2 0
CHECK_56 MDDB_DIRECTPRICE
2 0
CHECK_57 MDDB_WAC NDC
2 0
CHECK_57 MDDB_DRUGITEM NDC
2 0
CHECK_57 MDDB_WAC
2 0
CHECK_58 MDDB_DRUGITEM NDC
2 0
CHECK_58 MDDB_WAC NDC
2 0
CHECK_58 MDDB_WAC
2 0
CHECK_59 MDDB_AWP NDC
2 0
CHECK_59 MDDB_DRUGITEM NDC
2 0
CHECK_59 MDDB_AWP
2 0
CHECK_60 MDDB_DRUGITEM NDC
2 0
CHECK_60 MDDB_AWP NDC
2 0
CHECK_60 MDDB_AWP
2 0
CHECK_61 MDDB_DRUG_INGR NDC
2 0
CHECK_61 MDDB_DRUGITEM NDC
2 0
CHECK_61 MDDB_DRUG_INGR
2 0
CHECK_62 MDDB_DRUGITEM NDC
2 0
CHECK_62 MDDB_DRUG_INGR NDC
2 0
CHECK_62 MDDB_DRUG_INGR
2 0
CHECK_63 MDDB_DRUG_INGR INGR
2 0
CHECK_63 MDDB_INGR
CAS_GENERICID 2 0
CHECK_63 MDDB_DRUG_INGR
2 0
CHECK_64 MDDB_INGR
CAS_GENERICID 2 0
CHECK_64 MDDB_DRUG_INGR INGR
2 0
CHECK_64 MDDB_DRUG_INGR
2 0
CHECK_67 CLAIMSPAIDREVERSED CLAIMSTS
2 0
CHECK_67 CLAIMAUDIT CLAIMSTS
2 0
CHECK_67 CLAIMSPAIDREVERSED
CLMSEQNBR 2 0
CHECK_67 CLAIMAUDIT
RXCLAIMSEQ 2 0
CHECK_67 CLAIMSPAIDREVERSED
RXCLAIMNBR 2 0
CHECK_67 CLAIMAUDIT
RXCLAIMNBR 2 0
CHECK_67 CLAIMAUDIT
2 0
CHECK_68 CLAIMSPAIDREVERSED CLAIMSTS
2 0
CHECK_68 CLAIMSCALCFEES CLAIMSTS
2 0
CHECK_68 CLAIMSPAIDREVERSED
CLMSEQNBR 2 0
CHECK_68 CLAIMSCALCFEES
RXCLAIMSEQ 2 0
CHECK_68 CLAIMSPAIDREVERSED
RXCLAIMNBR 2 0
CHECK_68 CLAIMSCALCFEES
RXCLAIMNBR 2 0
CHECK_68 CLAIMSCALCFEES
2 0

-----Original Message-----
From: Daniel Rail [mailto:daniel@...]
Sent: Wednesday, October 13, 2004 5:47 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Changing column type


Hi,

At October 13, 2004, 18:18, Rick DeBay wrote:


> I just checked the dependencies table, and the PRODUCTID field is not
in
> the table, so this won't work.

It has to be there. Try looking for the view name in the field
RDB$DEPENDANT_NAME, and then you should see the field name PRODUCTID,
under RDB$FIELD_NAME.

> However, trying to delete the field from
> the table yields:

> Column PRODUCTID from table CLAIMSPAIDREVERSED is referenced in view
> V_INVOICED_CLAIMS.

> Would I modify RDB$RELATION_FIELDS?



--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)





Yahoo! Groups Links