parse SQL failed in Data source with = or "
Hi, I'm creating data source with JDBC or Data connection. Recently I got a parsing error because of using SQL function with =. For example, the following query will fail by =. select IIF...
Forum Discussion
SmartBear_Suppo
Alumni
Alumni
kevman wrote: Hi, I noticed that if I add properties by manual, then the task just passed.
It fails when you try to rebuild with 'Build Query' wizard.
Select IIF(Injury= 1, 'Yes','No') as Test
From
dbo.Injury Where PatentID= 1
Interesting!
Can you please show the two versions of the query? I.e. the one that works (manually written) and the one that doesn't (generated by the SQL wizard).
Regards
Henrik O
SmartBear Software