I am trying to execute a query with db_execute_query and am getting an error 10162 syntax error error. The query works perfectly fine if executed from any db application but if I try running it via TSL with db_execute_query(), I keep getting a syntax error. Here is the query...
select a.*, b.description from djetpac_julius..PortfolioComponents a inner join PortfolioDescription b on a.portfolioId = b.portfolioId and description = "Scratch - Analysis"
....what is the problem here? Again, this query works perfectly fine when I execute it from any database app, and ONLY fails with a syntax error when running via the db_execute_query() function.
Further hint - put the sql string in a variable and use the command
</font><blockquote><font size="1" face="Verdana, Arial, Helvetica">code:</font><hr /><pre style="font-size:x-small; font-family: monospace;">print sql;</pre><hr /></blockquote><font size="2" face="Verdana, Arial, Helvetica">to see exactly how it looks to WinRunner.