Problem in YMyQuery accessing column value as variant

[necro]

I tried to assign a value to a myquery.fieldbyname('xxx').value and I get error saying it can't access value as type variant, I need to do that because I'm transfering a mysql text column (not convertable to string) to another table column by column.

Thanks in advance

Bye

[Ikar]

It is a restriction of Delphi. You cannot get access to some types of fields using Value property.

[Guest]

I cannot access as variant to anytype of data, integer, varchar... not only memo or text, it seems a mydac compo problem

[Guest]

I'm using windows xp sp1, latest mydac demo driver with delphi 7.0 and mysql 4.1, I only can access to myquery.fieldbyname('xx').text not by .value, and in memo or text mysql columns y a problem they cannot be converted to .text

[Ikar]

We couldn't reproduce the problem. Please send us complete small sample to demonstrate it and include script to create server objects.