{"id":30,"date":"2017-04-07T01:40:53","date_gmt":"2017-04-07T01:40:53","guid":{"rendered":"http:\/\/basicwebsitesolutions.com\/blog\/?p=30"},"modified":"2017-04-07T02:29:40","modified_gmt":"2017-04-07T02:29:40","slug":"general-sql-error-invalid-transaction-handle-expecting-explicit-transaction-start","status":"publish","type":"post","link":"https:\/\/basicwebsitesolutions.com\/blog\/2017\/04\/07\/general-sql-error-invalid-transaction-handle-expecting-explicit-transaction-start\/","title":{"rendered":"Delphi \/ Interbase : General SQL Error invalid transaction handle (expecting explicit transaction start)"},"content":{"rendered":"<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-33\" src=\"http:\/\/basicwebsitesolutions.com\/blog\/wp-content\/uploads\/2017\/04\/20170407-CSI-ERROR-EXPORT-TO-SI-300x114.jpg\" alt=\"\" width=\"300\" height=\"114\" srcset=\"https:\/\/basicwebsitesolutions.com\/blog\/wp-content\/uploads\/2017\/04\/20170407-CSI-ERROR-EXPORT-TO-SI-300x114.jpg 300w, https:\/\/basicwebsitesolutions.com\/blog\/wp-content\/uploads\/2017\/04\/20170407-CSI-ERROR-EXPORT-TO-SI.jpg 435w\" sizes=\"auto, (max-width: 300px) 100vw, 300px\" \/><\/p>\n<p>i have using delphi 6 for quite some time now and it seems that errors of the past still haunt us today.<\/p>\n<p>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.<\/p>\n<p>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.<\/p>\n<p>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&#8230; except outside the storedproc procedure and everything went into place.<\/p>\n<p>hope this article can help somebody in the same pickle jar as me.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/basicwebsitesolutions.com\/blog\/2017\/04\/07\/general-sql-error-invalid-transaction-handle-expecting-explicit-transaction-start\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Delphi \/ Interbase : General SQL Error invalid transaction handle (expecting explicit transaction start)&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,1],"tags":[29,30,28,26,10,27],"class_list":["post-30","post","type-post","status-publish","format-standard","hentry","category-delphi-and-interbase","category-life-as-a-programmer","tag-expecting","tag-explicit","tag-handle","tag-invalid","tag-start","tag-transaction"],"_links":{"self":[{"href":"https:\/\/basicwebsitesolutions.com\/blog\/wp-json\/wp\/v2\/posts\/30","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/basicwebsitesolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/basicwebsitesolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/basicwebsitesolutions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/basicwebsitesolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=30"}],"version-history":[{"count":3,"href":"https:\/\/basicwebsitesolutions.com\/blog\/wp-json\/wp\/v2\/posts\/30\/revisions"}],"predecessor-version":[{"id":34,"href":"https:\/\/basicwebsitesolutions.com\/blog\/wp-json\/wp\/v2\/posts\/30\/revisions\/34"}],"wp:attachment":[{"href":"https:\/\/basicwebsitesolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=30"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/basicwebsitesolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=30"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/basicwebsitesolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=30"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}