cannot insert over 4000 chars into LONG field.

[wbjsoft]

I use dbexpoda.dll 4.40.0.16 using datasnap.

I traced via SQLMonitor.

insert into .......
:3 (String[17609],IN) <- DESCR field LONG type

but the LONG field truncate with 4000 byte.

table descrption follwing :

SVRTDID NOT NULL NUMBER(9)
SVRID NOT NULL NUMBER(9)
LOGTYPE NOT NULL NUMBER(4)
LOGTIME DATE
TOTALUSER NOT NULL NUMBER(9)
TOTALFILE NOT NULL NUMBER(9)
DESCR LONG

cannot insert DESCR field over 4000byte.

please check the problem.

[Plash]

Maybe you assign a value to the parameter using the AsString property. So that the parameter type is ftString.

Try to use the AsMemo or AsBlob properties instead.