Problem in YMyQuery accessing column value as variant

Problem in YMyQuery accessing column value as variant

Postby necro » Tue 14 Dec 2004 18:49

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
necro
 

Re: Problem in YMyQuery accessing column value as variant

Postby Ikar » Wed 15 Dec 2004 09:49

It is a restriction of Delphi. You cannot get access to some types of fields using Value property.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56

Postby Guest » Thu 16 Dec 2004 11:01

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

Postby Guest » Thu 16 Dec 2004 11:13

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
Guest
 

Postby Ikar » Fri 17 Dec 2004 09:11

We couldn't reproduce the problem. Please send us complete small sample to demonstrate it and include script to create server objects.
Ikar
 
Posts: 1693
Joined: Thu 28 Oct 2004 13:56


Return to MySQL Data Access Components