Error with Memo Field

John Bell · Post by **John Bell** » Thu 23 Oct 2008 13:29

get the following error (just downloaded the latest sdac and mydac)
---------------------------
Debugger Exception Notification
---------------------------
Project Speakers.exe raised exception class EOLEDBError with message 'Requested conversion is not supported.

Parameter[8] :SpkrBio - invalid Value (Status = 2h).'.
---------------------------
Break Continue Help
---------------------------

using the following
DestTable.Fields.Assign(SourceTable.Fields);

DestTable is TMSQuery and SourceTable is a TTable (Paradox)
the field is a M10 in paradox and NTEXT in SQLServer (2000).
works if the field is null but as soon as there is data in it, the
error pops up.

it works if i use
if SourceTable.Fields.DataType ftMemo then
begin
DestTable.Fields.Assign(SourceTable.Fields);
end else
begin
DestTable.Fields.AsString := SourceTable.Fields.AsString;
end;

thanks

Challenger · Post by **Challenger** » Fri 24 Oct 2008 11:43

Please specify the version of SQL Server you use.