I have a form with atable control which lists all the employees, and a
sub-form with atable control that lists the payroll data of each employee.
If an employee isselected in the first table, the employeeID should be passed
to thesub form to filter the data for the selected employee. The code couldlook
something like this:
oDoc=ThisComponent.DrawPage.Forms oFormACemplData=oDoc.getByName("ACemplData”)
' main form oFormPayrollData=oDoc.getByName("FormPayrollData”) ' sub form
oEmployeeID =oForm.getByName("employeeID") ' employeeID is theparameter for
TablePayrollData. sEmployeeID =oEmployeeID.text oFormPayrollData.Parameter=
setINT(sEmployeeID) oFormPayrollData.refresh()
It is this second tolast line, the syntax of which I do not know, and have not
been ableto find in any of the examples I have read and re-read. Alternatively,
if itis not possible to just pass a parameter to the table, may be it
ispossible to pass a complete prepared statement instead.
Could anybodyprovide some clue on how to do it?Thanks for helping. Egbert
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted