>>>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
>
>I have never seen that you can't rely on the order of fields in the code, neither in fox nor in SQL Server. AFAIK it's completely reliable. Am I mistaken?
>
>Lennert
Lennert,
It depends on how you accept it. What I meant is code like:
select * from myTable into array aSomething
? "FirstName is:" + aSomething[1,5]
This code simply assumes that nobody would change the table's structure and firstName would always be in 5th position.
Cetin