Sorry about that. You are correct using AFTER or FIRST with ALTER TABLE ...
MODIFY is not supported until version 4.
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
-Original Message-
Hi,
RE:
> I believe this is what you are looking for:
> ALTER TABLE Images MODIFY I
Hi,
RE:
> I believe this is what you are looking for:
> ALTER TABLE Images MODIFY Imcreatedat datetime NOT NULL default '-00-00
> 00:00:00' AFTER Imccdtemp;
Thanks, Tom for the clue.
Yes, this is what I tried, but it did not work. Seems like modify does
not accept the "AFTER" part.
I tried
I believe this is what you are looking for:
ALTER TABLE Images MODIFY Imcreatedat datetime NOT NULL default '-00-00
00:00:00' AFTER Imccdtemp;
---
Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
-Original Message-
From: Gaspar Bakos [mailto:[EMAIL PROTECTED]
Sent: Wed
