Cetin,
I guess it cannot be done!

Peter

>>how can I make the following view work in vfp8 without setting engonbehavior to 70?
>>

>>create sql view vInvoice as ;
>>Select ;
>>	A.invoice_ID,  ;
>>	INT(A.billing_ID) AS billing_ID,  ;
>>	INT(A.site_ID) AS site_ID,  ;
>>	PADR(A.invoicenum,10) as invoicenum,;
>>	PADR(A.billrefno,20)  as billrefno ;
>>	A.isedi,  ;
>>	A.invdate,  ;
>>	A.datezero,;
>>	A.arnotes,  ;
>>	A.autopay,  ;
>>	A.invtype,;
>>	A.sbill_ID,  ;
>>	A.issbill,  ;
>>	A.insuser_ID,;
>>	A.upduser_ID, ;
>>	A.insdttm, ;
>>	A.upddttm,;
>>	A.busgrp_ID,;
>>		B.arcode,;
>>		B.grpcode,;
>>		B.inco, ;
>>		B.name1,;
>>		B.name2, ;
>>		B.addr1,;
>>		B.addr2, ;
>>		B.city, ;
>>		B.state,;
>>		B.zip,;
>>		B.country,;
>>		B.isedi210,;
>>		B.isinvprint,;
>>			0000000.00 + Sum(Iif(C.xntype = 'CHARGE' And C.p3_ID = A.billing_ID,;
>>			ROUND(C.rate*C.qty+C.addamt,2),0000000.00)) As OrigAmt,;
>>			0000000.00 + Sum(Iif(C.xntype = 'CHARGE',Round(C.rate*C.qty+C.addamt,2),  -1*Round(C.rate*C.qty+C.addamt,2))) As Balance ;
>>	FROM Invoice A  ;
>>		JOIN Sites B On A.site_ID = B.site_ID   ;
>>	JOIN FinXn C On A.invoice_ID = C.p2_ID  And C.isgl  And C.datepost <= Date()  And (C.xntype = 'CHARGE'   Or C.xntype = 'RECEIPT'   Or C.xntype = 'ADJUST')   ;
>>		GROUP By 1
>>

>>
>>Thanks
>>
>>
>>Peter
>
>Peter,
>Remove all fields except group by and aggregate fields (a.invoice_id, OrigAmt, Balance)
>PS: Do you need it as a 'view'.
>Cetin