Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't add foreign key programmatically?
Message
From
05/02/2003 13:56:18
 
 
To
05/02/2003 13:27:28
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00749448
Message ID:
00749472
Views:
23
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform