Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Unprintable Characters
Message
De
08/11/2002 06:16:00
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
08/11/2002 02:57:13
Napoleon Yam
Princess Cruises: Emerald Princess
Caribbean, Philippines
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00720157
Message ID:
00720190
Vues:
13
>Greetings to all,
>
>we have a table with at least 2500 records, these records are sorted by sections and classes, when we print a class list we want to see the late enrollees at the bottom of the record, so what we have tried is to put in a space before the content of the record, the problem is that it goes at the top of the record.

"At the top of the record" - I assume you mean at the top of the list.

>1. We would like to hear some ideas from you guys
>2. Is it posibble to store an unprintable character in a table?

In your SELECT - SQL statement, just add an expression that relates to the date.

For instance:
select * from Inscriptions;
  order by iif(date >= {^2002-05-01}, 0, 1), Section, Class;
  into cursor Temp
report form Inscriptions
You should make sure the report doesn't have tables in its dataenvironment, if you want to run it against the cursor.

In general, I would not create an index just because I want a certain order on a report - this can easily be done in the SELECT - SQL statement.

If you are not familiar with SELECT - SQL statements, for a quick start, you can use the query builder (CREATE QUERY), and copy the generated SQL statement to your program code.

HTH, Hilmar.
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