|
Form controls changing size / getting larger / OOo3.0.1
Hi,
the size of the controls in my forms is automatically getting larger (by a
factor of two or so!). I don't know, how it happens, but it is infecting one
form after the other. I don't know, how to set the size back to normal.
When I create a new form with the wizard, the controls now are already too
large by a factor of two. So there seems to be some default that has been
changed.
This problem is quite annoying, since the controls a getting so large, that
one cannot use the forms any longer.
Any help is very welcome.
-Karl
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...
|
|
Re: Form controls changing size / getting larger / OOo3.0.1
Hi,
Karl Weber írta:
> Hi,
>
> the size of the controls in my forms is automatically getting larger (by a
> factor of two or so!). I don't know, how it happens, but it is infecting one
> form after the other. I don't know, how to set the size back to normal.
>
> When I create a new form with the wizard, the controls now are already too
> large by a factor of two. So there seems to be some default that has been
> changed.
>
> This problem is quite annoying, since the controls a getting so large, that
> one cannot use the forms any longer.
>
>
On what platform this happens and which source of OOo?
Linux distributions crate own build, what is different from OOo, what
you can download from OOo site.
If not from OOo site download that version and try to create new form
same thing happens?
Another try, reset your user profile, details on OOo community forum:
http://user.services.openoffice.org/en/forum/viewtopic.php?f=74&t=12426Regards,
Zoltan
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...
|
|
Re: Form controls changing size / getting larger / OOo3.0.1
Hi Zoltan
Am Samstag, 14. März 2009 16:38 schrieb Reizinger Zoltán:
> Hi,
>
> Karl Weber írta:
> > Hi,
> >
> > the size of the controls in my forms is automatically getting larger (by
> > a factor of two or so!). I don't know, how it happens, but it is
> > infecting one form after the other. I don't know, how to set the size
> > back to normal.
> >
> > When I create a new form with the wizard, the controls now are already
> > too large by a factor of two. So there seems to be some default that has
> > been changed.
> >
> > This problem is quite annoying, since the controls a getting so large,
> > that one cannot use the forms any longer.
> >
> >
>
> On what platform this happens and which source of OOo?
openSUSE 10.2
OOo_3.0.1_LinuxIntel_install_wJRE_de.tar.gz
OOo-SDK_3.0.0_LinuxIntel_install_en-US.sh
> Linux distributions crate own build, what is different from OOo, what
> you can download from OOo site.
OOo downloaded from OOo site.
Before installing OOo3 I removed the OOo2 from openSUSE 10.2 completely. Thus,
I didn't make an update from OOo2 to OOo3 but a fresh installation of OOo3.
By the way, I didn't install the JRE from the OOo download, since I had JDK 5
and JDK 6 already installed. I am using the JRE 6 as default.
> If not from OOo site download that version and try to create new form
> same thing happens?
> Another try, reset your user profile, details on OOo community forum:
I already renamed the whole .openoffice.org to something else and tried again.
No difference.
-Karl
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...
|
|
Re: Form controls changing size / getting larger / OOo3.0.1
Am Samstag, 14. März 2009 17:09 schrieb Karl Weber:
> Am Samstag, 14. März 2009 16:38 schrieb Reizinger Zoltán:
[...]
> > Another try, reset your user profile, details on OOo community forum:
>
> I already renamed the whole .openoffice.org to something else and tried
> again. No difference.
I must have made a mistake the first time. I tried again and it seems the
culprit was
.openoffice.org/3/user/registry/data/org/openoffice/Office/Writer.xcu
-Karl
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...
|
|
Re: Form controls changing size / getting larger / OOo3.0.1
Hi Karl,
>
> the size of the controls in my forms is automatically getting larger (by a
> factor of two or so!). I don't know, how it happens, but it is infecting one
> form after the other. I don't know, how to set the size back to normal.
Sounds a little bit like your documents are zoomed. Writer documents
share their zoom factor, so when you close one document at 200%, the
next one you open will be zoomed to 200%, too. Unfortunately, forms also
count as Writer documents here ...
For some reasons, Writer refuses to zoom documents which are,
technically, embedded into other documents. Now forms are embedded
documents (since they're part of a database document), so Edit/Zoom is
disabled. The good news in this bad news is that the implementation in
Writer is buggy, and that you can still you Ctrl+<scroll_wheel> to zoom
a form.
Ciao
Frank
--
- Frank Schönheit, Software Engineer frank.schoenheit@... -
- Sun Microsystems http://www.sun.com/staroffice -
- OpenOffice.org Base http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...
|
|
Re: Form controls changing size / getting larger / OOo3.0.1
Hi Frank,
Am Sonntag, 15. März 2009 21:50 schrieb Frank Schönheit - Sun Microsystems
Germany:
> Hi Karl,
>
> > the size of the controls in my forms is automatically getting larger (by
> > a factor of two or so!). I don't know, how it happens, but it is
> > infecting one form after the other. I don't know, how to set the size
> > back to normal.
>
> Sounds a little bit like your documents are zoomed. Writer documents
> share their zoom factor, so when you close one document at 200%, the
> next one you open will be zoomed to 200%, too. Unfortunately, forms also
> count as Writer documents here ...
>
> For some reasons, Writer refuses to zoom documents which are,
> technically, embedded into other documents. Now forms are embedded
> documents (since they're part of a database document), so Edit/Zoom is
> disabled. The good news in this bad news is that the implementation in
> Writer is buggy, and that you can still you Ctrl+<scroll_wheel> to zoom
> a form.
It is exactly that. Whenever I work with Writer, I (often) change the zoom
factor from 100% to window width (Fensterbreite). Forms opened in a Base
application then show the described behaviour (but not allways...). Moreover,
when I open more than one Writer document, it seems to be enough to change
the zoom factor of one Writer document to get this behaviour with Base. I can
change the zoom factor with Ctrl+<scroll_wheel> as you said.
However: Window size and position are also changed. Usually the window
displaying the enlarged form is so big, that I see neither its window bar nor
its menu bar nor its toolbar. They are moved off the screen. Only the lower
and the right window boundary are visible on the screen. Zooming the form
does not change window size and position. So after having changed the zoom
factor I have to make the window smaller and after that I have to move it....
This is so annoying that I now change the zoom factor of all Writer documents
to 100% before opening a Base document....
Since this bug seems to be known: will it be fixed with 3.1?
-Karl
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...
|
|
Re: Form controls changing size / getting larger / OOo3.0.1
Hi Karl,
> However: Window size and position are also changed.
that's strange, and I never encountered this. If you have a reproducible
step-by-step description of how to see this, I'd be interested in
hearing it.
> Since this bug seems to be known: will it be fixed with 3.1?
No, 3.1 is open only for fixing the most severe issues (we're near to a
release candidate), and the zoom problem doesn't qualify.
What is fixed for 3.2 is that you cannot zoom forms, though still forms
and writer docs share their "most recent zoom level".
Ciao
Frank
--
- Frank Schönheit, Software Engineer frank.schoenheit@... -
- Sun Microsystems http://www.sun.com/staroffice -
- OpenOffice.org Base http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...
|
|
Re: Form controls changing size / getting larger / OOo3.0.1
> What is fixed for 3.2 is that you cannot zoom forms, though still forms
> and writer docs share their "most recent zoom level".
>
>
Great - not!
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...
|
|
Re: Form controls changing size / getting larger / OOo3.0.1
Hi Drew,
>> What is fixed for 3.2 is that you cannot zoom forms, though still forms
>> and writer docs share their "most recent zoom level".
> Great - not!
In this order?
Ciao
Frank
--
- Frank Schönheit, Software Engineer frank.schoenheit@... -
- Sun Microsystems http://www.sun.com/staroffice -
- OpenOffice.org Base http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...
|
|
Re: Form controls changing size / getting larger / OOo3.0.1
Frank Schönheit - Sun Microsystems Germany wrote:
> Hi Drew,
>
>
>>> What is fixed for 3.2 is that you cannot zoom forms, though still forms
>>> and writer docs share their "most recent zoom level".
>>>
>> Great - not!
>>
>
> In this order?
>
> Ciao
> Frank
>
>
Sorry that was not intended to be sent...save draft and send...you would
think I could get those two straight.
But since I'm here now - The answer to your question depends on what you
mean - if you mean the ability to set the zoom factor for a form, via
the API, will no longer exist in 3.2 then I mean it as "not great IMO".
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...
|
|
Re: Form controls changing size / getting larger / OOo3.0.1
Hi Drew,
> But since I'm here now - The answer to your question depends on what you
> mean - if you mean the ability to set the zoom factor for a form, via
> the API, will no longer exist in 3.2 then I mean it as "not great IMO".
No. In 3.2, you will be able to use View/Zoom, as well as the Zoom
Slider in the status bar, in forms.
The API is completely unaffected.
What you still will not be able to do is to change the zoom of text
documents and forms independently: If you change a text doc zoom, and
close it, the next form will also open with this zoom. (Or however the
inter-document dependency of the zoom setting is defined exactly. For my
taste, there's too much magic involved, it doesn't behave like expected
in 20% or so of all cases ...)
Ciao
Frank
--
- Frank Schönheit, Software Engineer frank.schoenheit@... -
- Sun Microsystems http://www.sun.com/staroffice -
- OpenOffice.org Base http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...
|
|
Re: Form controls changing size / getting larger / OOo3.0.1
Frank Schönheit - Sun Microsystems Germany wrote:
> Hi Drew,
>
>
>> But since I'm here now - The answer to your question depends on what you
>> mean - if you mean the ability to set the zoom factor for a form, via
>> the API, will no longer exist in 3.2 then I mean it as "not great IMO".
>>
>
> No. In 3.2, you will be able to use View/Zoom, as well as the Zoom
> Slider in the status bar, in forms.
>
> The API is completely unaffected.
>
> What you still will not be able to do is to change the zoom of text
> documents and forms independently: If you change a text doc zoom, and
> close it, the next form will also open with this zoom. (Or however the
> inter-document dependency of the zoom setting is defined exactly. For my
> taste, there's too much magic involved, it doesn't behave like expected
> in 20% or so of all cases ...)
>
> Ciao
> Frank
>
>
Ah - well, see that was why I wanted to save and then read up on it
before I sent an email.
Truth is that I've come to the conclusion, for my own "use cases', that
explicitly setting the zoom factor is the best way to go.
This was intended for another email to this list - but I'll attach a
snapshot here - and a link to the files home in the later email. In this
file the zoom factor is set when each form is opened - if you use the
form Options/Behavior to change the factor to use.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...
|
|
Re: Form controls changing size / getting larger / OOo3.0.1
Frank Schönheit - Sun Microsystems Germany wrote:
> Hi Drew,
>
>
>> But since I'm here now - The answer to your question depends on what you
>> mean - if you mean the ability to set the zoom factor for a form, via
>> the API, will no longer exist in 3.2 then I mean it as "not great IMO".
>>
>
> No. In 3.2, you will be able to use View/Zoom, as well as the Zoom
> Slider in the status bar, in forms.
>
> The API is completely unaffected.
>
> What you still will not be able to do is to change the zoom of text
> documents and forms independently: If you change a text doc zoom, and
> close it, the next form will also open with this zoom. (Or however the
> inter-document dependency of the zoom setting is defined exactly. For my
> taste, there's too much magic involved, it doesn't behave like expected
> in 20% or so of all cases ...)
>
> Ciao
> Frank
>
>
Hi Ciao
To put my two cents in, I have run to this while using OO and I find it
unexpected! I would expect that a zoom level should be part of a
document. I would not and do not expect one document to be affected by
my changing the zoom of another. I would expect if I change the zoom
level of a document and close it , that when I reopen it it would have
the zoom level it had when i closed it.
When I open a document and it has a different zoom than when I last saw
it, I am surprised! Surprise is *not* a good thing in software.
=-O I have spent a lot of time trying to remove the
surprise factor from software.
I would like to see the zoom level be saved with each document and not
as a global variable.
Just my 2 cents
Cliff
--
mailto: c.liles@...
Clifton R. Liles "Software to the Stars" lilescr@...
Pearland, TX 77581 c.r.liles@... c.liles@...
- Speaking for myself! Standard disclaimer applies. -
This address may *not* be used for unsolicited mailings.
Failure is not an option. It comes bundled with your Microsoft products.
|
|
Re: Form controls changing size / getting larger / OOo3.0.1
> I would like to see the zoom level be saved with each document and not
> as a global variable. Just my 2 cents
> Cliff
>
Hi Cliff
+1 to that idea. Maybe opening a RFE would be a good idea.
That said, and recognizing that it would be nice if we didn't have to,
it is reasonably easy to manage. Albeit still a bit of a Royal PITA at
times.
For a concrete example of what I mean look at the file that will be
attached ( or referenced) in my next email on this list.
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...
|
|
Antw: Re: Form controls changing size / getting larger / OOo3.0.1
Hi Drew,
your sample database looks very interesting but I get a message each
time I open one of the forms
"com.sun.star.uno.RuntimeException invalid attempt to assign an empty
interface of type com.sun.star.document.XEmbeddedScripts!"
and I cannot open/edit/look at the macros. Will this only be able to be
run in 3.?
I am running OOO300m9 Build 9358
Thanks
Br.Egidio
>>> < userlists@...> schrieb am 24.03.2009 um
18:26:
> Frank Schönheit - Sun Microsystems Germany wrote:
>> Hi Drew,
>>
>>
>>> But since I'm here now - The answer to your question depends on
what you
>>> mean - if you mean the ability to set the zoom factor for a form,
via
>>> the API, will no longer exist in 3.2 then I mean it as "not great
IMO".
>>>
>>
>> No. In 3.2, you will be able to use View/Zoom, as well as the Zoom
>> Slider in the status bar, in forms.
>>
>> The API is completely unaffected.
>>
>> What you still will not be able to do is to change the zoom of text
>> documents and forms independently: If you change a text doc zoom,
and
>> close it, the next form will also open with this zoom. (Or however
the
>> inter-document dependency of the zoom setting is defined exactly.
For my
>> taste, there's too much magic involved, it doesn't behave like
expected
>> in 20% or so of all cases ...)
>>
>> Ciao
>> Frank
>>
>>
> Ah - well, see that was why I wanted to save and then read up on it
> before I sent an email.
>
> Truth is that I've come to the conclusion, for my own "use cases',
that
> explicitly setting the zoom factor is the best way to go.
>
> This was intended for another email to this list - but I'll attach a
> snapshot here - and a link to the files home in the later email. In
this
> file the zoom factor is set when each form is opened - if you use the
> form Options/Behavior to change the factor to use.
>
>
>
> --
> Sollte diese Nachricht Spam sein, bitte hier klicken:
> http://mail.kanaan.org/cgi-bin/learn-msg.cgi?id=0DDE22806F.16D61--
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...
|
|
Re: Form controls changing size / getting larger / OOo3.0.1
Hi Drew,
> +1 to that idea. Maybe opening a RFE would be a good idea.
+1 from my side, too. As said, the current logic contains way too much
magic for my taste.
> That said, and recognizing that it would be nice if we didn't have to,
> it is reasonably easy to manage. Albeit still a bit of a Royal PITA at
> times.
>
> For a concrete example of what I mean look at the file that will be
> attached ( or referenced) in my next email on this list.
Nice.
Is it just my machine that the very first form contains overlapping
controls, or is this really your intended design?
(Not to mention that issue 100541 manifests in a very ugly way in this
form.)
Also, changes made to the options/behavior form are applied, but not
shown when the form is opened the next time. Intended?
Furthermore, the Basic function "DeleteStr", using in onLoadForm*, does
not exist here - is this to be expected in the document, and somehow
lost? Or should it be present in every installation? Or is it something
special in one of your own Basic libs?
Just wondering which of those artifacts are perhaps 3.1 show stoppers :)
Ciao
Frank
--
- Frank Schönheit, Software Engineer frank.schoenheit@... -
- Sun Microsystems http://www.sun.com/staroffice -
- OpenOffice.org Base http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...
|
|
Re: Antw: Re: Form controls changing size / getting larger / OOo3.0.1
Hello Egidio,
> your sample database looks very interesting but I get a message each
> time I open one of the forms
>
> "com.sun.star.uno.RuntimeException invalid attempt to assign an empty
> interface of type com.sun.star.document.XEmbeddedScripts!"
> and I cannot open/edit/look at the macros. Will this only be able to be
> run in 3.?
The document contains macros embedded in the odb, as oppossed to
embedded in the forms. The former is supported in 3.1 only.
Ciao
Frank
--
- Frank Schönheit, Software Engineer frank.schoenheit@... -
- Sun Microsystems http://www.sun.com/staroffice -
- OpenOffice.org Base http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...
|
|
Re: Form controls changing size / getting larger / OOo3.0.1
Frank Schönheit - Sun Microsystems Germany wrote:
> Nice.
>
> Is it just my machine that the very first form contains overlapping
> controls, or is this really your intended design?
>
It is a problem with how the forms where constructed and setting the
zoom level it seems.
More on this as I go along on this project - but it comes down to
watching how you ANCHOR the different screen elemenets.
> Also, changes made to the options/behavior form are applied, but not
> shown when the form is opened the next time. Intended?
>
That was a hasty form / macros to demonstrate an idea...so not even
close to polished.
> Furthermore, the Basic function "DeleteStr", using in onLoadForm*, does
> not exist here - is this to be expected in the document, and somehow
> lost? Or should it be present in every installation? Or is it something
> special in one of your own Basic libs?
>
DeleteStr is found in the Tools library. The procedure Init.onLoad is
where I pull this library in.
>
> Just wondering which of those artifacts are perhaps 3.1 show stoppers :)
>
I've been working on this file since last Wednesday and my thought was
that there might be two issues worth that status.
I believe I have a solution for one - The problem with the Open Document
event on the ODB file not firing on subsequent loads.
The cause is simple - the connection is never closed, even when the
database document is closed explicitly.
Workaround Solution - NEVER do this:
thisDatabaseDocument.DataSource.getConnection( "", "" )
instead
In the procedure Init:onLoad (in this case) that is called from Open
Document on the ODB file do:
Create a dispatch handler
Displatch the uno command to switch the database document to the tables
section.
( this gets a connection established for us)
Now only open forms using
thisDatabaeDocument.FormDocuments.getByName("formName").Open
Tonight I will make that change across the board and I believe that then
a close on the ODB file will actually dispose of the connection.
The other issue is:
Close Document event for embedded forms does not seem to fire at all.
(3.1 m7 and 3.2 m44)
My workaround is going to be to instead use the UnLoad event for the top
most dataform control instead. But that just seems wrong to me.
Drew
--
OpenOffice.org User Community Forums
Connecting users around the globe!
Community forum http://user.services.openoffice.org/en Communauté francophone http://user.services.openoffice.org/fr Közösségi fórum http://user.services.openoffice.org/hu コミュニティーフォーラム http://user.services.openoffice.org/jaUnited States PostgreSQL Association: http://www.postgresql.us/---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...
|
|
Re: Form controls changing size / getting larger / OOo3.0.1
Frank Schönheit - Sun Microsystems Germany wrote:
> Hi Drew,
>
>
>> But since I'm here now - The answer to your question depends on what you
>> mean - if you mean the ability to set the zoom factor for a form, via
>> the API, will no longer exist in 3.2 then I mean it as "not great IMO".
>>
>
> No. In 3.2, you will be able to use View/Zoom, as well as the Zoom
> Slider in the status bar, in forms.
>
> The API is completely unaffected.
>
> What you still will not be able to do is to change the zoom of text
> documents and forms independently: If you change a text doc zoom, and
> close it, the next form will also open with this zoom. (Or however the
> inter-document dependency of the zoom setting is defined exactly. For my
> taste, there's too much magic involved, it doesn't behave like expected
> in 20% or so of all cases ...)
>
>
Fine - the pragmatic view then for my purposes - all that means is that
I need to be sure and set the zoom factor in the Activate Document event
for all of my forms.
Example:
In OOoBasic:
sub setNormalZoom
with thisComponent.CurrentController.ViewSettings
.ZoomType = com.sun.star.view.DocumentZoomType.BY_VALUE
.ZoomValue = 100
end with
end sub
to set the form to 100% for the current display.
That works for forms opened under 3.x and 2.4.1 I believe.
In design mode it only works only under 3.1 or greater - but does not
cause an error message of any kind under the older versions..
Thanks
Drew
--
OpenOffice.org User Community Forums
Connecting users around the globe!
Community forum http://user.services.openoffice.org/en Communauté francophone http://user.services.openoffice.org/fr Közösségi fórum http://user.services.openoffice.org/hu コミュニティーフォーラム http://user.services.openoffice.org/jaUnited States PostgreSQL Association: http://www.postgresql.us/
|
|
Re: Antw: Re: Form controls changing size / getting larger / OOo3.0.1
Frank Schönheit - Sun Microsystems Germany wrote:
Hello Egidio,
your sample database looks very interesting but I get a message each
time I open one of the forms
"com.sun.star.uno.RuntimeException invalid attempt to assign an empty
interface of type com.sun.star.document.XEmbeddedScripts!"
and I cannot open/edit/look at the macros. Will this only be able to be
run in 3.?
The document contains macros embedded in the odb, as oppossed to
embedded in the forms. The former is supported in 3.1 only.
Thank you Frank,
I kind of left that part out in the earlier email.
- well here again is another file. (Last in this thread)
This is for the Development Snapshot builds for OO.o 3.1 or 3.2 ONLY.
It was last updated using DEV320_m44 / Linux (Ubuntu 8.10 - Gnome)
Getting closer to the 'clickable prototype(mockup)' that I was after.
A couple of problems in my coding are coming to light.
A few issues that will need to be handled in code are coming to light.
The overlapping controls should be fixed on all top level forms. (Not
counting the Options/Forms in other words)
A quick scenario to see one of these.
Open the file under DEV310_m7 or DEV320_m44.
(WARNING - on my XP machine this file will hang if opened with
DEV320_m44...it does not have a problem under Linux with the same build
)
After a few seconds the database window should disappear and the
frmInoviceList form should be open on the desktop.
From frmInvoiceList
Double click on the grid area -> Hide the current form and open form
frmItemEntry.
Double click the grid area on frmItemEntry -> Open form
frmInventoryList.
On frmInventoryList Click on the button 'New'.
ERROR
Clear the error dialog.
NOTE - If you try to open the Basic IDE here you will not see the ODB
file (MyInvoice_pre_2) when you do this - WHY - because the odb file is
currently hidden. The Basic IDE UI honors this - I like that, but don't
know if it was intentional or not, I tend to think it was.
-so-
Use File>Open to bring the database document onto the desktop.
In the database document window click on the Tables section.
Now go back to the frmInventoryList and click on the 'New' button.
The form frmInventoryItem opens this time.
Why?
1 ) this is the only place (currently) where I use:
thisDatabaseDocument.FormDocuments.getByName("frmInventoryItem").Open
2) Calling Open with no parameters works ONLY after a connection has
been created USING the database document UI. The fact that within the
macros I have already used:
thisDatabaseDocument.DataSource.getConnection("","") a number of times
is not enough.
This may be significant as a clue to another issue. How to get rid of
the connections so that the file FULLy closes.
With the macros in the ODB file as it stands you can not open this file
twice in the same OO.o session and have the function Init:onLoad called
after the first time. It appears that this is because a connection(s)
to the HSQLdb engine is never released.
Another piece of information. If I create an ODB file and set the Open
Document to point to a macro in the file that does not create a
connection. ( just display a dialog box) Then I can close the odb file
and open it again under the same session - even after insuring that a
connection was created via the UI - and the macro is called each time.
SO - I am hoping that tonight I can make the changes to this file such
that I achieve this same result.
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...
|
MyInvoice_pre_0.odb (275K) 