<< Click to Display Table of Contents >> Navigation: Extensibility Add On upgrade to iVend Retail 6.6 > Change 7 T-SQL level changes in the addon |
Navigation: Extensibility Add On upgrade to iVend Retail 6.6 >
The SQL queries (in add-on) where key is appended, single inverted commas ( string) would be includes at start and end of string.
Type cast the primary key value to nvachar for any comparison in sqlqueries ( in case type casted any where in bigint)
Convert(bigint, U_CXS_USERDEFINEDTABLE.U_CXS_USERDEFINEDTABLEKey)
should be converted to
Convert(nvarchar(50), U_CXS_USERDEFINEDTABLE.U_CXS_USERDEFINEDTABLEKey)