... But it does, at least as far as the dropping of tags is concerned.
My question is are there limitations or gotchas?
This code run fine:
CREATE TABLE tagtest free;
(name c(20), date d, amount n(10,2))
INSERT INTO tagtest VALUES ("bob", DATE(), 75)
INSERT INTO tagtest VALUES ("rob", DATE()-20, 43)
INSERT INTO tagtest VALUES ("sam", DATE()+7, 95)
INSERT INTO tagtest VALUES ("rachael", DATE()-300, -7)
INDEX on name TAG names
INDEX on date TAG dates
ALTER table tagtest;
drop foreign KEY TAG names
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Ed Leafe
Sent: Friday, July 21, 2006 7:55 AM
To: [EMAIL PROTECTED]
Subject: Re: drop foreign key tag ...
On Jul 21, 2006, at 7:47 AM, Lew wrote:
> I'm looking for the sql equivalent to drop tag ... for contained
> and/or free tables. alter table ... drop foreign key tag ... seems to
> work
VFP SQL doesn't support the creation/deletion of ordinary tags.
Just use INDEX ON and DELETE TAG as usual.
-- Ed Leafe
-- http://leafe.com
-- http://dabodev.com
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
