Delphi / Interbase : General SQL Error invalid transaction handle (expecting explicit transaction start)

i have using delphi 6 for quite some time now and it seems that errors of the past still haunt us today.

experiencing this error code when i try to create a duplicate entry of a delivery receipt transaction. one of the suggestions i got was to disable the optimization checkbox in delphi.

after doing this it unfortunately did nothing. so i searched again, it turned out that a lot of people assumed it was a problem with the database.

what i did was to trace, line by line, my code until i reach the StoredProc in question. What i did was to put a try… except outside the storedproc procedure and everything went into place.

hope this article can help somebody in the same pickle jar as me.

Pocket Calculator Turns On by Itself and Keyboard is Shorted

I had a case today where the several pocket calculators turned on by itself and some of them even types a digit by itself.

another strange thing is the keyboard of the computer seems to keep the solid green light while the USB mouse seems to be unaffected by this strange scenario.

i transferred the cpu to another location and tested and it turned out fine. no hangs no keyboard anomaly or any of that.

then finally, somebody suggested that the monitor is the culprit. i changed the monitor and all is well.

the monitor is now relocated to the archives and this is quite an x-files episode i can tell you that.  life in the computer world just got it’s own taste of the paranormal. if somebody can explain it to me in layman’s terms i would really appreciate it. hahaha.

Coffee Cup

Welcome to our first blog post!

Hi and greetings from Basic Website Solutions. Welcome to the website. Get ready because we plan to provide helpful tips and comments from our daily walk in the world of software development and website design.

Aside from this we will also tackle the life of living in our time here in the Philippines.

We hope you enjoy your stay!

BWS Team