Re: [firebird-support] Re: Firebird Embedded open database file on network share

2015-01-22 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Jan 22, 2015, at 5:06 AM, ralf.erdm...@web.de [firebird-support] firebird-support@yahoogroups.com wrote: So I now know I had no good idea with the network share :-) I hope I made that clear :-) I thought it possible because I read that firebird embedded is at most the same engine

[firebird-support] Common Table Expressions (“WITH ... AS ... SELECT”)

2015-01-22 Thread masb...@za-management.com [firebird-support]
Hi to all, I am in the process of writing a list of entries with running costs in a quarter and all costs that have arsien since. So, I wrote a stored procedure with the mathematical logic for calculating the respective sums with different rates of exchange and some other rules. I made this

Re: [firebird-support] Re: Firebird Embedded open database file on network share

2015-01-22 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 22 Jan 2015 01:06:28 -0800, ralf.erdm...@web.de [firebird-support] firebird-support@yahoogroups.com wrote: Thanks Ann. So I now know I had no good idea with the network share :-) I thought it possible because I read that firebird embedded is at most the same engine as the firebird server.

Re: [firebird-support] Re: Unicode text in Exception?

2015-01-22 Thread 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support]
btw, in Firebird 3, the RDB$EXCEPTIONS.RDB$MESSAGE is still NONE. Oh bugger. Now, I tried the following in the procedure to work around the above: exception test _utf8 'unicode string here'; When I look at RDB$PROCEDURES.RDB$PROCEDURE_SOURCE I can see the text is inserted as a hex

Re: [firebird-support] Re: Firebird Embedded open database file on network share

2015-01-22 Thread ralf.erdm...@web.de [firebird-support]
Thanks Ann. So I now know I had no good idea with the network share :-) I thought it possible because I read that firebird embedded is at most the same engine as the firebird server. But obviously I didn't thought about such implications. Thanks to all who took time to help me, Ralf

Re: [firebird-support] Unlock record

2015-01-22 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
I looked in a database, and in MON$STATEMENTS tabla I have the following fields: MON$STATEMENT_ID MON$ATTACHMENT_ID MON$TRANSACTION_ID MON$STATE MON$TIMESTAMP MON$SQL_TEXT MON$STAT_ID How can I detect which is the record I have to delete to unlock my record? This is the only table I have to