RE: [firebird-support] Firebird Backups on Google Compute Engine

2017-03-27 Thread Rudi Feijó rudi.fe...@multidadosti.com.br [firebird-support]
>> We are considering moving our systems to GCE and trying to figure the best >> approach to backup our many firebird databases. >> Firebird is not VSS aware so we can't use shadow copying. > >Not completely true. > >1- Firebird uses careful write order, so a VSS snapshot should be a

[firebird-support] FBTrace: What are "dyn requests"

2017-03-27 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
FBTrace config supports the logging of "dyn requests", # Put dyn requests execute records log_dyn_requests false # Print dyn requests or not print_dyn false There is, however, no explanation of what these types of requests are -I don't recall "dyn requests"

[firebird-support] Re: Cursor FETCH in PSQL and ROW_COUNT/'fetch past last record' error

2017-03-27 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
27.03.2017 11:23, 'Martijn Tonies wrote: > > The FOR SELECT loop returns 1..10 as the values. > > The fetch/suspend lines return 1..10, with a row count of 1, and another > ‘10’ with a row count of 0. > > If I add another FETCH, I get this error while executing the routine: >>>attempt to fetch

Re: [firebird-support] reset sysdba password without loose existing users

2017-03-27 Thread 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support]
> Hi all, > > I need more help to archive this task. > > > I just copied the file flembed.dll and others in my directory(bin) > now i can connect to my database, with gsec or isql > > > but when i try to change de sysdba password in commande line, i got this > message : > > > SQL> alter

RE: [firebird-support] reset sysdba password without loose existing users

2017-03-27 Thread startx252...@yahoo.fr [firebird-support]
Hi all, I need more help to archive this task. I just copied the file flembed.dll and others in my directory(bin) now i can connect to my database, with gsec or isql but when i try to change de sysdba password in commande line, i got this message : SQL> alter user sysdba password

[firebird-support] Cursor FETCH in PSQL and ROW_COUNT/'fetch past last record' error

2017-03-27 Thread 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support]
Hi all, I’m unsure if this is an error or the intended behaviour. Got a simply table “dummy_rows_10”, single column, integer values 1..10 Next, this procedure: SET TERM ^^ ; CREATE OR ALTER PROCEDURE DEBUG_CURSOR_TESTS returns ( P_OUT1 TYPE OF COLUMN DUMMY_ROWS_10.V, RC Integer) AS