Hi Douglas! Assuming that VENDO.ID_PRODUTO is far more selective than VENDO.DATA when spanning half a year, the speed may increase if you change your query to ...
Yes! That's the way: thanks a lot... Paolo ... From: "Helen Borrie" <helebor@...> To: <firebird-support@yahoogroups.com> Sent: Wednesday, September 01,...
Paolo Sciarrini
p.sciarrini@...
Sep 1, 2004 7:13 am
47052
Ciao , we have a problem with the last version 1.5.1.4481 and our apps using the db Events. When someone shut down a client the firebird server goes up to 100%...
... Well, there are alot of documents refering to encrypting data into databases. One of the cleanest solutions is to do a hash on the values that you want to...
... By accident this the subject of my master thesis. The paper is pretty general marking some (certainly not all) risks to databases security. Also it lacks...
If you are referring to http://www.npk.com.mk, I just get an error when trying to access that page. If you mean http://riste.softver.org.mk/ then that page is...
I have just installed Mandrake Linux ver. 10.0 and tried to install latest version o firebird server (SS version) into this machine. It should create Firebird...
... That's interesting, because a fix was done in 1.5.1 to *fix* a problem that caused this phenomenon, which was evident in 1.5.0 and also present in Fb 1.0...
... That's my personal web page(in Macedonian) and it doesn't contain any specifics about database encryption. I only used my web space to upload the document...
Hi I have a stroed procedure returning sets of foreignkey values sp1(param1) returning id and another stored procdures returning greater sets of the same ...
Hi, ... I think you need to write: on SP1.ID = SP2.ID With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL ...
... Yes; but begin at the beginning...reply to both of these questions: 1. What is the exact file name of the kit that you installed from? 2. Have you read...
Am Wed, 01 Sep 2004 21:07:49 +1000 hat Helen Borrie <helebor@...> ... We have the same problem if the application and db - file is on the same machine ...
... Thank you, this is what I needed (actually if the fields are different I can use straight join ... on id1 = id2) and how to code such case from sp1(param1)...
... Sorry, I don't understand your question. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. ...
... Read the thread of yesterday, started by Russell Belding, with the subject "Firebird server is XP upgraded with SP2" and also follow up the link given by...
... Huh? Have you run out of Bamsemums already??? He's simply asking for how to do aliasing: from sp1(param1) a left join sp1(param2) b on a.id = b.id HTH, Set...
select ... from (select ...)thist feature will be implemented in Firebird 2.0 ou 3.0 ? [Non-text portions of this message have been removed]...
Douglas Dallacqua
vdallacqua@...
Sep 1, 2004 12:22 pm
47069
... 2.0 ou 3.0 ? I believe Derived Tables are to be supported in 2.0... With regards, Martijn Tonies Database Workbench - developer tool for InterBase,...
... Yes :-/ ... Well, didn't understand that... I thought he said my ... With regards, Martijn Tonies Database Workbench - developer tool for InterBase,...
Hi, 1. What's the use of Roles ? I can't seem to find any docs on this , and I haven't got/ordered HeLen's book yet :(. 2. I've made a Db to be installed at a...
... I did. I tested with RemoteAuxPort (exception port in firewall) and also with defining fbserver.exe as program exception but also with setting the firewall...
Hi, ... This link explains MS SQL Server 7 roles - which are different from Firebird. ... With Firebird, to make use of a role, you have to log in with the ...
... Roles are a way to package a bunch of SQL privileges. You create the role, then grant the required privs to the role, then grant the role to each user who...
