Oracle DataTypeMap for TMemoField

[Minoru]

Hello,

I'm converting to DSDesigner from BDEDesigner with DataTypeMap.
Oralce's varchar2(300) was generated to TMemoField on D7.

Code: Select all

..
//SQLQuery1BDEDesigner1: TMemoField; 
SQLQuery1DSDesigner1: TMemoField; 
..

SQLQuery1.DataTypeMap.Clear;
SQLQuery1.DataTypeMap.AddDBTypeRule(oraVarchar2, 300, 1024, ftMemo); 
//DataTypeMap.AddFieldNameRule('備考',ftMemo); //the same error

But, got the following run-time error.

'Unsupported data type mapping: "Varchar2(300)" to "Memo"'

Is there a workaround by code?

Thanks.

[AlexP]

Hello,

For the time being, such mapping (Varchar to Memo) is not supported in DataTypeMapping. We plan to support this functionality in future.
As a workaround, you can use the LongStrings option (setting it to False), In this case, Varchar fields with size greater than 255 will be created as Memo fields

Code: Select all

OraQuery.Options.LongStrings := False;