I am currently working on an interfacetable and am stuck on a problem where there seems to be no search results.
I have already succeeded in linking and can see the data from the external table in a NAV page. Also the advertiser works up to a point.
This starts to jam when it comes to the data type "float". I managed to display the float field using the NAV data type "BLOB". However, when inserting I get the error message :
"The following SQL error was not expected: operand type collision: varbinary(max) is incompatible with flaot statements could not be prepared."
According to my info, since the datatype "binary" has been replaced by "BLOB", I don't see any possibilities anymore.
FYI: If I set the NAV datatype to Decimal, the page can't open at all...
I hope that you can help me.