How to create and present a new view ?

[goxatago]

Hello,
First of all, thank you very much for a truly great package !. Clearly a lot of smart forward thinking went into it.
I have setup my database, field presentation, validation and table relationships. Everything works great. Thank you again Steve.

However... somehow I am not clear on how to setup a custom view within xataface. I know how to do this in mysql, but I am definitely missing something on including this in xataface.
The views I have in mind are the type you would create with mysql "group by" statements, to calculate fields, get totals, etc. My first though was to create a "view_x" directory inside the tables directory and then create a corresponding "fields.ini" that will include a custom "__sql__" statement. Assuming I get this done, how can I make them show up in the xataface interface ?

I would really appreciate it if someone can point me to the right direction.

Thank you.

S.

[shannah]

Just set up the view in mysql, then work with it in Xataface as it it was a table.
All you need to do is tell xataface which columns comprise the primary key of the view in the fields.ini file, using the Key=PRI directive.

e.g.

Code: Select all

[myfield]
    Key=PRI