>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.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao