Hi Team,
I have created an entity in SQL and used it in OutSystems. When I pass an input value into the database, it throws a warning that 'id1' does not match 'id' like this. How can I resolve it?
What you could do is this
LongIntegerToIdentifier(IdentifierToLongInteger(put here the variable/attribute you want to convert) )
If this doesn't work,
Can you share the OML to have a look?
I don't understand why you are comparing or passing a different identifier from the one that is being expected. I already send you a link, which explains what is happening.
Kind regards,
Márcio Carvalho
Have you tried to see why you are passing a different identifier?
Have a look at this post
https://www.outsystems.com/forums/discussion/50959/unexpected-data-type-they-are-the-same/
Let us know if that helped you!
Kind Regards,
Márcio
Hi,Thank you for your response. I've already seen that, but I need another solution. Do you have any other ideas?
Thank u will try it
Hi Anitha have you tried to use the data converting function on both sides to be sure that both items are converted to the same data type?
Regards
Will try thanks
Hi Anitha,
What do you mean by "I created an entity in SQL"? Are we talking about an external table, not defined in OutSystems?
I have an entity in external Db , where I am creating the entity which is integrated to outsystems
Hi Anitha,You just need to use data conversion function "LongIntegerToIdentifier " provided by the OS. You can check out this reference link: data_conversion.
Thanks @Narendra Maheshwari.
You are welcome!!