Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unprintable Characters
Message
From
08/11/2002 06:16:00
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
08/11/2002 02:57:13
Napoleon Yam
Princess Cruises: Emerald Princess
Caribbean, Philippines
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00720157
Message ID:
00720190
Views:
12
>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)
Previous
Reply
Map
View

Click here to load this message in the networking platform