Code:
m_database = "database=southwind"
m_table = "table=products"
m_tabletitle = "tabletitle=Item Details"
m_selectcolumn = "selectcolumn=productid"
m_columncount = "columncount=1"
m_columntitles = "columntitles=Categories"
m_columns = "columns=categories,categoryid:categoryname|products,productid,categoryid=%7B%7D"
m_columnsorderby = "columnsorderby=||"
m_picklist = "picklist=products|productid,productname|categoryid=%7B%7D"
m_par = m_database + "&" + m_table + "&" + m_tabletitle + "&" + m_selectcolumn + "&" + m_columncount + "&" + m_columntitles + "&" + m_columns + "&" + m_columnsorderby + "&" + m_picklist
? m_par
Lianja.showQueryPickerPanel("Browse Items", "", "southwind", "products", m_par, 900)
this, work fine.
the only left question is:
I've try with this:
m_picklist = "picklist=products|productid,productname|1=1"
on the bottom, I see all the "Products".. great
and the search work fine
have you see if is possible to hide the top column and show only the picklist?
one suggestion..
if I set "columncount=-1"
you show only the picklist.. and the query are performed without to click on the header grid.. :-)
Bookmarks