Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't add foreign key programmatically?
Message
From
05/02/2003 13:27:28
 
 
To
05/02/2003 13:19:37
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00749448
Message ID:
00749451
Views:
18
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
>
>I want to execute:
>
>alter table inventory add foreign key kit tag xkit
>
>When I execute this I get a syntax error. Does this not work as it should or am I misunderstanding something about the syntax of this command?
>
>TIA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform