SDAC and sql_variant

[ilgiz]

When I use field with data type sql_variant I get error:

table.fieldbyname('field').value = error: Unknown type: 14

but
table.fieldbyname('field').AsInteger = 1031.

[Ikar]

This message can be raised in Delphi on try to pass incorrectly generated Variant.
Please specify a full code to fill table.fieldbyname('field').value
Could you pass the same value to the local variable of Variant type?

[Guest]

CREATE TABLE svariant (
vcode int NULL ,
variant sql_variant NULL
)
GO

insert into svariant
values (1,1030.559)

var v :variant;
begin
msquery1.close;
msquery1.SQL.Text:='select * from svariant';
msquery1.Open;
v:=msquery1.FieldByName('variant').Value;

v - Unknown type: 14
end;

[Ikar]

14 corresponds to varDecimal (vt_decimal). Delphi in difference from MS SQL doesn't support this type.