Hi, Has anyone else experienced this? http://www.firebirdsql.org/download/prerelease/win32/Firebird-1.5.4.4890-0_RC1-Win32.exe I tried it twice and same access...
No I can not. THe floor and ceiling rounds down or up a number. The problem I have is to round only these to type of numbers where the fractional part equals...
Try this Select double_field - floor(double_field) from tablename This will give you the fractional part Select * from tablename Where double_field -...
... You can use WinExec or ShellExecute, just like you call any other application from Delphi. Or do you mean you want to redirect GSEC's output to your...
Hi Helen, Thans for your valuable suggestion. Can you please tell me the approach to modify the userId and password. I tried with GSEC, but I could not be able...
rambabu.piridi@...
Feb 1, 2007 8:45 am
83688
thanks adam, as you said, YEARDAY for a specific date will be different during leap years, so i can not use it. i thought that sql extract ( day or month or...
It looks like two emails got intermixed when flowing through internet ... ??? ... So, are the plans the same or different ? ... which points to bug "Bad plan...
... This one can't use index because it contains (:p_id IS NULL) which can't use index (since there is no table field), and can't be optimized at prepare time....
Peter, P> 'create database 'c:\risdev\rising3.fdb' user 'SYSDBA' password P> 'masterkey' PAGE_SIZE 4096;' P> Same thing... the server is running as a service -...
... They are different: I wasn't clear enough in saying that my *real* case is of course a little bit more convoluted than the one I sampled. In particular,...
lele@...
Feb 1, 2007 10:01 am
83694
... Plan is chosen during Prepare, i.e. when parameter values are unknown yet ... ... ... but if you prefer do use indexes always then it is pretty simple, try...
... Well, I could, but you still haven't given any info about the platform you are running on or which model of server (Classic/Superserver). ... You can't...
Hello, I'm wondering whether the 32 characters limit on stored procedure names still exists in firebird 2.0... The fb2 release notes has nothing to say on the...
Hi, ... 31 characters really, yes, it still exists. ... Nooo, you shouldn't, IMO. Makes development a pain. ... Be creative :-) At a company I worked for, we...
... characters ... Ew, does this problem _still_ exist? Tss tss ;) Does this apply to SQL grants? Martijn Tonies Database Workbench - development tool for...
No, not really. Maybe this is easier than expected, I have not yet tried, but calling gsec is not only invoking a program with params, it is calling gsec with...
Hi all, I'm not sure about hardware/sysop compatibility, so I ask your opinion. Can I install Firebird 1.53 for Windows 2003 server (32/64 version?) on a EM64T...
Hi Helen, The following are the environment details. OS: Windows XP Language: Java(j2sdk 5.0) Firebird:1.5.2 MappingTool: Ibatis. ServerName: Super Server ...
rambabu.piridi@...
Feb 1, 2007 12:29 pm
83703
You can pass GSEC all parameters at once so you don't have to enter interactive mode. Example: To modify a user's password: Change password of ELVIS to...
... Assuming you have the standard Firebird root filesystem: cd c:\Windows\Firebird\Firebird_1_5\bin To remove a user named ordinary (it is case-insensitive): ...
... Hi. (I will try and move discussion to firebird-devel...) Thanks for all the work you put in to docs by the way. (I just double checked the release...
Hi, Can anyone confirm if FB follows this SQL order of execution: (see http://www.bennadel.com/blog/70-SQL-Query-Order-of-Operations.htm and Celko 'SQL for...
... Booleans in the where clause that restrict the join operation are handled with the join... select a.f1, b.f1 from a join b where a.f1 = b.f2 should be just...
I seriously doubt Firebird is anything like ColdFusion in this area, Tom. My experience tells me that Firebird mixes several of these steps when preparing a...
Thanks to all that have responded to this post. These are some nice ideas that I will investigate further. I like the idea of having multiple instances of the...
