FieldType ftVariant (32) is not supported

Data Abstract
1

IDE: Delphi XE6
Version: 9.3.105.1351 Server Edition
Driver: SDAC (ver 8.0.2) & SQL Server 2012

Hi,

I have this error in the server side, but it only show in the debug mode.

An simple query return this exception:

Exception class EDAException with message ‘FieldType ftVariant (32) is not supported’

  Query: SELECT 1 userID, 'aaa' Name
  try
    ds := Schema.NewDataset(Connection, 'NewTable'); --Exception show
    ds.Open;

    if not ds.IsEmpty then
    begin
      //Code
    end;
  finally
    ds.Close;
  end;

But the code execute fine.

Regards!

2

Can you confirm that fields in this table are Integer and String? You can see it in Schema Modeler.

3

Hi,

Yes both have the correct datatype.

img
img.jpg1044×411 84.3 KB

4

Thanks, logged as bugs://79574

5

pls update uDAADOInterfaces.pas as

function MSSQL_IsAzure(Query: IDAServerDataset):Boolean;
..
    Query.SQL := 'SELECT cast(SERVERPROPERTY (''edition'') as varchar)'; // changed
6

bugs://79574 got closed with status fixed.

7

Thank you, problem solved.