Delphi 10 Seattle - Issue with SQL Server Varbinary(max)

[WestyOz]

I have a question regarding how the SQL Server type of varbinary(max) seems to be handled differently depending on the target platform.

The context of my issue is I have some images stored in my SQL Server 2014 database in a varbinary(max) field.

I connect to this database using the TMSConnection under auServer authentication. To this connection I link a TMSStoredProc component that calls a stored procedure that returns the fields of the table (select SystemImageId, SystemImage from dbo.systemImages).

When adding the fields to the TMSStoredProc the varbinary(max) column comes in as a TBlobField type.

The data is extracted from this field using techniques similar to:

BlobStream := selResourceTypesCurrentList.CreateBlobStream(selResourceTypesCurrentList.FieldByName('SystemImage'),TBlobStreamMode.bmRead);
localBitmap.LoadFromStream(BlobStream);

When I target either 32-bit or 64-bit Windows platforms this works fine and I am able to create & load from the stream into a TBitmap.

However if I target either the Android or IOS platforms I receive an exception at the 'CreateBlobStream' stating the expected type is incorrect - current : Blob; expected : VarBytes;

Is this an expected result or is there something I am missing? One alternative have looked at is using a TMSStoredProc component for the IOS/Android platforms but this doesn't seem the optimal solution - and I am having trouble being able to convert the data from the field which is a VarByte (TVarByteField) into a bitmap.

The TBlobField approach seems to be much cleaner and is the type that is automatically assigned to the field through the designer - is this a bug or is there some configuration that can help here?

[WestyOz]

NB - The version of SDAC I am currently using is 7.2.10

thanks,
WestyOz.

[Malc123]

I don't want to hijack this but I have a similar problem when using a Varchar(max) field. Runs on windows but Android give the error Type mismatch expecting Memo actual String

SDAC 7.2.10

[azyk]

Thank you for the information. We have reproduced the mentioned issues and fixed them. These fixes will be included in the next SDAC version.

[WestyOz]

Thank you for the feedback - appreciate your prompt attention (again!) and look forward to the next release.