Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Executing code in Report.DE BeforeOpenTables
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00555192
Message ID:
00555208
Vues:
18
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform