RE: Closing a database

From: [at]} <support{>
Date: Fri, 9 Jul 2004 09:00:13 +0200

----boundary-LibPST-iamunique-668891966_-_-
Content-type: text/plain

Bart,

another aspect to your question is that holding more than one global
reference to a database object would prevent the effective use of the
so-called anchor controls; because you would also have to include several
anchor controls into your form in such a situation. For more details on
anchor controls please refer to the Sql subsystem's developer manual.

Cheers
Marc
Oberon microsystems, Inc.


> -----Original Message-----
> From: Wijck, Bart van [mailto:Bart.van.Wijck{([at]})nowhere.xy
> Sent: Donnerstag, 8. Juli 2004 12:45
> To: 'blackbox{([at]})nowhere.xy
> Subject: Closing a database
>
>
> Hi BlackBox people,

>
> Can anyone answer the following question:
>
> As long as you are processing a database with SQL you need
> database and table objects. When you are done processing you
> set these object pointers to NIL. With the explicit command
> Kernel.Cleanup the garbage collector closes the database, or
> I presume this happens anyway when you are finish executing
> altogether. The point obviously is not to keep the database
> open longer than necessary.
>
> What I do not understand why BlackBox advises to make the
> database pointer a local variable and only export the table
> pointer. Yes you can at anytime recreate the database pointer
> form the table pointer via:
>
> db := <sybsytem>.rt.base; (* where rt is the result table
> pointer *)
>
> But what is the big difference? The presumably large chunk of
> memory where the database object is allocated is retained in
> any case until all (!) references to it are set to NIL. So
> even if db is local and presumably set to NIL automatically
> when the procedure in which it is defined has finished
> executing, there's still the reference to it in rt.base
> (which is global and exported). Closing the database still
> needs to be done explicitly by setting rt := NIL.
>
> So why not export both objects and set them to NIL when needed?
>
> Regards, Bart
>
>
>
>
>
>
> --
> The contents of this e-mail are intended for the named
> addressee only. It contains information that may be
> confidential. Unless you are the named addressee or an
> authorized designee, you may not copy or use it, or disclose
> it to anyone else. If you received it in error please notify
> us immediately and then destroy it.
>
> --------------------------------------------
>
> To unsubscribe from this mailing list, send a message
> containing the word "unsubscribe" to:
> blackbox-request{([at]})nowhere.xy
>
> To get a list of valid e-mail commands and instructions on
> their usage, send a message containing the word "help" to the
> above address.
>
> Send any problem reports or questions related to this email
> list to the list owner at
> owner-blackbox{([at]})nowhere.xy
>
> Current posting policy:
>
> a) To post you should use the same address by which you are
> subscribed to the mailing list. That way, the list server
> will recognize you as subscriber and forward your posting
> immediately, without creating any overhead.
>
> b) If, for some reason, you cannot post from the address, by
> which you are subscribed, your message will be moderated to
> avoid spam. Please understand that moderation will often
> cause some delay, in particular over weekends or holydays.
>


--------------------------------------------

To unsubscribe from this mailing list, send a message containing the word "unsubscribe" to:
   blackbox-request{([at]})nowhere.xy

To get a list of valid e-mail commands and instructions on their usage, send a message containing the word "help" to the above address.

Send any problem reports or questions related to this email list to the list owner at
   owner-blackbox{([at]})nowhere.xy

Current posting policy:

a) To post you should use the same address by which you are subscribed to the mailing list. That way, the list server will recognize you as subscriber and forward your posting immediately, without creating any overhead.

b) If, for some reason, you cannot post from the address, by which you are subscribed, your message will be moderated to avoid spam. Please understand that moderation will often cause some delay, in particular over weekends or holydays.

----boundary-LibPST-iamunique-668891966_-_-
Content-type: application/rtf
Content-transfer-encoding: base64
Content-Disposition: attachment; filename="rtf-body.rtf"

e1xydGYxXGFuc2lcYW5zaWNwZzEyNTJcZnJvbXRleHQgXGRlZmYwe1xmb250dGJsDQp7XGYwXGZz
d2lzcyBBcmlhbDt9DQp7XGYxXGZtb2Rlcm4gQ291cmllciBOZXc7fQ0Ke1xmMlxmbmlsXGZjaGFy
c2V0MiBTeW1ib2w7fQ0Ke1xmM1xmbW9kZXJuXGZjaGFyc2V0MCBDb3VyaWVyIE5ldzt9fQ0Ke1xj
b2xvcnRibFxyZWQwXGdyZWVuMFxibHVlMDtccmVkMFxncmVlbjBcYmx1ZTI1NTt9DQpcdWMxXHBh
cmRccGxhaW5cZGVmdGFiMzYwIFxmMFxmczIwIEJhcnQsXHBhcg0KXHBhcg0KYW5vdGhlciBhc3Bl
Y3QgdG8geW91ciBxdWVzdGlvbiBpcyB0aGF0IGhvbGRpbmcgbW9yZSB0aGFuIG9uZSBnbG9iYWxc
cGFyDQpyZWZlcmVuY2UgdG8gYSBkYXRhYmFzZSBvYmplY3Qgd291bGQgcHJldmVudCB0aGUgZWZm
ZWN0aXZlIHVzZSBvZiB0aGVccGFyDQpzby1jYWxsZWQgYW5jaG9yIGNvbnRyb2xzOyBiZWNhdXNl
IHlvdSB3b3VsZCBhbHNvIGhhdmUgdG8gaW5jbHVkZSBzZXZlcmFsXHBhcg0KYW5jaG9yIGNvbnRy
b2xzIGludG8geW91ciBmb3JtIGluIHN1Y2ggYSBzaXR1YXRpb24uIEZvciBtb3JlIGRldGFpbHMg
b25ccGFyDQphbmNob3IgY29udHJvbHMgcGxlYXNlIHJlZmVyIHRvIHRoZSBTcWwgc3Vic3lzdGVt
J3MgZGV2ZWxvcGVyIG1hbnVhbC5ccGFyDQpccGFyDQpDaGVlcnNccGFyDQpNYXJjXHBhcg0KT2Jl
cm9uIG1pY3Jvc3lzdGVtcywgSW5jLlxwYXINClxwYXINClxwYXINCj4gLS0tLS1PcmlnaW5hbCBN
ZXNzYWdlLS0tLS1ccGFyDQo+IEZyb206IFdpamNrLCBCYXJ0IHZhbiBbbWFpbHRvOkJhcnQudmFu
LldpamNrQG5sLmNvbXB1d2FyZS5jb21dIFxwYXINCj4gU2VudDogRG9ubmVyc3RhZywgOC4gSnVs
aSAyMDA0IDEyOjQ1XHBhcg0KPiBUbzogJ2JsYWNrYm94QG9iZXJvbi5jaCdccGFyDQo+IFN1Ympl
Y3Q6IENsb3NpbmcgYSBkYXRhYmFzZVxwYXINCj4gXHBhcg0KPiBccGFyDQo+IEhpIEJsYWNrQm94
IHBlb3BsZSxccGFyDQo+IFxwYXINCj4gQ2FuIGFueW9uZSBhbnN3ZXIgdGhlIGZvbGxvd2luZyBx
dWVzdGlvbjpccGFyDQo+IFxwYXINCj4gQXMgbG9uZyBhcyB5b3UgYXJlIHByb2Nlc3NpbmcgYSBk
YXRhYmFzZSB3aXRoIFNRTCB5b3UgbmVlZCBccGFyDQo+IGRhdGFiYXNlIGFuZCB0YWJsZSBvYmpl
Y3RzLiBXaGVuIHlvdSBhcmUgZG9uZSBwcm9jZXNzaW5nIHlvdSBccGFyDQo+IHNldCB0aGVzZSBv
YmplY3QgcG9pbnRlcnMgdG8gTklMLiBXaXRoIHRoZSBleHBsaWNpdCBjb21tYW5kIFxwYXINCj4g
S2VybmVsLkNsZWFudXAgdGhlIGdhcmJhZ2UgY29sbGVjdG9yIGNsb3NlcyB0aGUgZGF0YWJhc2Us
IG9yIFxwYXINCj4gSSBwcmVzdW1lIHRoaXMgaGFwcGVucyBhbnl3YXkgd2hlbiB5b3UgYXJlIGZp
bmlzaCBleGVjdXRpbmcgXHBhcg0KPiBhbHRvZ2V0aGVyLiBUaGUgcG9pbnQgb2J2aW91c2x5IGlz
IG5vdCB0byBrZWVwIHRoZSBkYXRhYmFzZSBccGFyDQo+IG9wZW4gbG9uZ2VyIHRoYW4gbmVjZXNz
YXJ5LlxwYXINCj4gXHBhcg0KPiBXaGF0IEkgZG8gbm90IHVuZGVyc3RhbmQgd2h5IEJsYWNrQm94
IGFkdmlzZXMgdG8gbWFrZSB0aGUgXHBhcg0KPiBkYXRhYmFzZSBwb2ludGVyIGEgbG9jYWwgdmFy
aWFibGUgYW5kIG9ubHkgZXhwb3J0IHRoZSB0YWJsZSBccGFyDQo+IHBvaW50ZXIuIFllcyB5b3Ug
Y2FuIGF0IGFueXRpbWUgcmVjcmVhdGUgdGhlIGRhdGFiYXNlIHBvaW50ZXIgXHBhcg0KPiBmb3Jt
IHRoZSB0YWJsZSBwb2ludGVyIHZpYTpccGFyDQo+IFxwYXINCj4gXHRhYiBkYiA6PSA8c3lic3l0
ZW0+LnJ0LmJhc2U7XHRhYiAoKiB3aGVyZSBydCBpcyB0aGUgcmVzdWx0IHRhYmxlXHBhcg0KPiBw
b2ludGVyICopXHBhcg0KPiBccGFyDQo+IEJ1dCB3aGF0IGlzIHRoZSBiaWcgZGlmZmVyZW5jZT8g
VGhlIHByZXN1bWFibHkgbGFyZ2UgY2h1bmsgb2YgXHBhcg0KPiBtZW1vcnkgd2hlcmUgdGhlIGRh
dGFiYXNlIG9iamVjdCBpcyBhbGxvY2F0ZWQgaXMgcmV0YWluZWQgaW4gXHBhcg0KPiBhbnkgY2Fz
ZSB1bnRpbCBhbGwgKCEpIHJlZmVyZW5jZXMgdG8gaXQgYXJlIHNldCB0byBOSUwuIFNvIFxwYXIN
Cj4gZXZlbiBpZiBkYiBpcyBsb2NhbCBhbmQgcHJlc3VtYWJseSBzZXQgdG8gTklMIGF1dG9tYXRp
Y2FsbHkgXHBhcg0KPiB3aGVuIHRoZSBwcm9jZWR1cmUgaW4gd2hpY2ggaXQgaXMgZGVmaW5lZCBo
YXMgZmluaXNoZWQgXHBhcg0KPiBleGVjdXRpbmcsIHRoZXJlJ3Mgc3RpbGwgdGhlIHJlZmVyZW5j
ZSB0byBpdCBpbiBydC5iYXNlIFxwYXINCj4gKHdoaWNoIGlzIGdsb2JhbCBhbmQgZXhwb3J0ZWQp
LiBDbG9zaW5nIHRoZSBkYXRhYmFzZSBzdGlsbCBccGFyDQo+IG5lZWRzIHRvIGJlIGRvbmUgZXhw
bGljaXRseSBieSBzZXR0aW5nIHJ0IDo9IE5JTC5ccGFyDQo+IFxwYXINCj4gU28gd2h5IG5vdCBl
eHBvcnQgYm90aCBvYmplY3RzIGFuZCBzZXQgdGhlbSB0byBOSUwgd2hlbiBuZWVkZWQ/XHBhcg0K
PiBccGFyDQo+IFJlZ2FyZHMsIEJhcnQgXHBhcg0KPiBccGFyDQo+IFxwYXINCj4gXHBhcg0KPiBc
cGFyDQo+IFxwYXINCj4gXHBhcg0KPiAtLSBccGFyDQo+IFRoZSBjb250ZW50cyBvZiB0aGlzIGUt
bWFpbCBhcmUgaW50ZW5kZWQgZm9yIHRoZSBuYW1lZCBccGFyDQo+IGFkZHJlc3NlZSBvbmx5LiBJ
dCBjb250YWlucyBpbmZvcm1hdGlvbiB0aGF0IG1heSBiZSBccGFyDQo+IGNvbmZpZGVudGlhbC4g
VW5sZXNzIHlvdSBhcmUgdGhlIG5hbWVkIGFkZHJlc3NlZSBvciBhbiBccGFyDQo+IGF1dGhvcml6
ZWQgZGVzaWduZWUsIHlvdSBtYXkgbm90IGNvcHkgb3IgdXNlIGl0LCBvciBkaXNjbG9zZSBccGFy
DQo+IGl0IHRvIGFueW9uZSBlbHNlLiBJZiB5b3UgcmVjZWl2ZWQgaXQgaW4gZXJyb3IgcGxlYXNl
IG5vdGlmeSBccGFyDQo+IHVzIGltbWVkaWF0ZWx5IGFuZCB0aGVuIGRlc3Ryb3kgaXQuIFxwYXIN
Cj4gXHBhcg0KPiAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLVxw
YXINCj4gXHBhcg0KPiBUbyB1bnN1YnNjcmliZSBmcm9tIHRoaXMgbWFpbGluZyBsaXN0LCBzZW5k
IGEgbWVzc2FnZSBccGFyDQo+IGNvbnRhaW5pbmcgdGhlIHdvcmQgInVuc3Vic2NyaWJlIiB0bzpc
cGFyDQo+ICAgIGJsYWNrYm94LXJlcXVlc3RAb2Jlcm9uLmNoXHBhcg0KPiBccGFyDQo+IFRvIGdl
dCBhIGxpc3Qgb2YgdmFsaWQgZS1tYWlsIGNvbW1hbmRzIGFuZCBpbnN0cnVjdGlvbnMgb24gXHBh
cg0KPiB0aGVpciB1c2FnZSwgc2VuZCBhIG1lc3NhZ2UgY29udGFpbmluZyB0aGUgd29yZCAiaGVs
cCIgdG8gdGhlIFxwYXINCj4gYWJvdmUgYWRkcmVzcy5ccGFyDQo+IFxwYXINCj4gU2VuZCBhbnkg
cHJvYmxlbSByZXBvcnRzIG9yIHF1ZXN0aW9ucyByZWxhdGVkIHRvIHRoaXMgZW1haWwgXHBhcg0K
PiBsaXN0IHRvIHRoZSBsaXN0IG93bmVyIGF0XHBhcg0KPiAgICBvd25lci1ibGFja2JveEBvYmVy
b24uY2hccGFyDQo+IFxwYXINCj4gQ3VycmVudCBwb3N0aW5nIHBvbGljeTpccGFyDQo+IFxwYXIN
Cj4gYSkgVG8gcG9zdCB5b3Ugc2hvdWxkIHVzZSB0aGUgc2FtZSBhZGRyZXNzIGJ5IHdoaWNoIHlv
dSBhcmUgXHBhcg0KPiBzdWJzY3JpYmVkIHRvIHRoZSBtYWlsaW5nIGxpc3QuIFRoYXQgd2F5LCB0
aGUgbGlzdCBzZXJ2ZXIgXHBhcg0KPiB3aWxsIHJlY29nbml6ZSB5b3UgYXMgc3Vic2NyaWJlciBh
bmQgZm9yd2FyZCB5b3VyIHBvc3RpbmcgXHBhcg0KPiBpbW1lZGlhdGVseSwgd2l0aG91dCBjcmVh
dGluZyBhbnkgb3ZlcmhlYWQuXHBhcg0KPiBccGFyDQo+IGIpIElmLCBmb3Igc29tZSByZWFzb24s
IHlvdSBjYW5ub3QgcG9zdCBmcm9tIHRoZSBhZGRyZXNzLCBieSBccGFyDQo+IHdoaWNoIHlvdSBh
cmUgc3Vic2NyaWJlZCwgeW91ciBtZXNzYWdlIHdpbGwgYmUgbW9kZXJhdGVkIHRvIFxwYXINCj4g
YXZvaWQgc3BhbS4gUGxlYXNlIHVuZGVyc3RhbmQgdGhhdCBtb2RlcmF0aW9uIHdpbGwgb2Z0ZW4g
XHBhcg0KPiBjYXVzZSBzb21lIGRlbGF5LCBpbiBwYXJ0aWN1bGFyIG92ZXIgd2Vla2VuZHMgb3Ig
aG9seWRheXMuXHBhcg0KPiBccGFyDQpccGFyDQpccGFyDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLVxwYXINClxwYXINClRvIHVuc3Vic2NyaWJlIGZyb20gdGhp
cyBtYWlsaW5nIGxpc3QsIHNlbmQgYSBtZXNzYWdlIGNvbnRhaW5pbmcgdGhlIHdvcmQgInVuc3Vi
c2NyaWJlIiB0bzpccGFyDQogICBibGFja2JveC1yZXF1ZXN0QG9iZXJvbi5jaFxwYXINClxwYXIN
ClRvIGdldCBhIGxpc3Qgb2YgdmFsaWQgZS1tYWlsIGNvbW1hbmRzIGFuZCBpbnN0cnVjdGlvbnMg
b24gdGhlaXIgdXNhZ2UsIHNlbmQgYSBtZXNzYWdlIGNvbnRhaW5pbmcgdGhlIHdvcmQgImhlbHAi
IHRvIHRoZSBhYm92ZSBhZGRyZXNzLlxwYXINClxwYXINClNlbmQgYW55IHByb2JsZW0gcmVwb3J0
cyBvciBxdWVzdGlvbnMgcmVsYXRlZCB0byB0aGlzIGVtYWlsIGxpc3QgdG8gdGhlIGxpc3Qgb3du
ZXIgYXRccGFyDQogICBvd25lci1ibGFja2JveEBvYmVyb24uY2hccGFyDQpccGFyDQpDdXJyZW50
IHBvc3RpbmcgcG9saWN5OlxwYXINClxwYXINCmEpIFRvIHBvc3QgeW91IHNob3VsZCB1c2UgdGhl
IHNhbWUgYWRkcmVzcyBieSB3aGljaCB5b3UgYXJlIHN1YnNjcmliZWQgdG8gdGhlIG1haWxpbmcg
bGlzdC4gVGhhdCB3YXksIHRoZSBsaXN0IHNlcnZlciB3aWxsIHJlY29nbml6ZSB5b3UgYXMgc3Vi
c2NyaWJlciBhbmQgZm9yd2FyZCB5b3VyIHBvc3RpbmcgaW1tZWRpYXRlbHksIHdpdGhvdXQgY3Jl
YXRpbmcgYW55IG92ZXJoZWFkLlxwYXINClxwYXINCmIpIElmLCBmb3Igc29tZSByZWFzb24sIHlv
dSBjYW5ub3QgcG9zdCBmcm9tIHRoZSBhZGRyZXNzLCBieSB3aGljaCB5b3UgYXJlIHN1YnNjcmli
ZWQsIHlvdXIgbWVzc2FnZSB3aWxsIGJlIG1vZGVyYXRlZCB0byBhdm9pZCBzcGFtLiBQbGVhc2Ug
dW5kZXJzdGFuZCB0aGF0IG1vZGVyYXRpb24gd2lsbCBvZnRlbiBjYXVzZSBzb21lIGRlbGF5LCBp
biBwYXJ0aWN1bGFyIG92ZXIgd2Vla2VuZHMgb3IgaG9seWRheXMuXHBhcg0KfQ==


----boundary-LibPST-iamunique-668891966_-_---
Received on Fri Jul 09 2004 - 09:00:13 UTC

This archive was generated by hypermail 2.3.0 : Thu Sep 26 2013 - 06:28:41 UTC