Hi Fernand, > Me again: > when loading a paramerized statement i have aSQL error "Values not set > for all parameters" > so i load > aLoaderArguments(1).Name = "CommandType" > aLoaderArguments(1).Value = 2 'com.sun.star.sdb.CommandType.TABLE > aLoaderArguments(2).Name = "Command" > aLoaderArguments(2).Value = "SELECT distinct * FROM > pmgdbase.adv_reden_tbvips WHERE pmgdbase.adv_reden_tbvips.REDENID = ? "
Argh. There's no support for passing parameter values - the LoaderArguments you specify are passed, by the FrameControl, to the component loaded into it - which leads in DSB's case to http://api.openoffice.org/docs/common/ref/com/sun/star/sdb/DataSourceBrowser.html#XInitialization => No support for such a thing. In theory, the DSB - more precise: the form loaded into it - allows delegating parameter requests to an external instance, via the css.form.XDatabaseParameterBroadcaster interface. It allows registering listeners which are asked when a parameter is to be filled. However, you have no chance of passing such a listener to the FrameControl in a way that it reaches the form in time. So - for the very initial load, the parameter-based request won't work, sorry. Ciao Frank -- ----------------------------------------------------------------- To unsubscribe send email to dev-unsubscr...@dba.openoffice.org For additional commands send email to sy...@dba.openoffice.org with Subject: help
