I am trying to query the MS SQL Server database using Prolog.
Prolog Code
lemmas:-
odbc_query('my_db',
'SELECT * ,case
when ActualCost<EstimatedCost then 'true'
else 'false'
end as Value
from Work_Order '
).
It gives an error that operator is expected after 'true' .
Note: The Query works in SQL-Server but it doesn't work in Prolog