Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
New to Views
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00459334
Message ID:
00459356
Views:
17
>I just within the last several month begin to use view. I have the a parametized view based on a batch id in the batch table. My view select several of the field from the table. I don't have any order set in the view. Therefore, I assume that when the view executes it will place the record in the view based on the order they were entered. Is this correct?

I'm going to disagree with my compatriots who posted earlier on this. If you don't specify an ORDER BY clause, the records are returned in the natural order of the table. In VFP's case, by record number.

This is not to confused by order of entry. If, for example, you reuse deleted records, then newer recrds may appear before older records because the record number is lower.

HTH.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform