Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Query doesn't respect order of fields
Message
De
01/06/2007 08:44:22
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 5
Divers
Thread ID:
01229764
Message ID:
01229766
Vues:
8
>Hi All,
>
>I'm writing a query witn an output to a table that already exists. Strange thing is that the order of the fields is not equal to the order as it is written in the query. It place the fields in alphabetic order in stead of how it is written.
>
>For example:
>
>Select  aveld, cveld, bveld from klm into table outputklm
>
>
>I get the following order in the output table aveld, bveld, cveld. How could I solve this?
>
>Thanks beforehand

You shouldn't rely in the order of fields in your code.

However if you really need it, are you sure you're looking at the correct table?

PS: You're saying to a table that already exists but creating a new one with select.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform