Collapse
Envie um Service Request
Contact Information for Technical Support
Minhas Notificações de Serviço
CCOM v1.3 the type of data used in ROQL query must match in the WHERE clause for ID field
Identificação da resposta 10529 |
Revisado 17/12/2018
Why could I use WHERE ID='5' in CCOM v1.2 but in v1.3 must use WHERE ID=5 instead?
Environment:
ROQL
Resolution:
In CCOM version 1.2, the type of data used to specify the ID in the WHERE clause was not required to match. In other words, it could be with single quotes (string), or without (int), even though ID is an integer. This works in both 16.8 and 16.11. However, in v1.3, the type of data used must match in the WHERE clause. Therefore ID = '5' would not be allowed because '5' is a string, and ID is an integer.