Additional
dbCAP
AnyDAC
ThinDAC
NCOCI8
Topic: Support of WideMemo
Support of WideMemo
Posted: 2007/05/03 08:37
 
Hi,
Am trying to use ThinDac with Delphi 2006, however the fieldtype ftwidememo is not supported. should I change TADFormatOptions.FieldDef2ColumnDef
to map this in the same way as a widestring?

Greetings
Arjan
Re:Support of WideMemo
Posted: 2007/05/03 08:42
 
Hello

1) What DBMS, data access components and ThinDAC server do you use ?
2) What is the DB table structure ?

Regards,
Dmitry
Re:Support of WideMemo
Posted: 2007/05/03 11:24
 
ThinDac ADO Server connected to SQL2005 using Nativeclient.
The field that gives a problem is defined as NTEXT.This is return by delphi2006 as a ftWideMemo.

I changed unit daADStanOption as followed and then it worked ok.

class procedure TADFormatOptions.FieldDef2ColumnDef(ASrcFieldType: TFieldType;
ASrcSize: LongWord; ASrcPrec: Integer; var ADestDataType: TADDataType;
var ADestScale, ADestPrec: Integer; var ADestSize: LongWord;
var ADestAttrs: TADDataAttributes);
begin
..
ftMemo:
begin
ADestDataType := dtMemo;
ADestAttrs := [caBlobData];
end;
{$IFDEF AnyDAC_D10}
ftWideMemo,
{$ENDIF}
ftFmtMemo:
begin
ADestDataType := dtWideMemo;
ADestAttrs := [caBlobData];
end;
..

Post edited by: ArjanNoordhoek, at: 2007/05/03 11:44