Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Report in running time
Message
De
07/03/2003 09:31:22
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
07/03/2003 06:50:36
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00762612
Message ID:
00762687
Vues:
13
>Thanks Hilmar
>
>I see your class , and i like .
>
>Do you have the file about.htm in spanhish ?

No, sorry, only in English. Right now, I don't have the time to translate it. If anyone wishes to translate it into other languages, and make it available, I will be happy to include it in my download.

Please ask back if anything isn't clear in the text.

>And , can you give me a example , how can i and where , i define my selects in running time ?

The class has a method .Select(). You should place any select statements into this method. Actually, it doesn't need to be SELECT statements: it could be any commands to prepare data for the report, like opening a table and setting a filter, or preparing a cursor in a loop. However, you should watch the value of the _tally variable - the class assumes that if _tally = 0, there is no data to be printed.

>I think that , i can´t change property select from your class at running time .
>
>Thanks .
>
>I write after in portuguese , because i know you understand .

Yes, I understand Portuguese. But under these circumstances, Michel asks us to start a new thread. You can write a message directed to me.

Therefore, I will continue writing in English.

>Ainda não entendi onde posso colocar os meus selects em tempo de execução .
>
>Os meus selects , são feitos dinamicamente . Tenho um form , onde o utilizador escolhe os campos , os operadores ( = , < , > , LIKE ) e o valor da comparação , depois eu monto o select .
>
>Onde posso colocar esses selects , para que eles funcionem com a tua classe ?
>Nunca esquecendo que estes selects são feitos em tempo de execução .
>
>Será que posso , fazer
>
>
>PUBLIC PCMySelect = "Select * .... INTO CURSOR ... "
>
>&& and write in your class
>
>&PCMySelect  ?
>
>
Yes, you can sure do this. The logical place to do this, as mentioned above, is in method .Select(). This method is invoked before the main loop runs (once for each record in the selected work area).

I repeat: In the .Select() method, you can place ANY command to prepare your data. Just make sure that a) _tally > 0 after finishing (this is automatically the case if you use SELECT - SQL statements), and b) the cursor or table you prepare is selected (this would also be automatic if you finish with one ore more SELECT - SQL statements).
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform