Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
New to Views
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00459334
Message ID:
00459338
Vues:
30
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform