I'm getting error for this query.
Dears,
I have fixed the issue by Rearranging the Entity Attribute Order.
Thanks for the support.
Hi,
Can you share the error?
Hi Narendra,
Please find the Error below:
Database returned the following error: Error in advanced query SQL1: Input string was not in a correct format.
Have you tried to execute your SQL without Input?
Just follow the two-step verification:
1. Remove your input variable and execute your SQL and See what is being returned in ID column.
2. After that, try to match ID column value type with your input variable
With the information provided i would guess that you are trying to pass a different data type in the inputvariable of the query. Are you passing a LongInteger as value for the Id inputparameter?if you are passing an Identifier, you can use the following code to convert it to a LongInteger:
IdentifierToLongInteger(variable)
Hi Thibaut,
I have tried both LongInteger & Identifier.
Seems nothing working for me.
does the query work when you remove the WHERE clause ?(WHERE C.Id = @Id)