K Z schrieb am 12.07.2012 um 09:17 (-0700):
>
> Does anyone knows where i can find a full reference manual of the
> FB2.5?
Full FB manual for version X.Y = IB 6.0 manual + FB update for X.Y
> http://www.firebirdsql.org/en/reference-manuals/ (Reference Manuals
> and the InterBase 6.0 Manuals Lang
I am trying to connect to a firebird database on another computer. I
keep getting the reply, "Your user and password are not defined..." With
IB there were two separate authentication systems when connecting to a
remote database. For windows systems it used a user database maintained
through gs
Hello,
I issue the following command:
alter character set utf8 set default collation unicode_ci_ai
Now i need your help to make a case sensitive comparative like this:
select * from USERS where password='wOrD';
Currently, with this collation the where clause ignores the case of the
characters.
Very interesting!
Is it possible to make a output of the variable this_query to view if all newly
formed variable is correct? Something like a send_to_log()
send_to_log(this_query);
for execute statement :this_query into :a, :b, :c, ..., :z do
suspend;
end
thank you
And Ive just found the Interbase 6 API guide and it seems like im looking to
work with the isc_service_* functions. Any inputs welcomed, but it seems like
I've got the right direction. Now a lot of learning / understanding to do.
--- In firebird-support@yahoogroups.com, Danie van Eeden
wrote:
Hey again,
I've done some digging in the zeos source / exported dll functions of
fdbclient.dll.
Could you perhaps indicate
a) are the services API functions also exported from fdbclient
b) if so, could you perhaps indicate an example function name. I need
some direction as to which functions ref
-- Original Message ---
From: "red_october2009"
> I have the following statement:
>
> SELECT
> f.PAR_GUID,
> MAX(DATEDIFF(DAY, f.EVT_DT + f.EXP_RSP_DYS, CURRENT_DATE))
> FROM
> JET_LTR f
> WHERE
> (f.EXP_RSP_DYS > -1) AND
> (f.RSP_RCVD_DT IS NULL) AND
> (DATEDIFF(DAY,
-- Original Message ---
From: K Z
> How can i force a failure of a write operation from inside a TRIGGER?
> For example, a TRIGGER for a INSERT INTO operation. Inside the TRIGGER
> i will have a IF condition and if necessary, i want to cause a failure,
> canceling the INSERT INT
-- Original Message ---
From: K Z
> Is there a way to make something like this:
> query="where ID=10 and AGE >20";
> select * from TABLE :query;
--- End of Original Message ---
create procedure filtered_select (/* parameters, preferably NOT just a text
version of your WHE
On 07/12/2012 06:17 PM, K Z wrote:
> Hello,
>
>
> Does anyone knows where i can find a full reference manual of the
> FB2.5?
>
> For example, i tried to search the command SOUNDEX in the FB site and
> inside the documents mentioned at
> http://www.firebirdsql.org/en/reference-manuals/ (Reference Ma
Hello,
Does anyone knows where i can find a full reference manual of the FB2.5?
For example, i tried to search the command SOUNDEX in the FB site and inside
the documents mentioned at http://www.firebirdsql.org/en/reference-manuals/
(Reference Manuals and the InterBase 6.0 Manuals Language Ref
On 07/12/2012 03:17 PM, peixinhosdalua wrote:
> Regarding your suggestions, i need to make a search by '%word%' not 'word%'.
> For example, most companies have a commercial name or brand that they use and
> these are different from the juridic name. It is the juridic name that is
> inserted in
On Thu, Jul 12, 2012 at 9:33 AM, peixinhosdalua wrote:
>
> In this case, the goal is to make '%word%' not 'word%'. In understand your
> suggestion but it is not what i need to achieve.
>
Firebird cannot use an index on partial word matches unless it knows the
initial characters, so your queries a
Hello,
How can i force a failure of a write operation from inside a TRIGGER? For
example, a TRIGGER for a INSERT INTO operation. Inside the TRIGGER i will have
a IF condition and if necessary, i want to cause a failure, canceling the
INSERT INTO operation itself. Is this possible?
Thank you.
On 12-7-2012 16:24, Tupy... nambá wrote:
>
>
> Caro "peixinhosdalua",
>
> There is no way to increase such kind of searches in a database, because
> the searches are made line per line, searching inside each line by the
> occurrence of your needed search by displacement of the searching word,
Caro "peixinhosdalua",
There is no way to increase such kind of searches in a database, because the
searches are made line per line, searching inside each line by the occurrence
of your needed search by displacement of the searching word, char by char.
You are right that such kind of sear
Forgot the view!
First task is rewrite the sql only for clientes table.
Try it first and you will not a much better performance.
Next step join the other tables but not using a view.
Finally if it continue slow try changuing your sql to:
Where (clientes.name like 'test%' or clients.name like '%test
I have the following statement:
SELECT
f.PAR_GUID,
MAX(DATEDIFF(DAY, f.EVT_DT + f.EXP_RSP_DYS, CURRENT_DATE))
FROM
JET_LTR f
WHERE
(f.EXP_RSP_DYS > -1) AND
(f.RSP_RCVD_DT IS NULL) AND
(DATEDIFF(DAY, f.EVT_DT + f.EXP_RSP_DYS, CURRENT_DATE) >
f.EXP_RSP_DYS)
GROUP BY 1
The DB is inacti
Just for curiosity, i tried this having only 1000 records instead of 3553 in
the tables CLIENTES. :
select first 20 * from LISTA_CLIENTES where (CLIENTE like 'crist%'
or MORADA like 'crist%' or LOCALIDADE like 'crist%' or CLIENTE like
'crist%' or PAIS like 'crist%' or PAIS_NOME like 'crist%'
Hello,
In this case, the goal is to make '%word%' not 'word%'. In understand your
suggestion but it is not what i need to achieve.
QUESTION: Interesting, why do you have ORDER BY in the view definition? I view
views as 'virtual tables', and tables have no inherent ordering.
ANSWER: because i read in FB webpage that moving the order by to inside the
VIEW or procedures it optimizes and speeds up things.
QUESTION: How many re
Hello,
Is there a way to make something like this:
query="where ID=10 and AGE >20";
select * from TABLE :query;
Thank you.
[Non-text portions of this message have been removed]
Hello,
I made a few query to count the time. I tried with the CLIENTES having 3553
records and with 1000 records. The changes in time performance is significant!
Note that now i am not testing with the VIEW (so not having any joined tabled).
30 SEG (3553 records) 9 SEG (1000 records) (with the
On 7/11/2012 9:48 PM, Alexandre Benson Smith wrote:
>
> Em 11/7/2012 14:23, K Z escreveu:
> >
> > Hello,
> >
> > I'm still far from a expert on firebird and sql. If someone can help
> me to improve this code, i will be grateful.
> >
> > 1) GOAL: I need to make a search for a partial word in severa
>I'm still far from a expert on firebird and sql. If someone can help me to
>improve this code, i will be grateful.
>
>1) GOAL: I need to make a search for a partial word in several fields of the
>customers table.
>
>2) STRUCTURE: I am using a view because i join the customers table with the
>
25 matches
Mail list logo
