Micro Focus QTP (UFT) Forums

I want to execute a sql which is having single quotes in it....

sql = " select 'update '||column_name||' ' from all_tab_columns "

Since i have used the single quote inside the query, part of the query is commented due to singel quotes. Is anyway we can execute the query?

Please advice on this....


Thanks,
Venkatesh

Yes..You can do it easily

ADD DOUBLE " " AND IN IT..YOU WILL HAVE SINGLE QUOTE..

EXAMPLE

"SELECT FIRSTNAME FROM LEARNQTP WHERE NAME = 'QTPScript'"