[fpc-pascal] Embedded firebird test program was: Firebird stored procedure exceptions generate access violation

[Jim]

On 6-6-2010 16:06, Michael Van Canneyt wrote:
>> (gdb) break fpc_raiseexception
>> Breakpoint 1 at 0x40a9c6
>> ...... debug output....
>> Breakpoint 1, 0x0040a9c6 in fpc_raiseexception ()
>> (gdb) backtrace
>> #0  0x0040a9c6 in fpc_raiseexception ()
>> #1  0x0043d284 in
>> IBCONNECTION_TIBCONNECTION_$__CHECKERROR$ANSISTRING$PISC_STATUS ()
> 
> OK, this means you've found an error in the error handling code of
> TIBConnection. Unfortunately, there is not enough info to pinpoint the
> exact
> location.
> 
> Do you think you can recompile the ibconnection unit with debug info ?
> (copying to to your project's directory should do the trick)
> 
> Michael.

Hi all,

Recap: accessing Firebird database with custom (Firebird) exceptions, it
seems the FPC code crashes on hitting the exception.

Michael Van Canneyt helped me to debug the issues, but I got lost in the
complexity, so decided to write a simple Windows32 test program with
embedded Firebird test program with custom Firebird exceptions.

I've attempted to compile the ibconnection, sqldb etc units with
debugging (-g -gl -gh) and added them to the directory.

Also added the entire Firebird 2.1 embedded environment, and a test
database; you can test it with the included isql.exe.

Details in fbembedtest_readme.txt

Compile/test script in compileandtest.bat

I've uploaded it to:
http://bitbucket.org/jb/flocate/issue/5/cant-get-embedded-firebird-to-work
the latest attachment is
fbembedtest16June_10.52.zip

Possibly due to my newbie-ness, I can't get embedded Firebird to work;
the connection attempt crashes with another access violation.

Could some kind soul look at it and:
1. Tell me what I'm doing wrong
2. Tell me if there's any documentation on embedded Firebird, and where
I can find it.
3. Help me in testing out these custom Firebird exceptions - what I was
trying to do in the first place...

Thanks!

jb