Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I get the last 1000 records in a table
Message
From
26/09/2005 09:13:07
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 7 SP1
OS:
Windows XP SP2
Network:
Novell 6.x
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01052591
Message ID:
01053002
Views:
10
>>>
select TOP 1000 unemp_ins_pct from payroll_tbl ;
>>>	where unemp_ins_pct # 0 ;
>>>	into array a__gen40 ;
>>>	order by payroll_tbl.id DESC
>>
>>I propose an additional action to undo the effect of DESC:
index on payroll_tbl.id tag primary
>
>
>Peter,
>
>I don't think it would have any effect on the result.

Not on the result, but on the display, e.g. in a browse.
Groet,
Peter de Valença

Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.
Previous
Reply
Map
View

Click here to load this message in the networking platform