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
country
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 several
fields of
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
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
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
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
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,
char by
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 Thu, Jul 12, 2012 at 9:33 AM, peixinhosdalua peixinhosda...@yahoo.comwrote:
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
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
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 Manuals
-- Original Message ---
From: K Z peixinhosda...@yahoo.com
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
-- Original Message ---
From: K Z peixinhosda...@yahoo.com
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,
-- Original Message ---
From: red_october2009 kevin.wendy.mor...@telus.net
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
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
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
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
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
18 matches
Mail list logo