Thanks, Larry. I'll use this technique the next time.
>Nadya,
>You don't need a public variable. Create a report variable. Just before the select, add the following line:
>lTownUsed = used('Town')
>
>In the Destroy, check the variable and if it is .T., don't close the table.
>
>Report variables are private and created before any code in the report is executed.
>
>HTH.
>
>>Hi everyone,
>>
>>These news got me absolutely shocked, I can not concentrate on finding a solution here, so I'm asking for help.
>>
>>I added this code into DE.BeforeOpenTables of report:
>>
>>set talk on
>>select db.county, db.towncode, db.FY, Towns.FullName as city, count(*) as GrpCnt ;
>> from dbf() db, Lookups!Towns ;
>> where db.county=Towns.CABBREV and db.TownCode=Towns.TownOld ;
>> group by 1, 2 ;
>> order by 1, 4 ;
>> into cursor curPrntReport
>>select curPrntReport
>>set talk off
>>
>>And I added this code into DE.Destroy:
>>
>>use in select('curPrntReport')
>>
>>Report uses default DS. I want to close Towns table, if it was not opened before. I don't want to use public variables (though it seems to be necessary here). Do you have other suggestions?
>>
>>Thanks in advance.
If it's not broken, fix it until it is.
My Blog