I have a report which has multiple datasets.
And I make use of a variable from on of the datasets into another.
Dataset customers:
Select id, name from customers
Dataset customer_sales (with master dataset = customers):
Select sale_id from sales where customer_id =:id
With the .net version of
On 05/09/2014 17:18, Ann Harrison aharri...@ibphoenix.com
[firebird-support] wrote:
> What's needed is a full-text index, which Firebird doesn't offer. Lucene
> and others produce full-text indexes that can be used with Firebird (I
> think, haven't tried it).
Apparently the Sphinx full-text s
CASHBOXID is already know. It is a reference to a table that we don't touch in
the transaction.
This table contains the current total amount of a cash box at the begging of
the day.
So when I try to load data for a cash box a java code checks is there record
for this cash box for current day.
I'm not sure it is locked table.
What I'm looking for is idea or advice how to find what the real problem is.
My data source definition is this:
PowerProDS
jaybird-2.1.6.rar
javax.sql.DataSource
localhost/3050:powerpro
sysdba
masterkey
UNICODE_FSS
1
On Fri, Sep 5, 2014 at 8:43 AM, Stefan Heymann li...@stefanheymann.de
[firebird-support] wrote:
> > I’m using Firebird 2.5.3, and I am looking for text in a emo field, eg.
> > I’m tempted to do something like
> > Select * from mytable t where lowercase(t.mymemo) like ‘%find me%’
> > but since t
> I’m using Firebird 2.5.3, and I am looking for text in a emo field, eg.
> I’m tempted to do something like
> Select * from mytable t where lowercase(t.mymemo) like ‘%find me%’
> but since this memo field could be enormous, I’m guessing that wold be
> horribly inefficient.
I use upper() for th
Thank you for all the suggestions
>hopefully, we're not talking about more than a few million rows in this
>table?...
I'd say definitely not more than a million, probably around 15000 for the
products tables, 5000 for the customer tables, and 100 000 for the jobs and
orders tables.
But, each
>>Select * from mytable t where t.mymemo like '%find me%'
>
>You can create a computed index for this:
>CREATE INDEX idxname ON mytable COMPUTED BY (lowercase(mymemo))
Such an index does not help for LIKE '%...', it can only be used if the first
character is a real character (i.e. not % or _). Mo
You can create a computed index for this:
CREATE INDEX idxname ON mytable COMPUTED BY (lowercase(mymemo))
Hope this help you.
De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Enviada em: sexta-feira, 5 de setembro de 2014 08:51
Para: firebird-support@yahoogro
>Hi,
>I'm using Firebird 2.5.3, and I am looking for text in a memo field, eg.
I take it you mean BLOB or VARCHAR, I've never heard of memo fields in Firebird?
>Select * from mytable t where t.mymemo like '%find me%'
>The will only find
>"find me"
>and not
>FIND ME or
>Find me or
>Find Me etc
>
>
Hi,
I'm using Firebird 2.5.3, and I am looking for text in a emo field, eg.
Select * from mytable t where t.mymemo like '%find me%'
The will only find
"find me"
and not
FIND ME or
Find me or
Find Me etc
I'm tempted to do something like
Select * from mytable t where lowercase(t.mymemo) like
Github model for contributions really works
There are quite a few pull requests closed and merged for .NET Provider
https://github.com/cincuranet/NETProvider/pulls?q=is%3Apr+is%3Aclosed
https://github.com/cincuranet/NETProvider/pulls?q=is%3Apr+is%3Aclosed
>This is the definition of the table that locks on insert:
>
>CREATE TABLE CASH_CASHBOX_DAY_AMMOUNT
>(
> CASHBOXID INTEGER NOT NULL,
> DATE_TIME NUMERIC( 18, 0) NOT NULL,
> AMMOUNTNUMERIC( 18, 0),
> CONSTRAINT PK_CASH_CASHBOX_DAY_AMMOUNT PRIMARY
13 matches
Mail list logo