>Mark,
>
>I have no idea what the real problem is <g>, but if you want to play around, you could put it into JOIN form. It shouldn't make any difference, of course. Strange.
>
>Hank
>
>>VFP 3.0b, Win 95. I have the following code:
>>
>>dFyr='1998'
>>SELECT Accounts.account, Accounts.allotment, ;
>> sum(Transact.amount) as "AMOUNT", ;
>> sum(Transact.regfee) as "REGFEE", ;
>> Transact.vouchered, Transact.actid, Transact.fyr ;
>> FROM travel!transact, travel!accounts ;
>> WHERE Accounts.actid = Transact.actid ;
>> AND Accounts.fyr = Transact.fyr ;
>> AND (Accounts.fyr = ?dFyr) ;
>> GROUP BY Accounts.account, Transact.vouchered ;
>> ORDER BY Accounts.account, Transact.vouchered
>>
>>Fields (datatype):
>>
>>Account (C), Allotment (N), Amount(N), RegFee (N), Vouchered (L),
>>ActID (N), FYr (C)
>>
>>As given above the sql returns the correct information. But when I put "Create Sql View ViewName As" at the beginning of the statement, it returns no rows. ?????
>>
>>Any ideas?
>>
>>TIA!
Ok. I've duplicated the fields and have run both the select and then the query with exactly the saPOST /cgi-bin/vfpwebn.exe HTTP/1.0
Referer:
http://www.levelextreme.com/cgi-bin/vfpwebn.exe?2,16,62054Connection: Keep-Alive
User-Agent: Mozilla/3.0C-NC320 (Win16; U)
Host:
www.levelextreme.comAccept: image/gif, image/x-xbitmap, image/jpeg, iing? Is this part of a form? etc..