Hello
I've made a database connection and configured it to an extension module, let's call it 'A'. I've added the 'A' to an app to make direct changes in the external database using the app.
I've created a form in the UI to take inputs to create an object in the database. This is the onClick action below:
In the Add Server action, for CreatePowerTest I pass values for 'Status' and 'Number' . The unique identifier 'Inv' for the object should be autogenerated. But it gives me the above error.
Even if I pass the unique identifier, by using TextToIdentifier("Abcd43") it still gives me the same error. (as you can see in the assignment PowerTest.InvId)
"conversion failed when converting from a character string to a unique identifier"
Here is a snapshot of the attribute in Integration Studio.
What does this mean?
Hi @Priya sopan
can you convert like
IntegerToIdentifier(TextToInteger(AAA))
.
Hope it helps.
Thanks
Karnika
First of all you need to specify the DB configured.If its SQL, Oracle, MySQL or DB2 then,uniqueidentifier is mapped as Text, so I believe there is no need to do any conversion, just pass the GUID text as is. Hope this helps.Thanks