>>>I am using a Select Statement for a report, Sometime there is no data to select so I have an empty cursor. I would still like the report to print even though their isn't any data in the cursor, all I get now is a blank page, I would like to have all my footers layout print. Is this possible, or do I just not get it (don't respond to that) :)
>>>Thanks
>>>Jon
>>
>>Hi, Jon
>>
>>Select ... Into Cursor curRpt Nofilter
>>Use (dbf()) in 0 again alias curNewrpt
>>Select curNewrpt
>>If _TALLY=0
>> Insert Into curNewrpt Values()
>>Endif
>>Report Form ....
>>
>
>Thanks Ed,
>I'll give this a whirl, I don't know how you do it:) I've never use the dbf() function before, everytime I have a question you force me to learn more... I suppose thats the purpose, huh?
It's UT purpose:). USE (DBF()) is using here to change read-only cursor to read-write cursor.
Edward Pikman
Independent Consultant