[dba-dev] Re: How to refresh DataSourceBrowser in a FrameControl

2011-06-13 Thread Frank Schönheit
Hi Fernand, > I am afraid that the "parameter" stuff is not working at all > > oForm.setint(1,1000) should gives a value of "1000" to parameter 1 > > but this does nothing, the oform.parameters stay empty ? Hmm, this might be caused by some special implementation, seems to be some inconsistency

[dba-dev] Re: How to refresh DataSourceBrowser in a FrameControl

2011-06-10 Thread Fernand Vanrie
Frank , I am afraid that the "parameter" stuff is not working at all oForm.setint(1,1000) should gives a value of "1000" to parameter 1 but this does nothing, the oform.parameters stay empty ? and SQL is complaining about missing parameter value's But passing a new command an reloading work

[dba-dev] Re: How to refresh DataSourceBrowser in a FrameControl

2011-06-10 Thread Frank Schönheit
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" >

[dba-dev] Re: How to refresh DataSourceBrowser in a FrameControl

2011-06-09 Thread Fernand Vanrie
Frank , 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)

[dba-dev] Re: How to refresh DataSourceBrowser in a FrameControl

2011-06-09 Thread Fernand Vanrie
Frank , Stupid Me, I totaly overlooked the "command" i was still focused on the "activecommand" Learned (again :-) ) about "parametrized statement " Thanks a million Fernand Hi Fernand, Thanks, now i have my Model and can reload, but the reloading do not affects the activecommand ? an not

[dba-dev] Re: How to refresh DataSourceBrowser in a FrameControl

2011-06-09 Thread Frank Schönheit
Hi Fernand, > Thanks, now i have my Model and can reload, but the reloading do not > affects the activecommand ? an not the results > > So how to make the new Loaderarguments ("active") or how to pass a new > activecommand to the DatasourceBrowser Ah - I missed, in your original mail, that you

[dba-dev] Re: How to refresh DataSourceBrowser in a FrameControl

2011-06-09 Thread Fernand Vanrie
Frank , Thanks, now i have my Model and can reload, but the reloading do not affects the activecommand ? an not the results So how to make the new Loaderarguments ("active") or how to pass a new activecommand to the DatasourceBrowser my code is now: odlg.getcontrol("Grid2").LoaderArguments

[dba-dev] Re: How to refresh DataSourceBrowser in a FrameControl

2011-06-09 Thread Frank Schönheit
Hi Fernand, > Point is : my Datsourcebrowser has no model ? Ah ... the pitfalls of the Basic UNO binding! The controller supports both the XController and XTabController interfaces, both have a getModel() method, so "oController.getModel()" (or "oController.Model") is ambiguous in Basic. It is n

[dba-dev] Re: How to refresh DataSourceBrowser in a FrameControl

2011-06-08 Thread Fernand Vanrie
Hallo Frank , Point is : my Datsourcebrowser has no model ? I load a DatsourceBrowser in a FrameControl (learned from Ariel) in a Dialog oFrameControl2 = createUnoService("com.sun.star.frame.FrameControl") oDlg.addControl("Grid2" oFrameControl2) Then "Grid2" (in my Dialog) is a "com.

[dba-dev] Re: How to refresh DataSourceBrowser in a FrameControl

2011-06-08 Thread Frank Schönheit
Hello Fernand, > I try to use the "com.sun.star.frame.FrameControl" in a dialog acting as > a "subforms'. > > So i have 2 Framecontrol's loaded with a dataSource browser based on a > SQL-statement > > When selecting a row in the first FrameControl the data in the second > must been refreshed (p