I'm using DBSys 4.25 to alter a String(30) to Memo and I'm getting the
error message "Unmanageable Field Conversion for field "abc"...

Why can't it convert a String(30) to memo?

TIA
Dave

Dave


I have no idea but why not use a script something like

ALTER TABLE xx ADD COLUMN memofield MEMO;
UPDATE xx SET memofield = stringfield;
ALTER TABLE xx DROP COLUMN stringfield;



Roy Lambert

Roy

The thing is not another way to do the task but if it is a bug, Tim will fix
it for us.

Eduardo

Dave,

<< I'm using DBSys 4.25 to alter a String(30) to Memo and I'm getting the
error message "Unmanageable Field Conversion for field "abc"...

Why can't it convert a String(30) to memo? >>

It simply can't - DBISAM has never been able to convert BLOB types to
non-BLOB types in an alter.

--
Tim Young
Elevate Software
www.elevatesoft.com

Jose


Agreed, but sometimes you need to do the job as well

Roy Lambert

Tim

>It simply can't - DBISAM has never been able to convert BLOB types to
>non-BLOB types in an alter.


Err he's trying to alter a non-blob to a blob. Just thought I'd mention it.

Roy Lambert

Roy

Ok, agreed.
Developers can wait but customer canNOT.

Eduardo

Roy,

<< Err he's trying to alter a non-blob to a blob. Just thought I'd mention
it. >>

Same thing - I forgot to add "and vice-versa".

--
Tim Young
Elevate Software
www.elevatesoft.com