memo binary can you program this? 1

[jonoX]

I want to program a change to a table using

alter table

the field type is memo binary.

if I use alter table ailib add column cimage M
it produces a memo field not a memo binary

 

[ramani]

Hi Jono

ALTER TABLE myTable ADD COLUMN myMemo M NOCPTRANS


ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com

 

[casters]

Jono,
try to use the following:

alter table ailib add column cimage M NOCPTRANS

you can add the parameter NOCPTRANS after all the fields that you want to be created as binary