>ALTER table tagtest;
drop foreign KEY TAG names
so it does, well well!
Andrew Davies MBCS CITP
- AndyD 8-)#
**
This email and any files transmitted with it are confidential and intended
solely for the use of
On Jul 21, 2006, at 9:45 AM, [EMAIL PROTECTED] wrote:
Funny but his code was alos on a free table and not part of a DBC.
That's just what I meant by it being a sloppy implementation.
Telling Fox to drop a foreign key on a free table should throw an error.
I have no idea if it matters. He
> From: Ed Leafe <[EMAIL PROTECTED]>
>
> On Jul 21, 2006, at 9:05 AM, Lew Schwartz wrote:
>
> > ... But it does, at least as far as the dropping of tags is concerned.
>
> That's a side-effect of what looks like some sloppy programming.
> Most of the VFP SQL commands translate the request
On Jul 21, 2006, at 9:05 AM, Lew Schwartz wrote:
... But it does, at least as far as the dropping of tags is concerned.
That's a side-effect of what looks like some sloppy programming.
Most of the VFP SQL commands translate the request behind-the-scenes
to regular Xbase-style commands. I'
est 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
-Orig
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 TA
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, but the
syntax seems to imply that all tags which don't contain primary or candidate
keys are 'foreign' whereas the tags I wan
7 matches
Mail list logo