[Bond-users] RE Using search with views

[Colin Close]

Hi All

Embarrassed user made naming error sorry for the noise.
Search works fine for views.

Colin Close


Hi All,

Can anyone tell me whether the <search> tag works with a view my efforts
with it seem to be futile. I'm using bits of code from the Paymaster app
since it does an awful lot of what I need to do.
Here's a snippet I'm sure the structure is correct but it simply will
not work.

     <dbobject name="visit-maintenance">
             <sql>SELECT visit_maintenance.* FROM visit_maintenance ORDER
BY surname</sql>
             <search field="surname" opr="halflike" casesensitive="false">
                 <widget>empnamesearch</widget>
             </search>
             <search field="firstname" opr="halflike" casesensitive="false">
                 <widget>empnamesearch</widget>
             </search>
         <loadall/>
     </dbobject>

The table visit-maintenance is a view of a join between two tables on a
single field.

Any help greatly appreciated.

Regards

Colin Close

_______________________________________________
Bond-users mailing list
Bond-users at hcoop.net
http://hcoop.net/cgi-bin/mailman/listinfo/bond-users