Re: [firebird-support] Re: Nbackup, Default I/O ON or OFF

2013-12-21 Thread Dmitry Kuzmenko
Hello, Dmitry! Saturday, December 21, 2013, 8:27:26 AM, you wrote: Also, as I see in nbak.cpp, -d option affects only diff file (delta), not database file. You can check functions BackupManager::openDelta BackupManager::setForcedWrites DY Wrong. The -D switch has nothing to do with the

[firebird-support] RE: Nbackup, Default I/O ON or OFF

2013-12-21 Thread atunccekic
I have the same thing while trying to delete. I get: Sorry, an error occurred while loading the content.

[firebird-support] RE: Nbackup, Default I/O ON or OFF

2013-12-21 Thread atunccekic
Dmitry K Dmitry Y, Thank you for the detailed information on nbackup file cache usage :)

Re: [firebird-support] What happens when nbackup fails

2013-12-21 Thread Alexey Kovyazin
Hi, Usually when nbackup fails you cannot merge delta file with main database. Sometimes database continue to work (and delta file grows), sometimes you cannot connect to database. In this case you need to contact IBSurgeon support for recovery - we have tools to fix it. It's pretty rare

[firebird-support] Problem with isc_service_attach

2013-12-21 Thread j.hector
I need to retrieve the connected users but can't get isc_service_attach to work in Fb2.5 - I have a set of api calls working with Firebird 1.5 api but am failing at the first hurdle with Firebird 2 service api. I am using Delhpi XE5, Firebird 2.5 64bit on Win 8.1 with the ibase.h from FB2.5

[firebird-support] Return Only One Row?

2013-12-21 Thread firebirddev firebirddev
Hello. I was wondering how do I limit the data set to only return a single row? So where a table would contain let us say 10 rows, I am only interested in the first row (I will order the data set prior to this). Thanks.

RE: [firebird-support] Return Only One Row?

2013-12-21 Thread Jerry Sands
SELECT FIRST 1 FieldName FROM Table You can change the 1 to any number if you want a different count From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of firebirddev firebirddev Sent: Saturday, December 21, 2013 2:24 PM To:

Re: [firebird-support] Return Only One Row?

2013-12-21 Thread W O
You have 2 ways: SELECT FIRST 1 MyColumns FROM MyTable That's the old way. SELECT MyColumns FROM MyTable ROWS 1 That's the new way. Greetings. Walter. On Sat, Dec 21, 2013 at 4:24 PM, firebirddev firebirddev firebird...@gmail.com wrote: Hello. I was wondering how