Blob/Image problem

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
JeePeeTee
Posts: 3
Joined: Thu 29 May 2008 10:04

Blob/Image problem

Post by JeePeeTee » Mon 13 Sep 2010 08:42

When selecting from an updatable view within MSSQL2008, columns defined as Blob/Image are retrieved within Delphi as integer columns.

When this is done on MSSQL2005 everything works fine.

This table has filestream enabled. A new 2008 feature that seems to do the unwanted 'trick'.

Problem seems to come from MSSQL2008. After activating the filestream, the table (with blob field) is upgraded with a new column UID. This column isn't available in the (already existing view) and gives problems when this view is accessed through TMSQuery component!?

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Mon 13 Sep 2010 14:31

Now SDAC doesn't support filestream fields. We are investigating the possibility of adding this functionality in the future. As soon as we solve this question we will let you know.

Post Reply