>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