Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can't add foreign key programmatically?
Message
De
05/02/2003 13:56:18
 
 
À
05/02/2003 13:27:28
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00749448
Message ID:
00749472
Vues:
24
David,

Yes, the REFERENCES clause is required.

< UPDATE >
Hmmm...I'm not sure exactly what it does in the DBC...
< /UPDATE >

What is wrong with using INDEX ON command?

>I need to clarify this post:
>
>1) I am working with a FREE TABLE. I want to add an index tag using alter table.
>
>2) I am not sure this accomplishes what I want - I want to just create a tag. I don't need to set up a relationship betwen tables.
>
>3)I see an example in the help that says:
>
>ALTER TABLE orders;
> ADD FOREIGN KEY cust_id TAG cust_id REFERENCES customer
>
>I guess the references clause is required, and sets up a relationship between the two tables? When I add the references clause - I get the error that non-dbc tables are not supported.
>
>>Instead of opening my table inventory, and then executing:
>>
>>index on kit tag kit
< snip >
Steve Gibson
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform