Hi Ferry, > Any chance this may get implemented by referring to the control in the > sql string, i.e. MSA style: where column = [control1]?
I suppose it would look like this, yes. > At the time it appeared that you need to have analyse queries on to get > parameters to work. Yes. > I found where to store the data for the parameters, and was not able to > fill them with data. But not without the dialog box popping up after > requery which destroys the data just stored. Actually this dialog box > needs to be made aware not ask the user for values that had just been > set by macro code. I'd appreciate an issue for this. I am not sure whether there already is code which should prevent this from happening (overwriting user-supplied parameters), in any case, it's a bug to me. > Anything I can do to help? join the feature discussion when/if we decide to implement this :) Thanks & Ciao Frank -- - Frank Schönheit, Software Engineer [email protected] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
