This topic is locked

Edit SQL Query possible bug

6/3/2005 11:16:09 AM
PHPRunner General questions
prleo1 author

I think that this might be a bug.
I create a new project, select one table, then I Add columns to the list. The next step gives you an option to edit the SQL query. If I add aliases to the columns to format the headers columns on the page, then press the back button, only one column is selected in the list even if I selected all previously.

This is what I am entering in the Edit SQL Query window:
select `project_id` AS 'Project ID',

`project_name` AS 'Project Name',

`project_number` AS 'Project Number'

From project
If I take out the aliases in the window and press back, all of the columns selected previously are still on the display list.
Has anyone experienced this before?

Sergey Kornilov admin 6/6/2005

Hi,
on Choose page tab you can add/ remove only existing fields. So if you change field names PHPRunner can't find them in database.
You can change field lables on the Formattingtab without using SQL query.