On 04 Sep 2014 13:31:14 -0700, doyc...@dsoft-bg.com [firebird-support]
firebird-support@yahoogroups.com wrote:
Yes background process is running to on same application server and uses
same data source.
I use EJB 2 and CPM for doing database operations.
App server is 4.2.3 and jaybird is
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 KEY
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
I'm tempted
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:
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 _).
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
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 that
On Fri, Sep 5, 2014 at 8:43 AM, Stefan Heymann li...@stefanheymann.de
[firebird-support] firebird-support@yahoogroups.com 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
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:
connection-factories
tx-connection-factory
jndi-namePowerProDS/jndi-name
xa-transaction/
track-connection-by-tx/
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
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
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
12 matches
Mail list logo