Hello,
another hint. All table-filds which are read are indicated. Each call of the
stored procedure get one result, the pc-program delete the folder and report
it to the database (other stored procedure). .until there is no other folder
to delete.
Thanks.
Hello Set,
the picture-pa
Hello again,
for all users with the same "problem":
I have created an update-trigger:
AS
begin
if(new.status = 5) then
begin
if (not exists (select 1 from t_pictures where status < 5 and kd_id =
new.kd_id
and li_id = new.li_id)) then
update t_pictures set status =
Hi,
We have a number of clients who have quite large databases with pretty much all
the data in two tables, we perform a searching on these two tables with a join.
The database sizes go up to around 11GB, one issue we are experiencing is that
the query time can vary considerably, some times we
Den 2012-03-23 07:00 skrev Thomas Steinmaurer såhär:
>
> Hello Dmitry,
>
> >> OK, but I don't have the @M part.
> >
> > Your FB version is not 2.5 then.
> >
> >> Still wondering what the first figure after -h means.
> >
> > Socket handle this worker process is working with.
> >
> >> I've always tho
23.03.2012 13:36, Kjell Rilbe wrote:
>
>> FWIW: Simple test case on a freshly restarted Win 7 with FB 2.5.2
>> Snapshot 64-bit Classic running as a service. While the first two get
>> unique socket handles, the third is already duplicated. According to
>> Process Explorer, I end up with the followi
> We have a number of clients who have quite large databases with pretty much
> all the data in two tables, we perform a searching on these two tables with a
> join.
>
> The database sizes go up to around 11GB, one issue we are experiencing is
> that the query time can vary considerably, some ti
Den 2012-03-22 20:51 skrev Kjell Rilbe såhär:
>
> Helen Borrie skriver:
> >
> > The Guardian should not be installed at all for Classic.[snip long
> > informative text]
> >
>
> Many thanks Helen! And here I was, thinking I knew what the guardian was
> all about... :-)
>
For the record, the guardia
Hello,
We have a table where user can do classic search against different field
select
...
from
tableA
where
field1>n and
field2=i;
now i want to permit user to also filter by keyword
something like
select
...
from
tableA
where
field1>n and
field2=i and
(FieldVarch
That's great, thanks for all the information. We'll go through it all.
Toby
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Thomas Steinmaurer
Sent: 23 March 2012 09:55
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Database set
Test with
select
...
from
tableA t
where
t. || :NameFile1 || like %'' || :keyword1 || %'' or t. || :NameFile2 || like
%'' || :keyword || %''
Best Regards
=
|| ISMAEL ||
=
- Original Message -
From: nathanelrick
To: firebird-support@yahoogroups.com
Sent: Fri
thanks but i don't want to do a full table scan :) i want to use indexed search
of course
[[firebird-support] How to do a full text search ?]
nathanelrick schrieb am 23.03.2012 um 14:12 (-):
> now i want to permit user to also filter by keyword
> something like
> (FieldVarcharDescr like '%Keyword1%' or FieldVarcharDescr like '%Keyword2%')
Not sure what you're asking. This is a f
12 matches
Mail list logo