Ok, so did you finally fix it now?
I suggest to use GoFish and Thor set of tools. I don't use Code Reference anymore.
>>>So, it is very weird ......
>>>
>>Indeed. I think it is probably using a different form (from a wrong path). Try activating debugout window before building the project to see which path it is used. Also see, if the path is in the error message itself.
>
>I allowed the Compile to occur with the Debug Out Window open. When finished, I looked through the output and found that it had an error once again....
>
>" Module: pricingpage.activate
>INSERT INTO csrHistory (Current,Rx_no, Refill_no, DateFilled, NDC, Name, QtyFilled, Price, Discount, Cash, ThirdParty, AWP, QtyAWP, Acq, QtyAcq, FMAC, QtyFMAC,PriceCode,InsName,Margin) VALUES (.T.,0, 0, {00/00/0000}, drug.ndc, ALLTRIM(drug.name),This.Parent.DrugPage.pgfDrug.TradePage.txtQtyFilled.value, This.txtGrossBilled.value, This.txtDiscount.value, This.txtNetBilled.value , 0.00 , drug.awp, This.txtQtyAWP.value, drug.acquisition_cost, This.txtQtyAcq.value, drug.fmac, This.txtQtyFMAC.value, Thisform.p_PriceCode,lcInsuranceName,lnMargin )
>
>Error in line 270
> of frmrx.pgfScreen.RapidPage.pgfData.PricingPage.Activate (record 4)
>Date/datetime evaluated to an invalid value."
>
>Also, when I opened the Forms_Rx and look at Record 4, then the Methods field (memo).... and search for 00/00/000 I find....
>
>"INSERT INTO csrHistory (Current,Rx_no, Refill_no, DateFilled, NDC, Name, QtyFilled, Price, Discount, Cash, ;
> ThirdParty, AWP, QtyAWP, Acq, QtyAcq, FMAC, QtyFMAC,PriceCode,InsName,Margin);
> VALUES (.T.,0, 0, {00/00/0000}, drug.ndc, ALLTRIM(drug.name),This.Parent.DrugPage.pgfDrug.TradePage.txtQtyFilled.value, ;
> This.txtGrossBilled.value, This.txtDiscount.value, This.txtNetBilled.value , 0.00 , drug.awp, ;
> This.txtQtyAWP.value, drug.acquisition_cost, This.txtQtyAcq.value, drug.fmac, This.txtQtyFMAC.value, ;
> Thisform.p_PriceCode,lcInsuranceName,lnMargin )"
>
>So, the code is in there.... don't know why it does not link up properly in the Code References tool....
>
>>
>>And also, try compiling just this form alone
>>
>>compile form myForm
>
>I compiled the Class Library froms_rx.vcx. Compiled with 1 error.
>
>Same error...
>" Module: pricingpage.activate
>INSERT INTO csrHistory (Current,Rx_no, Refill_no, DateFilled, NDC, Name, QtyFilled, Price, Discount, Cash, ThirdParty, AWP, QtyAWP, Acq, QtyAcq, FMAC, QtyFMAC,PriceCode,InsName,Margin) VALUES (.T.,0, 0, {00/00/0000}, drug.ndc, ALLTRIM(drug.name),This.Parent.DrugPage.pgfDrug.TradePage.txtQtyFilled.value, This.txtGrossBilled.value, This.txtDiscount.value, This.txtNetBilled.value , 0.00 , drug.awp, This.txtQtyAWP.value, drug.acquisition_cost, This.txtQtyAcq.value, drug.fmac, This.txtQtyFMAC.value, Thisform.p_PriceCode,lcInsuranceName,lnMargin )
>
>Error in line 270
> of frmrx.pgfScreen.RapidPage.pgfData.PricingPage.Activate (record 4)
>Date/datetime evaluated to an invalid value."
If it's not broken, fix it until it is.
My Blog