... same ... output ... would ... Why? Can you explain that? Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle & MS SQL...
It does seem a little sub-optimal. Have you tried a few different combinations of flags? without the -v to keep verbosity down With the -t to change the output...
... No, not really. But there's an intrinsic problem with the logic of putting that SELECT FIRST 1 inside a FOR loop. Theoretically, if the set from which...
... Could be me, but that sounds like a bug or you're wrong. SELECT [FIRST] returns a resultset, which is handled by the FOR loop. Why this should "return the...
... I have tried the following combination and it doesn't work: 1. gbak -b acc-0007.fdb c:\temp\a.gbk 2. gbak -b -t acc-0007.fdb c:\temp\a.gbk 3. gbak -b...
Hello, I am just beginning to work on Firebird 2.0 and have also just joined this group. Thus I couldn't participate directly to the yesterday thread about it....
hi i have an (after-update) trigger which looks like the following: update dicentries set asdskrpt1 = new.asdskrpt1 where asverwid = new.id; it works fine...
... the select first statement is not IN the FOR loop - it DEFINES the LOOP. The LOOP ceases at the extent of the select, i.e. at the first record selected. So...
Try gbak with the -g option. Regards Peter ________________________________ From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On...
Hello Hubert, ... You don't "need" double quotes, if your identifiers aren't reserved words. If so, or if you want to make them case sensitive, you do need...
Hi folks!!! Has anybody tried to use Firebird in a Rails application??? I'm note sure that FireRuby is the best Firebird adapter available. If anybody has a...
... Thanks for your reply, Alan. I suspect you are correct, however I found the problem in the end. It was not specifically in this stored procedure after...
Forgive my naivety, but I have a statement like so: update collection COL set COL.disp_browse = 'N' where COL.user_no = (select u.user_no from user_account u...
Hello Myles, ... So, you want all COLLECTION records updated for any COL.USER_NO in the select? that use: WHERE COL.USER_NO IN (SELECT ... Martijn Tonies ...
update collection COL set COL.disp_browse = 'N' where COL.user_no IN (select u.user_no from user_account u where u.expire_date = cast('NOW' as date));...
could you go into more detail over this, one of my current projects has a lot of SP code written with "select first ... ", what magnitude of difference will it...
update collection COL set COL.disp_browse = 'N' where COL.user_no in (select u.user_no from user_account u where u.expire_date = cast('NOW' as date)); use in...
... The OP actually libfbembed, not fbembed.dll. If by fbemebed you mean embedded on unix, then you're using classic, which isn't thread safe. I believe you...
Hello All, Apologies if this has been covered before, google isn't getting me very far. I'd like to be able to select rows in firebird 1.5.3 that contain ...
... Nothing you do to gbak is going to affect the amount of physical memory the server is using, or the amount of space the operating system allocates for its...
... Hi, I had a brief look on it some months ago, and used the FireRuby adapter, don't know any other :-( The last weekend I was on a Ruby on Rails conference...
This is a query inside of a stored procedure. The COALESCE fields are because the SP needs to ignore that field if the caller passes in NULL. The problem is...
Rick Debay
rdebay@...
Nov 1, 2006 6:31 pm
80724
Hi there, my issue involves these elements: - Firebird 2.0 SS RC3 - Server single processor Pentium 4 class, don't know if Intel or AMD, with enough RAM -...
I have a Firebird DB with remote clients connecting via TCP/IP. The clients use ADO.NET In the DB, there is a SP which is similar to: SELECT f1, f2 FROM T1 FOR...
Hmm, excepting that I'm a bit uncertain about colons in stored procedures (I code too few), your logic seems correct to me. Hence, I would guess that NEWONLY...
Arrgghh! Adding your line to the query that was sitting there in the original test window: SELECT pbm.ID, pbm.GROUPID, pbm.RSPPATPAY, pbm.RSPDUEAMT,...
Rick Debay
rdebay@...
Nov 1, 2006 10:21 pm
80728
... This is not valid. It looks like you forgot the 'update table' logic. ... I am not sure what would be wrong with the original statement. Perhaps you could...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
