Menu

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

0 votes

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

in Version 1.0.14 by (750 points)
edited by

1 Answer

0 votes
 
Best answer

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

by (42.3k points)
selected by
Welcome to the dbFront Q&A site, where you can ask questions and receive answers from other members of the community.
 | Minimalist Answer Theme by Digitizor Media
 |
Powered by Question2Answer
...