>>Can you post the SQL that defines the view?
>
>Here it is!
>
>SELECT TranDtl.*, PrcMst.Code AS "PrcMstCode", PrcMst.Descr AS "PrcMstDescr", ;
> DfnMst.Code AS "InsMstType", InsMst.Name AS "InsMstName", ;
> COUNT(Adjustment.pID) AS "Adjustments", ;
> NVL(SUM(Adjustment.Amount),0.00) AS "Credits", ;
> NVL(SUM(IIF(INLIST(Adjustment.AdjustType,1,3),Adjustment.Amount,0.00)),0.00) AS "InsCredits", ;
> NVL(SUM(IIF(INLIST(Adjustment.AdjustType,2,4),Adjustment.Amount,0.00)),0.00) AS "PatCredits", ;
> NVL(TranDtl.InsMstID = TranDtl1.InsMstID,.F.) AS "ReBill", ;
> NVL(TranDtl.InsMstID # TranDtl1.InsMstID,.F.) AS "BillOther", ;
> TTOD(TranDtl.ServFrDttm) AS "DSort" ;
> FROM VCPRO!TranDtl ;
> LEFT OUTER JOIN VCPRO!Adjustment ON TranDtl.pID = Adjustment.TranDtlID ;
> LEFT OUTER JOIN VCPRO!TranDtl TranDtl1 ON TranDtl.pID = TranDtl1.RefPID ;
> INNER JOIN VCPRO!PrcMst ON TranDtl.PrcMstID = PrcMst.pID ;
> INNER JOIN VCPRO!InsMst ON TranDtl.InsMstID = InsMst.pID ;
> INNER JOIN VCPRO!DfnMst ON InsMst.TypeMstID = DfnMst.pID ;
> WHERE TranDTl.PatientID = ?vpPatientID ;
> GROUP BY TranDtl.pID ;
> ORDER BY DSort DESC, TranDtl.pID DESC
The IIF() in your view definition is causing the structure of the resulting cursor to vary with the results. VFP decides on the structure of a view cursor based on the results of the query that defines it. If during one REQUERY(), the results cause a different field width then on the previous REQUERY(), you'll get the error that you got.
Erik Moore
Clientelligence