Reorder Field Names?

[Ruslan Zasukhin]

on 6/3/03 13:20, Robert Brenstein at rjb at rz.uni-potsdam.de wrote:

>>>  Is there a way to reorder field names using either VAPP or VXCMD? That
>>>  is, if I have 35 field names and want to "insert" a field name in the #3
>>>  slot, is there some faster way than going through #3-#35 and changing
>>>  them by hand?
>> 
>> No way, Ken.
>> 
>> I have see that only fileMaker allow such feature.,
>> 
>> Why you need this?
>> In SQL cursor you can define any order as you want.
>> 
> 
> I think one can "reorder" fields on physical level by changing the
> order of field definitions in XML dump, then creating a new db from
> the modified dump.
> 
> Ruslan, my guess is that Ken wants more direct matching between the
> fields and the way he displays them (particularly when using * in
> SQL).

I also think so. But usually DBs do not allow this.

> Ken, from programming point of view, particularly long-term
> maintenance, it may be better to simply fetch the list of field names
> and sort them for display, saving indexes for retrieving the matching
> content.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------