Category: Delphi and Interbase

Delphi, a product of pascal has been taught in schools before. Its more user friendly in terms of coding and logic. We love it and want to share some of the tools of the trade. So expect a lot of code snippets.

Posted on

Interbase Error : Internal gds software consistency check (invalid block type encountered (147))

Interbase Error : Internal gds software consistency check (invalid block type encountered (147))

This is an interbase database issue that had haunted me for quite some time. Its a bit big table with aroun 120 tables and 120 generators. For the storeprocs, i would guess a around 300 plus.

After adding another generator this error occurs. I kept reading about the structure not sound and that the links and triggers are overlapping.

But after around 2 months of tip toeing around, i read an article about page sizes. It mentions of a theory that if it is a massive big project, make the page size bigger. From the start i have been using 1024 page size But after making it into 4096,

So that’s it. Hope it helps people out there with the same issue as mine.

Coffee Cup

Posted on

What TCP port does InterBase use?

Before it was like clockwork, this port is no mystery to me. But recently, especially today, i had to write it down somethere.

I guess this comes with age.

Magic interbase port is 3050. This must be both in the INCOMING and OUTGOING windows firewall settings.

Coffee Cup

Posted on

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.