Information générale
Catégorie:
Codage, syntaxe et commandes
>No, it's is primary key, not an regular index.
>
>>> I can't find any clues how to do this in VFP help. All Sql command doesn't
>>> use for create index tag. But why not Index?
>>
>>I've found this in help on Alter table / Example:
>>
>>* Example 2
>>ALTER TABLE customer ADD PRIMARY KEY cust_id TAG cust_id
>>
>>ALTER TABLE customer ALTER COLUMN cust_id c(5) PRIMARY KEY
>>
>>I guess the second line is the syntax Jerry was looking for. Some other
>>key type may be used as well.
Somebody already answered the question for me. I was making a bigger deal out of it than I needed to.
In order to create a regular index, I used 'INDEX ON myfield TAG myfield'. It makes sense since when
using ALTER TABLE, you already have to have the DBC opened exclusive.
Jerryt
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement