Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Order of Fields
Message
De
01/05/2001 12:49:34
Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00501984
Message ID:
00502057
Vues:
20
Hey Eric,

Actually Larry had it right. I'm talking about the ControlSource dropdown in the Properties Sheet. I was just hoping there was another way of approaching it rather than having to dump and reload tables. Thanks!

Regards, Renoir

>>>Is there a way to sort the field names in a table or view? I have a lot of fields I need to add to some forms and having them listed alphabetically in the ControlSource dropdown would be really nice. As it is I have to search through and hope I see the specific field I'm looking for or try to estimate where it is in the list based on the field number. I tried to do a search for a thread on this topic, but the server wouldn't respond. Thanks!
>>>
>>>Regards, Renoir
>>
>>As you have seen, they are listed in the order they were created. You can sort your tables at creation using AFIELDS().
>>
>>1. Create your table as you see fit.
>>2. Issue an AFIELDS() to create an array with the necessary information.
>>3. Sort the array.
>>4. Issue a CREATE TABLE table name from array array name
>>
>>This will overwrite the table already in the DBC. This works if you have nothing in the table you want to save. If you have stuff, you can create a temporary database and temporary table with the same field definitions. Append the data to the temporary table. Create the new sorted table in the main database and append back from the temporary table.
>>
>>HTH.
>
>Seems like he could just leave off #4 and load the dropdown with the sorted list. It shouldn't matter if the table is sorted or not if I understand the thread.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform