Database is opened via DE.
Note for Close Database in help file is as below.
Using CLOSE DATABASES in the Command window does not close a database if the
database was opened in the Project Manager by expanding its node or when a
form is running in its own data session. Under these circumstances, the
database remains open until the Project Manager closes the database or until
the form using the database closes.
Devendra
----- Original Message -----
From: "R. Brioul" <r.brioul /AT/ hccnet .DO.T nl>
To: <profoxtech@leafe.com>
Sent: Saturday, July 30, 2005 5:34 PM
Subject: RE: Close Database Major change VFP 9
> If you do not let the form open and close the needed database / tables
you'd
> have to open them yourself (by code) and then you'll be able to close
them
> yourself (again by code)
>
> Rob.
>
> Devendra wrote:
>
> There is change in Close database function in VFP9.
>
> Once, a database is opened in a form, it can be closed only when a form is
> closed. This major change has been indicated only by way of note in help
> topic of Close Database.
>
> Is not fair for MS to document every change that is made from earlier
> version at a place where one can find it easily ? It helps the developer
to
> know what is changed and he can assess its implications.
>
> This changed has ruined my all developments hitherto made. For my general
> accounting application, different company can be selected in one form.
What
> I am doing on selecting on new company, I close old databse and open
databse
> from new directoy. It is working very fine till VFP 9. Now as in VFP 9 due
> to chnage in Close Database behavior, as old databse cannot be closed,
> requerring is not properly functioning and giving very odd results.
>
> Is there is any workaround to close database in a form ?
>
> And one question arises in my mind that If a database cannot be closed in
a
> form, what is the use of close databse function ? Database is always
closed
> when a form is released. Moreover what prompted VFP team to change this
> behavior ?
>
> Thanks in advance.
>
> Devendra
>
>
>
>
[excessive quoting removed by server]
©2005 D C Jariwala |
