2. PHPRunner General questions
  3. [SOLVED]  Query designer
This topic is locked
[SOLVED]

 Query designer

 		10/19/2016 5:20:19 PM
PHPRunner General questions
greggk author

I have a quick question about the query designer. I have a table with several aliases. I wanted to use those aliases in a calculation but from the query designer page I was not able to, but then I went to the SQL page and I was able to do this:

(Select alias1+ alias2),
That worked and I was able to see the correct info in the results page, but I can't go back to the query designer page because it doesn't like what I did there. The project still works though. I was wondering if there was a different way to do it in the query designer so that it doesn't freak out about it.
Sergey Kornilov admin 10/20/2016

Show us your SQL Query and we'll try suggest the way that will survive SQL designer mode.
greggk author 10/20/2016



Show us your SQL Query and we'll try suggest the way that will survive SQL designer mode.


I did it the long way in designer. Would have been easier to be able to use the Alias, but the long way works too.

Thanks.