FieldType ftVariant (32) is not supported

delphi

(rodolfo) #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!


(EvgenyK) #2

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


(rodolfo) #3

Hi,

Yes both have the correct datatype.


(RemObjects) #4

Thanks, logged as bugs://79574


(EvgenyK) #5

pls update uDAADOInterfaces.pas as

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

(RemObjects) #6

bugs://79574 got closed with status fixed.


(rodolfo) #7

Thank you, problem solved.