Hi all. I'm trying to implement a stored procedure to perform updates on Debian Linux packaged FB1.5. Full text of procedure below: CREATE PROCEDURE...
... RETURNING_VALUES belongs to PSQL - it's how you bring back return values in variables when you execute one SP inside another. From a client, just call: ...
... as helen says - but just a note on logic, you are assuming the presence of id just because it's being passed to the procedure. A better logic would be to...
... Thanks for your suggestion. Unfortunately, we are already running Superserver with the CpuAffinityMask set to 1 in firebird.conf. Regards, Graham King...
Graham, ... Are you certain that all the backups are finished when you observe this behaviour? It might be one of your databases undergoing a large amount of...
... Yes the backups do complete. Our current setup is a simple Windows batch file which backs up all the databases in a given folder with GBAK. The Command...
... Sure, it is a Firebird support question, but is it a firebird-support question? I'd say that it is a firebird-general question. ... Thanks for good...
Hi My question is: When should varchar be used and when should text blobs be used. From Helens great book it seems that already around size 220 (as far as i ...
I was able to set up the test environment without much issues with the help of the document provided under the QA section. I ran the testcases and I found the...
hi To qoute Ann W. Harrison from an earlier post. "Yes, if you have the ID of the blob, you can read it without going through the table-based security. But...
... Thank you for the reply. As I noted - I tried this in ISQL already. I tried it again - same arithmetic exception. I tried running a select procedure from...
This is the text of a select procedure I have written to replace a view. It works - so I can continue doing this in this manner, particularly if this how I'm...
I need to calculate the weighted average for two fields (val1 and val2) using weight1. Zero values should be ignored. val1 val2 weight1 ... 5...
Francois du Toit
francois@...
Nov 1, 2004 3:22 pm
50096
Hi, sorry if this question has been asked before, but can anyone tell me where I can find help on using the licensing API with InterBase 7? The only...
... The syntax in your second statement is, unfortunately, not reasonable, since you are trying to select 3 fields in a select statement slot which is ...
... Thank you! That makes sense - even if I think it's unreasonable for an otherwise perfectly good parser to not be able figure that out <g>. Sheesh. Now...
... inline vs for select? there is no Vs here... what do you mean? inline versus join syntax.. there is a Vs here. I personally like inline selects because...
... You'd still have to have access to the database (as well as table access). If you have the physical file, then all bets are off anyway. I don't think this...
... From a performance point of view, first choice is a join. Second choice is nested FOR SELECT. Third choice is lots of subselects. The query optimizer...
... No, unfortunately, you don't need table access. You need a database user id and password, or equivalent, but then you can just probe with random values...
... It will depend on the data. SUM() conforms to the SQL standard and ignores nulls. It won't ignore zero unless you give it a suitable WHERE clause. Your...
Hi How do I have FB return ONLY the top 10 or top n of a select result. Perhaps that should be re-phrased as how do I have FB do something like... select...
Hi, I want to add another column in my table and it must be added as a primary key. The problem is, I have 2 columns that are currently the primary keys of my...
... SELECT FIRST 10 SALESMAN, SALES_QTY FROM EMPLOYEE ORDER BY 2 DESC It doesn't make sense to do a top/first query without an order by - otherwise the...
