#2 RxMemoryData1.LoadFromDataSet bug?

[Anonymous]

Folks,

have you noticed that for RXLib package when using
RXMemoryData component and for this component using
smth. like:
RxMemoryData1.LoadFromDataSet(ADODataSet2,
ADODataSet2.RecordCount, lmCopy);
where ADODataSet represents ADO record set with
UNICODE (MS SQL -nvarchar) fields the data for these
fields are not copied to RXMemoryData component !?

In DBUtils.pas module routine AssignRecord(...) has
the following code :
....
{$IFDEF WIN32}
F.Value := Source.Fields[I].Value;
{$ELSE}
....

F.Value still NULL after assignment even though
Source.Fields[I].Value has a not NULL value for
ftWideString fields.

The problem not only in MS SQL narchar fields, 'cause
i can duplicate the same problem by using
Microsoft.Jet.OLEDB.4.0 for Excel8.0 to bring XLS file
to a ADO recordset.

Any ideas why assigning Variant to Variant fails for
DataType ftWideString ?

Thanks and regards,

_/_/_/ _/_/_/ _/_/_/ _/_/_/ _/_/_/
_/ _/ _/ _/ _/ _/ /_/ _/
_/_/ _/ _/ _/ _/ _/ ("`-''-
/").___..--''"`-._
_/_/ _/_/ _/_/_/ _/ _/_/ `o_ o )
`-. ( .'..')
_/ _/ _/_/ _/ /_/ _/
(_Y_.)' ._ ) `._ `. `..'
_/ _/ _/ _/ _/ _/ _/ _/ _ .`--'_..-
_/ /--'_.' .'
_/_/_/ _/_/_/ _/ _/ _/_/_/ _/_/_/(il).-''
(li).' ((!.-'

///////////////////////////////////////////////////////
////////////////
// Serge Shimanovsky // E-Mail:
serge.shimanovsky@multex.com //
// Computer Programmer // Phone: Available upon
request //
///////////////////////////////////////////////////////
////////////////
This email message is for the sole use of the intended
recipient(s) and may contain confidential and
privileged information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are
not the intended recipient, please contact the sender
by reply email and destroy all copies of the original
message. Any views expressed in the email message are
those of the individual sender except where the sender
specifically states them to be the views of
Multex.com, Inc.

[Nobody/Anonymous]

Logged In: NO

Seems that I remember someone in our office saying
something about the "=" operator not working with
WideStrings (this, too, was dealing with a variant array).
He had to go in and add a "Copy()" method or something to
that effect. I realize that's sketchy info at best, but
maybe it will point you in the right direction!! :)

[Nobody/Anonymous]

Logged In: NO

I'm getting a similar error with ADO datasets, except i'm
using an interbase ADO provider. The error I get is "Field
XXXXX cannot be modified". this error is occuring on the
{$IFDEF WIN32}
F.Value := Source.Fields[I].Value;
{$ELSE}
section.