Fixed: Can't get data, Argument data type image is invalid for argument 1 of len function.

Question

With Version: 1.0.14.2801, I am getting Error: "Data Error: Can't get data, Argument data type image is invalid for argument 1 of len function."

In my existing database, I have a table with a column of "image" Data Type and no issue here.
However, if I create a new database, with the table in which I have one column with the "image" Data Type, then I see issue above as soon as the page loads in dbFront

Answer 1

This issue has been fixed in dbFront version 1.0.14.2990.

The len() function could not be used on the column type IMAGE. dbFront has been updated to use datalength().

It should be noted that the IMAGE column type is depreciated in SQL Server and should be converted to varbinary(MAX). See: NTEXT, TEXT, and IMAGE depreciation notice