Xataface Forums

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.

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