Re: Closing a database

From: René A. Krywult <"René>
Date: Thu, 08 Jul 2004 13:36:51 +0200 (DFT)

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

As I see it, you would not want to export more than is necessary. You would not want to export any redundant (=unnecessary) information.

An interface is more clear, the less elements it contains. Everything that is not necessary to be visible, should be opaque.

Further, what is the benefit of having the db variable globally? Is manual deconstruction a benefit? Is it a benefit to have to manually deconstruct the table AND the database?

Rene

=============René A. Krywult
-------------------------------------------------
"Gûrberen," pent i naneth dî,
"mabapadan a ce darach sí!"
___________________________________



----- Original von: "Wijck, Bart van" <Bart.van.Wijck{([at]})nowhere.xy

> 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.xyTo 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.xyCurrent 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.
-------------------------------------------
Versendet durch AonWebmail (webmail.aon.at)
--------------------------------------------
To unsubscribe from this mailing list, send a message containing the word "unsubscribe" to:
   blackbox-request{([at]})nowhere.xyTo 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.xyCurrent 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-294751135_-_-
Content-type: application/rtf
Content-transfer-encoding: base64
Content-Disposition: attachment; filename="rtf-body.rtf"
e1xydGYxXGFuc2lcYW5zaWNwZzEyNTJcZnJvbXRleHQgXGRlZmYwe1xmb250dGJsDQp7XGYwXGZz
d2lzc1xmY2hhcnNldDAgQXJpYWw7fQ0Ke1xmMVxmbW9kZXJuIENvdXJpZXIgTmV3O30NCntcZjJc
Zm5pbFxmY2hhcnNldDIgU3ltYm9sO30NCntcZjNcZm1vZGVyblxmY2hhcnNldDAgQ291cmllciBO
ZXc7fX0NCntcY29sb3J0YmxccmVkMFxncmVlbjBcYmx1ZTA7XHJlZDBcZ3JlZW4wXGJsdWUyNTU7
fQ0KXHVjMVxwYXJkXHBsYWluXGRlZnRhYjM2MCBcZjBcZnMyMCBBcyBJIHNlZSBpdCwgeW91IHdv
dWxkIG5vdCB3YW50IHRvIGV4cG9ydCBtb3JlIHRoYW4gaXMgbmVjZXNzYXJ5LiBZb3Ugd291bGQg
bm90IHdhbnQgdG8gZXhwb3J0IGFueSByZWR1bmRhbnQgICg9dW5uZWNlc3NhcnkpIGluZm9ybWF0
aW9uLiBccGFyDQpccGFyDQpBbiBpbnRlcmZhY2UgaXMgbW9yZSBjbGVhciwgdGhlIGxlc3MgZWxl
bWVudHMgaXQgY29udGFpbnMuIEV2ZXJ5dGhpbmcgdGhhdCBpcyBub3QgbmVjZXNzYXJ5IHRvIGJl
IHZpc2libGUsIHNob3VsZCBiZSBvcGFxdWUuIFxwYXINClxwYXINCkZ1cnRoZXIsIHdoYXQgaXMg
dGhlIGJlbmVmaXQgb2YgaGF2aW5nIHRoZSBkYiB2YXJpYWJsZSBnbG9iYWxseT8gSXMgbWFudWFs
IGRlY29uc3RydWN0aW9uIGEgYmVuZWZpdD8gSXMgaXQgYSBiZW5lZml0IHRvIGhhdmUgdG8gbWFu
dWFsbHkgZGVjb25zdHJ1Y3QgdGhlIHRhYmxlIEFORCB0aGUgZGF0YWJhc2U/IFxwYXINClxwYXIN
ClJlbmVccGFyDQpccGFyDQo9PT09PT09PT09PT09PT09PT09PT09PT09PT1ccGFyDQpSZW5cJ2U5
IEEuIEtyeXd1bHRccGFyDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tXHBhcg0KIkdcJ2ZicmJlcmVuLCIgcGVudCBpIG5hbmV0aCBkXCdlZSxccGFyDQoi
bWFiYXBhZGFuIGEgY2UgZGFyYWNoIHNcJ2VkISJccGFyDQpfX19fX19fX19fX19fX19fX19fX19f
X19fX19fX19fX19fX1xwYXINClxwYXINClxwYXINClxwYXINCi0tLS0tIE9yaWdpbmFsIHZvbjog
ICJXaWpjaywgQmFydCB2YW4iIDxCYXJ0LnZhbi5XaWpja0BubC5jb21wdXdhcmUuY29tPjpccGFy
DQpccGFyDQo+IEhpIEJsYWNrQm94IHBlb3BsZSxccGFyDQpccGFyDQpDYW4gYW55b25lIGFuc3dl
ciB0aGUgZm9sbG93aW5nIHF1ZXN0aW9uOlxwYXINClxwYXINCkFzIGxvbmcgYXMgeW91IGFyZSBw
cm9jZXNzaW5nIGEgZGF0YWJhc2Ugd2l0aCBTUUwgeW91IG5lZWQgZGF0YWJhc2UgYW5kXHBhcg0K
dGFibGUgb2JqZWN0cy4gV2hlbiB5b3UgYXJlIGRvbmUgcHJvY2Vzc2luZyB5b3Ugc2V0IHRoZXNl
IG9iamVjdCBwb2ludGVycyB0b1xwYXINCk5JTC4gV2l0aCB0aGUgZXhwbGljaXQgY29tbWFuZCBL
ZXJuZWwuQ2xlYW51cCB0aGUgZ2FyYmFnZSBjb2xsZWN0b3IgY2xvc2VzXHBhcg0KdGhlIGRhdGFi
YXNlLCBvciBJIHByZXN1bWUgdGhpcyBoYXBwZW5zIGFueXdheSB3aGVuIHlvdSBhcmUgZmluaXNo
IGV4ZWN1dGluZ1xwYXINCmFsdG9nZXRoZXIuIFRoZSBwb2ludCBvYnZpb3VzbHkgaXMgbm90IHRv
IGtlZXAgdGhlIGRhdGFiYXNlIG9wZW4gbG9uZ2VyIHRoYW5ccGFyDQpuZWNlc3NhcnkuXHBhcg0K
XHBhcg0KV2hhdCBJIGRvIG5vdCB1bmRlcnN0YW5kIHdoeSBCbGFja0JveCBhZHZpc2VzIHRvIG1h
a2UgdGhlIGRhdGFiYXNlIHBvaW50ZXIgYVxwYXINCmxvY2FsIHZhcmlhYmxlIGFuZCBvbmx5IGV4
cG9ydCB0aGUgdGFibGUgcG9pbnRlci4gWWVzIHlvdSBjYW4gYXQgYW55dGltZVxwYXINCnJlY3Jl
YXRlIHRoZSBkYXRhYmFzZSBwb2ludGVyIGZvcm0gdGhlIHRhYmxlIHBvaW50ZXIgdmlhOlxwYXIN
ClxwYXINClx0YWIgZGIgOj0gPHN5YnN5dGVtPi5ydC5iYXNlO1x0YWIgKCogd2hlcmUgcnQgaXMg
dGhlIHJlc3VsdCB0YWJsZVxwYXINCnBvaW50ZXIgKilccGFyDQpccGFyDQpCdXQgd2hhdCBpcyB0
aGUgYmlnIGRpZmZlcmVuY2U/IFRoZSBwcmVzdW1hYmx5IGxhcmdlIGNodW5rIG9mIG1lbW9yeSB3
aGVyZVxwYXINCnRoZSBkYXRhYmFzZSBvYmplY3QgaXMgYWxsb2NhdGVkIGlzIHJldGFpbmVkIGlu
IGFueSBjYXNlIHVudGlsIGFsbCAoISlccGFyDQpyZWZlcmVuY2VzIHRvIGl0IGFyZSBzZXQgdG8g
TklMLiBTbyBldmVuIGlmIGRiIGlzIGxvY2FsIGFuZCBwcmVzdW1hYmx5IHNldFxwYXINCnRvIE5J
TCBhdXRvbWF0aWNhbGx5IHdoZW4gdGhlIHByb2NlZHVyZSBpbiB3aGljaCBpdCBpcyBkZWZpbmVk
IGhhcyBmaW5pc2hlZFxwYXINCmV4ZWN1dGluZywgdGhlcmUncyBzdGlsbCB0aGUgcmVmZXJlbmNl
IHRvIGl0IGluIHJ0LmJhc2UgKHdoaWNoIGlzIGdsb2JhbCBhbmRccGFyDQpleHBvcnRlZCkuXHBh
cg0KQ2xvc2luZyB0aGUgZGF0YWJhc2Ugc3RpbGwgbmVlZHMgdG8gYmUgZG9uZSBleHBsaWNpdGx5
IGJ5IHNldHRpbmcgcnQgOj0gTklMLlxwYXINClxwYXINClNvIHdoeSBub3QgZXhwb3J0IGJvdGgg
b2JqZWN0cyBhbmQgc2V0IHRoZW0gdG8gTklMIHdoZW4gbmVlZGVkP1xwYXINClxwYXINClJlZ2Fy
ZHMsIEJhcnQgXHBhcg0KXHBhcg0KXHBhcg0KXHBhcg0KXHBhcg0KXHBhcg0KXHBhcg0KLS0gXHBh
cg0KVGhlIGNvbnRlbnRzIG9mIHRoaXMgZS1tYWlsIGFyZSBpbnRlbmRlZCBmb3IgdGhlIG5hbWVk
IGFkZHJlc3NlZSBvbmx5LiBJdFxwYXINCmNvbnRhaW5zIGluZm9ybWF0aW9uIHRoYXQgbWF5IGJl
IGNvbmZpZGVudGlhbC4gVW5sZXNzIHlvdSBhcmUgdGhlIG5hbWVkXHBhcg0KYWRkcmVzc2VlIG9y
IGFuIGF1dGhvcml6ZWQgZGVzaWduZWUsIHlvdSBtYXkgbm90IGNvcHkgb3IgdXNlIGl0LCBvciBk
aXNjbG9zZVxwYXINCml0IHRvIGFueW9uZSBlbHNlLiBJZiB5b3UgcmVjZWl2ZWQgaXQgaW4gZXJy
b3IgcGxlYXNlIG5vdGlmeSB1cyBpbW1lZGlhdGVseVxwYXINCmFuZCB0aGVuIGRlc3Ryb3kgaXQu
IFxwYXINClxwYXINCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
XHBhcg0KXHBhcg0KVG8gdW5zdWJzY3JpYmUgZnJvbSB0aGlzIG1haWxpbmcgbGlzdCwgc2VuZCBh
IG1lc3NhZ2UgY29udGFpbmluZyB0aGUgd29yZCAidW5zdWJzY3JpYmUiIHRvOlxwYXINCiAgIGJs
YWNrYm94LXJlcXVlc3RAb2Jlcm9uLmNoXHBhcg0KXHBhcg0KVG8gZ2V0IGEgbGlzdCBvZiB2YWxp
ZCBlLW1haWwgY29tbWFuZHMgYW5kIGluc3RydWN0aW9ucyBvbiB0aGVpciB1c2FnZSwgc2VuZCBh
IG1lc3NhZ2UgY29udGFpbmluZyB0aGUgd29yZCAiaGVscCIgdG8gdGhlIGFib3ZlIGFkZHJlc3Mu
XHBhcg0KXHBhcg0KU2VuZCBhbnkgcHJvYmxlbSByZXBvcnRzIG9yIHF1ZXN0aW9ucyByZWxhdGVk
IHRvIHRoaXMgZW1haWwgbGlzdCB0byB0aGUgbGlzdCBvd25lciBhdFxwYXINCiAgIG93bmVyLWJs
YWNrYm94QG9iZXJvbi5jaFxwYXINClxwYXINCkN1cnJlbnQgcG9zdGluZyBwb2xpY3k6XHBhcg0K
XHBhcg0KYSkgVG8gcG9zdCB5b3Ugc2hvdWxkIHVzZSB0aGUgc2FtZSBhZGRyZXNzIGJ5IHdoaWNo
IHlvdSBhcmUgc3Vic2NyaWJlZCB0byB0aGUgbWFpbGluZyBsaXN0LiBUaGF0IHdheSwgdGhlIGxp
c3Qgc2VydmVyIHdpbGwgcmVjb2duaXplIHlvdSBhcyBzdWJzY3JpYmVyIGFuZCBmb3J3YXJkIHlv
dXIgcG9zdGluZyBpbW1lZGlhdGVseSwgd2l0aG91dCBjcmVhdGluZyBhbnkgb3ZlcmhlYWQuXHBh
cg0KXHBhcg0KYikgSWYsIGZvciBzb21lIHJlYXNvbiwgeW91IGNhbm5vdCBwb3N0IGZyb20gdGhl
IGFkZHJlc3MsIGJ5IHdoaWNoIHlvdSBhcmUgc3Vic2NyaWJlZCwgeW91ciBtZXNzYWdlIHdpbGwg
YmUgbW9kZXJhdGVkIHRvIGF2b2lkIHNwYW0uIFBsZWFzZSB1bmRlcnN0YW5kIHRoYXQgbW9kZXJh
dGlvbiB3aWxsIG9mdGVuIGNhdXNlIHNvbWUgZGVsYXksIGluIHBhcnRpY3VsYXIgb3ZlciB3ZWVr
ZW5kcyBvciBob2x5ZGF5cy5ccGFyDQpccGFyDQpccGFyDQpccGFyDQotLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tXHBhcg0KVmVyc2VuZGV0IGR1cmNoIEFvbldlYm1h
aWwgKHdlYm1haWwuYW9uLmF0KVxwYXINCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tXHBhcg0KXHBhcg0KVG8gdW5zdWJzY3JpYmUgZnJvbSB0aGlzIG1haWxpbmcg
bGlzdCwgc2VuZCBhIG1lc3NhZ2UgY29udGFpbmluZyB0aGUgd29yZCAidW5zdWJzY3JpYmUiIHRv
OlxwYXINCiAgIGJsYWNrYm94LXJlcXVlc3RAb2Jlcm9uLmNoXHBhcg0KXHBhcg0KVG8gZ2V0IGEg
bGlzdCBvZiB2YWxpZCBlLW1haWwgY29tbWFuZHMgYW5kIGluc3RydWN0aW9ucyBvbiB0aGVpciB1
c2FnZSwgc2VuZCBhIG1lc3NhZ2UgY29udGFpbmluZyB0aGUgd29yZCAiaGVscCIgdG8gdGhlIGFi
b3ZlIGFkZHJlc3MuXHBhcg0KXHBhcg0KU2VuZCBhbnkgcHJvYmxlbSByZXBvcnRzIG9yIHF1ZXN0
aW9ucyByZWxhdGVkIHRvIHRoaXMgZW1haWwgbGlzdCB0byB0aGUgbGlzdCBvd25lciBhdFxwYXIN
CiAgIG93bmVyLWJsYWNrYm94QG9iZXJvbi5jaFxwYXINClxwYXINCkN1cnJlbnQgcG9zdGluZyBw
b2xpY3k6XHBhcg0KXHBhcg0KYSkgVG8gcG9zdCB5b3Ugc2hvdWxkIHVzZSB0aGUgc2FtZSBhZGRy
ZXNzIGJ5IHdoaWNoIHlvdSBhcmUgc3Vic2NyaWJlZCB0byB0aGUgbWFpbGluZyBsaXN0LiBUaGF0
IHdheSwgdGhlIGxpc3Qgc2VydmVyIHdpbGwgcmVjb2duaXplIHlvdSBhcyBzdWJzY3JpYmVyIGFu
ZCBmb3J3YXJkIHlvdXIgcG9zdGluZyBpbW1lZGlhdGVseSwgd2l0aG91dCBjcmVhdGluZyBhbnkg
b3ZlcmhlYWQuXHBhcg0KXHBhcg0KYikgSWYsIGZvciBzb21lIHJlYXNvbiwgeW91IGNhbm5vdCBw
b3N0IGZyb20gdGhlIGFkZHJlc3MsIGJ5IHdoaWNoIHlvdSBhcmUgc3Vic2NyaWJlZCwgeW91ciBt
ZXNzYWdlIHdpbGwgYmUgbW9kZXJhdGVkIHRvIGF2b2lkIHNwYW0uIFBsZWFzZSB1bmRlcnN0YW5k
IHRoYXQgbW9kZXJhdGlvbiB3aWxsIG9mdGVuIGNhdXNlIHNvbWUgZGVsYXksIGluIHBhcnRpY3Vs
YXIgb3ZlciB3ZWVrZW5kcyBvciBob2x5ZH19AGVkMzFkMzUy
----boundary-LibPST-iamunique-294751135_-_---

Received on Thu Jul 08 2004 - 13:36:51 UTC