creating a “view” without mysql5

Archived from the Xataface Users forum.

maddin — Fri Sep 22, 2006 6:07 am

the following code in the fields ini of my table does the trick to make these fields from a different table show up in the list wiew…

__sql__ = "select   
             u.*, a.local_id,a.title, a.text_block   
           from   
             newsletter u  
             left join   
             (  
               select   
                 local_id,title, text_block   
               from   
                 workflow   
               group by   
                 local_ID  
             ) as a   
             on   
               a.local_ID=feature1"

but not in the details view…
is there a easy way to make these fields show up in the details view as well?

cheers
martin

---

shannah — Fri Sep 22, 2006 10:19 am

I’ll have to add this to the bug tracker. I had thought that I had enabled this sort of thing for the view tab, but I must have made an omission somewhere. I’ll look into it.

Best thing to do in the mean time is to override the view tab contents with the block__view_tab_content() method of the delegate class.

See http://framework.weblite.ca/documentation/tutorial/customizing-the-dataface-look-and-feel/customizing for information about overriding blocks.

-Steve