0
 Followers
1
 Like

GUID (uniqueidentifier) within database extension

Integration
New

When we create extension that holds tables, the MSSQL uniqueidentifier field type, is proposed to be 'text' in integration studio.


If you use it as text, then using 'advanced sql' widget, its not straightforward to compare tables value with lets say '' empty string. Because now outsystems suppose it is text, and comparison field = '' doesnt cause any errors within 'service studio'.


However, when OutSystems executes the query at the database, we get error that '' 'cannot be converted to uniqueidentifier'.

Created on 5 Sep 2018
Comments (1)

Changed the category to Integration


views
233
Followers
0