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 it
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 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: