SQL transaction state error

From: Hof, Philipp <"Hof,>
Date: Mon, 04 Nov 2002 16:29:16 +1300

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

Hi,

I am using Blackbox 1.4 educational version with Windows XP and the desktop
MS SQL Server 7.0.

I can successfully connect to the SQL server with the Blackbox's own SQL
Browser and execute my SQL statements. However if I close then the SQL
Browser dialog the following message pops up:

[Microsoft][ODBC SQL Server Driver]Invalid transaction state

The same happens if I try to close the database connection with this piece
of code:

...

VAR
   table*: SqlDB.Table;

...

PROCEDURE Close*;
BEGIN
   IF table # NIL THEN
      table.Clear;
      table := NIL
   END;
   Services.Collect
END Close;


Any help is welcome.

Thanks, Philipp
--------------------------------------------

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-1733190399_-_-
Content-type: application/rtf
Content-transfer-encoding: base64
Content-Disposition: attachment; filename="rtf-body.rtf"

e1xydGYxXGFuc2lcYW5zaWNwZzEyNTJcZnJvbXRleHQgXGRlZmYwe1xmb250dGJsDQp7XGYwXGZz
d2lzcyBBcmlhbDt9DQp7XGYxXGZtb2Rlcm4gQ291cmllciBOZXc7fQ0Ke1xmMlxmbmlsXGZjaGFy
c2V0MiBTeW1ib2w7fQ0Ke1xmM1xmbW9kZXJuXGZjaGFyc2V0MCBDb3VyaWVyIE5ldzt9fQ0Ke1xj
b2xvcnRibFxyZWQwXGdyZWVuMFxibHVlMDtccmVkMFxncmVlbjBcYmx1ZTI1NTt9DQpcdWMxXHBh
cmRccGxhaW5cZGVmdGFiMzYwIFxmMFxmczIwIEhpLFxwYXINClxwYXINCkkgYW0gdXNpbmcgQmxh
Y2tib3ggMS40IGVkdWNhdGlvbmFsIHZlcnNpb24gd2l0aCBXaW5kb3dzIFhQIGFuZCB0aGUgZGVz
a3RvcFxwYXINCk1TIFNRTCBTZXJ2ZXIgNy4wLlxwYXINClxwYXINCkkgY2FuIHN1Y2Nlc3NmdWxs
eSBjb25uZWN0IHRvIHRoZSBTUUwgc2VydmVyIHdpdGggdGhlIEJsYWNrYm94J3Mgb3duIFNRTFxw
YXINCkJyb3dzZXIgYW5kIGV4ZWN1dGUgbXkgU1FMIHN0YXRlbWVudHMuIEhvd2V2ZXIgaWYgSSBj
bG9zZSB0aGVuIHRoZSBTUUxccGFyDQpCcm93c2VyIGRpYWxvZyB0aGUgZm9sbG93aW5nIG1lc3Nh
Z2UgcG9wcyB1cDpccGFyDQpccGFyDQpbTWljcm9zb2Z0XVtPREJDIFNRTCBTZXJ2ZXIgRHJpdmVy
XUludmFsaWQgdHJhbnNhY3Rpb24gc3RhdGUgXHBhcg0KXHBhcg0KVGhlIHNhbWUgaGFwcGVucyBp
ZiBJIHRyeSB0byBjbG9zZSB0aGUgZGF0YWJhc2UgY29ubmVjdGlvbiB3aXRoIHRoaXMgcGllY2Vc
cGFyDQpvZiBjb2RlOlxwYXINClxwYXINCi4uLlxwYXINClxwYXINClZBUlxwYXINCiAgIHRhYmxl
KjogU3FsREIuVGFibGU7XHBhcg0KXHBhcg0KLi4uXHBhcg0KXHBhcg0KUFJPQ0VEVVJFIENsb3Nl
KjtccGFyDQpCRUdJTlxwYXINCiAgIElGIHRhYmxlICMgTklMIFRIRU5ccGFyDQogICAgICB0YWJs
ZS5DbGVhcjtccGFyDQogICAgICB0YWJsZSA6PSBOSUxccGFyDQogICBFTkQ7XHBhcg0KICAgU2Vy
dmljZXMuQ29sbGVjdFxwYXINCkVORCBDbG9zZTtccGFyDQpccGFyDQpccGFyDQpBbnkgaGVscCBp
cyB3ZWxjb21lLlxwYXINClxwYXINClRoYW5rcywgUGhpbGlwcFxwYXINCi0tLS0tLS0tLS0tLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tXHBhcg0KXHBhcg0KVG8gdW5zdWJzY3JpYmUg
ZnJvbSB0aGlzIG1haWxpbmcgbGlzdCwgc2VuZCBhIG1lc3NhZ2UgY29udGFpbmluZyB0aGUgd29y
ZCAidW5zdWJzY3JpYmUiIHRvOlxwYXINCiAgIGJsYWNrYm94LXJlcXVlc3RAb2Jlcm9uLmNoXHBh
cg0KXHBhcg0KVG8gZ2V0IGEgbGlzdCBvZiB2YWxpZCBlLW1haWwgY29tbWFuZHMgYW5kIGluc3Ry
dWN0aW9ucyBvbiB0aGVpciB1c2FnZSwgc2VuZCBhIG1lc3NhZ2UgY29udGFpbmluZyB0aGUgd29y
ZCAiaGVscCIgdG8gdGhlIGFib3ZlIGFkZHJlc3MuXHBhcg0KXHBhcg0KU2VuZCBhbnkgcHJvYmxl
bSByZXBvcnRzIG9yIHF1ZXN0aW9ucyByZWxhdGVkIHRvIHRoaXMgZW1haWwgbGlzdCB0byB0aGUg
bGlzdCBvd25lciBhdFxwYXINCiAgIG93bmVyLWJsYWNrYm94QG9iZXJvbi5jaFxwYXINClxwYXIN
CkN1cnJlbnQgcG9zdGluZyBwb2xpY3k6XHBhcg0KXHBhcg0KYSkgVG8gcG9zdCB5b3Ugc2hvdWxk
IHVzZSB0aGUgc2FtZSBhZGRyZXNzIGJ5IHdoaWNoIHlvdSBhcmUgc3Vic2NyaWJlZCB0byB0aGUg
bWFpbGluZyBsaXN0LiBUaGF0IHdheSwgdGhlIGxpc3Qgc2VydmVyIHdpbGwgcmVjb2duaXplIHlv
dSBhcyBzdWJzY3JpYmVyIGFuZCBmb3J3YXJkIHlvdXIgcG9zdGluZyBpbW1lZGlhdGVseSwgd2l0
aG91dCBjcmVhdGluZyBhbnkgb3ZlcmhlYWQuXHBhcg0KXHBhcg0KYikgSWYsIGZvciBzb21lIHJl
YXNvbiwgeW91IGNhbm5vdCBwb3N0IGZyb20gdGhlIGFkZHJlc3MsIGJ5IHdoaWNoIHlvdSBhcmUg
c3Vic2NyaWJlZCwgeW91ciBtZXNzYWdlIHdpbGwgYmUgbW9kZXJhdGVkIHRvIGF2b2lkIHNwYW0u
IFBsZWFzZSB1bmRlcnN0YW5kIHRoYXQgbW9kZXJhdGlvbiB3aWxsIG9mdGVuIGNhdXNlIHNvbWUg
ZGVsYXksIGluIHBhcnRpY3VsYXIgb3ZlciB3ZWVrZW5kcyBvciBob2x5ZGF5fX0AMS40IGVk


----boundary-LibPST-iamunique-1733190399_-_---
Received on Mon Nov 04 2002 - 04:29:16 UTC