Hi Andrew, Thanks for the detailed example!
I'm currently working on a similar Function (discussed earlier with Frank Schönheit). I believe using filtering will be much slower then using a parameter query (my database is a remote postgresql). So instead I want to use a parameter query with named parameters (e.g. where Date > :StartDate) . On opening the form I enumerate the controls and check for Bindable, Dataaware controls of which the datafield is not bound (to a column). (this step works it seems) Then I want to create parameters based on the controls name using com.sun.star.sdbc.XParameters for each unbound control. (see 14.5.1 of the api) Unfortunately I don't understand how to create NamedParameters. oForm.setDate seems to accept only a parameterIndex. The idea is to have 4 generic routines: 1) onopen to search for unbound controls 2) onchange to set the parameter to the new value when the corresponding control changes 3) the same but with a form reload 4) a form reload to be called from a button on the form, to work with 2) after setting multiple parameters The above should be simple enough, work with all form and mimics the behavior of MS Access. But first I'm stuck creating XParameters, and every time the parameter dialog box keeps popping up. I hope someone has a bright idea to help me on the way. Thanks, Ferry Toth Exalon Delft BV Radex Innovation Centre Rotterdamseweg 183C 2629 HD Delft The Netherlands Tel: +31(15)2682554 Fax: +31(15)2563727 E-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
