Dear all, I apologize if this is considered RTFM, but I ran into the following item on the knowledgeBase at ibphoenix.com: ... Question: How do I create a...
Hi, ... SPs are precompiled and Views are prepared each time you use them. I use views when I know that a certain query will be used multiple times in my...
Hi, After working in SqlServer and Oracle, Some concepts are mixed in my mind. In Interbase when i especify a PRIMARY Key,Is an index created Automatically? ...
... Yes. ... Yes. But you should not create a UNIQUE clause that duplicates the primary key. Also, you should not create any indexes using CREATE INDEX, which...
... Probably most people here don't have the postgreSQL documentation. What is it that you need, that isn't documented in the OpGuide? ... Does that mean...
... Update within stored procedure returning values you need Best regards, Kubanych...
Kubanych Tajmamat uloo
kubanych@...
Jan 2, 2003 3:01 am
20009
Hi, I want to use a "Select List" as Select-Param for a Stored Procedure. ... BEGIN FOR SELECT RELID AS VID From DIRECTORYTABLE WHERE (RELID in (Value1,...
Hi Nils, ... This isn't possible :-/ With regards, Martijn Tonies InterBase Workbench - the developer tool for InterBase & Firebird Firebird Workbench - the...
... That has plusses and minuses. Because the stored procedure is compiled as a unit, no optimization is available between the tables it references and any...
... Thank you for the clarification. This is new information for me. ... Yes, I read about this in an article by Ann Harrison on the ibphoenix site recently....
looking at the jaybird or .net driver source might be your best bet. These both talk to the server w/o client libriaries. I don't know if the .net stuff...
L.S. I'm running firebird on a Debian Linux system with PHP-4.2.3 and Apache 1.3.27 Right now we have a lot of visitors, and the webpages load realy slow. It's...
hi folks, We are (finally!) moving our firebird 0.94 databases to 1.02. I have read the 1.02 releae notes and combed the lsit archives, and it appears the only...
... What I would do is write the one procedure to get the value you need. Then write another procedure that calls the first procedure that returns the value...
Use connection pooling. ... -- Thomas Miller Delphi Client/Server Certified Developer BSS Accounting & Distribution Software BSS Enterprise Accounting...
Check out recent messages under heading "version 1.0.2 destroys isc4.gdb", decide whether that's an issue for you or not. Bert Hughes ... From: Rob Schuff...
FWIW to those folks using Linux + FB, I've been using 1.0.2 in spite of the isc4 issue, for a little over a week, several 100 thousand inserts, tens of ...
Bert Hughes
b.hughes@...
Jan 2, 2003 8:26 pm
20024
the enclosed trigger does not work as expected. At times, it causes a "multiple rows from singleton select" error. I investigated the problem and found the...
... The JayBird group has done this, as has Net-Provider. However, I really don't recommend replacing the client as an alternative to porting it. The...
... Each of those alternative will perform the calculation each time you reference the computed value. If you need the computed value often and change the...
... That's because sometimes select returns only one row. ... this select might return mulitple rows, and then you get the error. HTH -- Milan Babuskov ...
Hi to everyone. In commercial products as EMS QuickDesk or IBAdmin there is a tool called Grant Manager, where one can set roles and assign users to that...
Hi, ... Grant Manager, where one can set roles and assign users to that roles. I ... GetRolesOfUser(User: String): TStrings? Check the Language Reference,...
... Yes, the answer was in Table RDB$USER_PRIVILEGES. If one user is assigned to a role then that user will appear in field RDB$USER and the role name in...
... like ... RDB$USER and the role name in RDB$RELATION_NAME. Is this true? ... Experiment a little yourself - the RDB$PRIVILEGE columns holds 'M' -> member ...
