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:
00459338
Views:
29
>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 don't think ANSI SQL, or VFP's implementation of it, guarantees the order to the records if no ORDER BY clause is specified. I have noticed that is does seem to put the records in the order they were entered, but I don't think you can count on it.
Chris McCandless
Red Sky Software
Previous
Reply
Map
View

Click here to load this message in the networking platform