Many thanks to Jesus and Michael, you're very kind and very fast in
replying, it really is most appreciated.
It works perfectly with this on a button click:
filtervalue=hk_thisform.get_pyvisible("pcb_number").listcolumn().asstring()
sqlstr = "SELECT kcode AS reference_designator, COUNT(kcode) AS QUANTITY
FROM pcb_boms WHERE pcb_number='" + filtervalue + "' GROUP BY kcode;"
hk_this.show_warningmessage(sqlstr)
myreport=hk_thisform.database().new_reportvisible()
myreport.load_report("BOM")
myreport.datasource().disable()
myreport.datasource().set_sql(sqlstr)
myreport.datasource().enable()
myreport.set_mode(myreport.viewmode)
The debug message produced by this:
hk_this.show_warningmessage(sqlstr)
is fantastic,that really helped tracking down a slight error in my SQL.
Thanks again!
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Hk-classes-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss
