Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Run code in report form
Message
De
12/01/2009 11:27:52
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
12/01/2009 11:23:36
Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
01372806
Message ID:
01372828
Vues:
17
>>>I want to be able to run a block of code in the report form when it first starts. How can I do that? The reason is that for this particular report, I want to run SQL against the current alias and create a generic cursor (Fld001, Fld001, etc.). This cannot be done in code priort to the REPORT FORM statement in the calling code.
>>
>>Why "This cannot be done in code priort to the REPORT FORM statement in the calling code."? Report have some private datasession? If so you can run the code in report DE.OpenTables.
>
>Doesn't matter why, but it cannot be done.
>
>>Or an easy alternative would be a call to a user defined function from within report. ie: add a field in report title with a call to UDF().
>
>Hmmmm.... So my report title could be:
>
>"My Report Title" + MySQLFunction()
>
>And as long as the function only creates a cursor and doesn't return an actual value, it will work?

Yes. May return an actual value.

Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform