>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
How did you see the order in the ourtput tabel was different? Did you do a BROWSE? That ois not reliable, because VFP might remember the last browse-layout. If you do a MODI STRU you see the real layout of the output table.
Lennert