version: 4.30 Build 2

I have a table with TMemo fields. For most of records, everything is going fine, but for one I am getting an error message #8963 when I access the table remotly while accessing it in local mode I don't have any error message.
Using the database system utility I can access the record with no error.
If I reduce the siez of the memo content it works remotly. Do you have any constraints in term of size for a remote access?

Thanks.

Etienne.

Please find attach the table on which I have the problem.


Etienne Mercier wrote:

version: 4.30 Build 2

I have a table with TMemo fields. For most of records, everything is going fine, but for one I am getting an error message #8963 when I access the table remotly while accessing it in local mode I don't have any error message.
Using the database system utility I can access the record with no error.
If I reduce the siez of the memo content it works remotly. Do you have any constraints in term of size for a remote access?

Thanks.

Etienne.

Etienne,

M<< I have a table with TMemo fields. For most of records, everything is
going fine, but for one I am getting an error message #8963 when I access
the table remotly while accessing it in local mode I don't have any error
message. >>

How are you accessing the field ?  (actual code is preferable)

<< Using the database system utility I can access the record with no error.
>>

That's what I'm seeing also.

--
Tim Young
Elevate Software
www.elevatesoft.com

Please find hereafter the code:

var
 strContenu: string;
begin
  if bdEvent.Blabla.FindKey([3,2,13,0,0]) then
   bdEvent.Get_LocalBlabla([3,2,13,0,0]);
 strContenu:=bdEvent.BlablaBlabla.GetAsWideString;
end;

where bdEvent is a datamodule in which Blabla table is declared.
The exception error happens on the GetAsWideString; only if you try to acces remotmy the table.





"Tim Young [Elevate Software]" wrote:

Etienne,

M<< I have a table with TMemo fields. For most of records, everything is
going fine, but for one I am getting an error message #8963 when I access
the table remotly while accessing it in local mode I don't have any error
message. >>

How are you accessing the field ?  (actual code is preferable)

<< Using the database system utility I can access the record with no error.
>>

That's what I'm seeing also.

--
Tim Young
Elevate Software
www.elevatesoft.com

Etienne,

<< The exception error happens on the GetAsWideString; only if you try to
acces remotmy the table. >>

You cannot use GetAsWideString with DBISAM - it only uses AnsiStrings.
Please use GetAsString instead.  If you're assigning the string to a
wide/Unicode string, then Delphi will do the conversion for you.

--
Tim Young
Elevate Software
www.elevatesoft.com

"Tim Young [Elevate Software]" wrote:

Etienne,

<< The exception error happens on the GetAsWideString; only if you try to
acces remotmy the table. >>

You cannot use GetAsWideString with DBISAM - it only uses AnsiStrings.
Please use GetAsString instead.  If you're assigning the string to a
wide/Unicode string, then Delphi will do the conversion for you. >>

Tim,

I already made a try using GetAsString and I got the same error message !! Following your advice, I made a new try but as previously it was unsuccessfully.

I don't understand why it works in local mode while remotly the record is said corrupted !

Etienne.

Etienne,

<< I already made a try using GetAsString and I got the same error message
!! Following your advice, I made a new try but as previously it was
unsuccessfully.

I don't understand why it works in local mode while remotly the record is
said corrupted ! >>

I'm not seeing any issues here with the DBSYS utility and the table that you
attached in your previous message.  If you want to send me a project that
reproduces the issue, I'll be happy to take a look and see what the issue
is.

--
Tim Young
Elevate Software
www.elevatesoft.com