MI-L drop column

[Robert Crossley]

Hi all,

Another late night in Australia, more answers from europe.

I am adding a temporary calculated column to a table using the add column

Add Column T_CONSIGNMENT (NextDay Date) From T_CONSIGNMENT Set To 
D_HARV_DATE + 1

Now I want to get rid of that column again.  I know I can close the table 
and reopen it, but there will be pending changes that I don't want to 
decide whther to keep or not.

Alter Table Drop Nextday says the column does not exist.

BTW,
Although I would like the answer to this anyway, the only reason I am 
doing this
is so that I can use it in a select statement

Add Column T_CONSIGNMENT (NextDay Date) From T_CONSIGNMENT Set To 
D_HARV_DATE + 1
Add Column T_CONSIGNMENT (PrevDay Date) From T_CONSIGNMENT Set To 
D_HARV_DATE - 1
Select T_HARV_OPS.I_HARV_OP_ID, T_CONSIGNMENT.I_HARV_OP_ID "DelivHarvOp"
	from T_HARV_OPS, T_CONSIGNMENT
	where T_HARV_OPS.C_HARV_OP = "CUT" AND
		T_CONSIGNMENT.D_HARV_DATE Between T_HARV_OPS.PrevDay AND 
T_CONSIGNMENT.NextDay
	Into HarvSameDay

This actually works fine, but for some reason I get a failure if I use the 
same expression in a between statement like:
	Select T_HARV_OPS.I_HARV_OP_ID, T_CONSIGNMENT.I_HARV_OP_ID "DelivHarvOp"
		from T_HARV_OPS, T_CONSIGNMENT
		where T_HARV_OPS.C_HARV_OP = "CUT" AND
			(T_HARV_OPS.D_START_DATE) >= (T_CONSIGNMENT.D_HARV_DATE -1) AND
			(T_HARV_OPS.D_END_DATE) <= (T_CONSIGNMENT.D_HARV_DATE + 1)
		Into HarvNextDay

Thanks again
R
--

Robert Crossley

Agtrix P/L
9 Short St
New Brighton 2483
Far Southern Queensland
AUSTRALIA
153.549004 E 28.517344 S

P: 02 6680 1309
F: New Connection
M: 0419 718 642
E: [EMAIL PROTECTED]
W: www.agtrix.com
W: www.wotzhere.com
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 8934