Whoops!

Here's one that shouldn't be in gian red letters.



>As using prototyping, the query VIEWS need to save many times...
>
>But the exp_## will change to new name after save....
>
>That's means I need to save all report again to make it work....
>Or don't use the exp_## field..... ~_~'
>
>

---

You can use the AS keyword to change the default exp_xx to something a little more meaningfull. For instance if your using the View/Query Designer in the expression builder you can put:

COUNT(table.field1) AS nCount
or
(table.field1+table.field2) AS nTotal

and if you are handcoding the viw/query you can use the same syntax such as:

SELECT COUNT(table.field1) AS nCount, (table.field1+table.field2) AS nTotal;
   FROM table