14.09.2016 7:36, John Tsioumpris ts.gian...@hotmail.com [firebird-support]
wrote:
> For various tasks like Database creation i need the *isql *command line
> utility so it
> would be great if i could include a copy of *isql *along with my Application .
MS ACCESS cannot execute "create databas
Hello to everybody.
I would like to know this thing.
I am developing an application that will use Ms Access as Front End and ODBC
driver for connecting to the Firebird Server.
For various tasks like Database creation i need the isql command line utility
so it would be great if i could inclu
You could create a denormalized field that contains the difference of those
values (updated by a trigger, perhaps), and you can put an index on that
new field. Then change the query to find rows where [new difference field]
< 0.
Make sense?
On Tue, Sep 13, 2016 at 9:37 AM Dimitry Sibiryakov s..
13.09.2016 15:26, Maya Opperman m...@omniaccounts.co.za [firebird-support]
wrote:
> Is there an index I could create to speed up the loading?
No.
--
WBR, SD.
Hi,
I have a large table, and I'm only extracting a few records using:
Select t.ID
>From my_table t
Where t.Invoiced < t.Received
Invoice and received are of type decimal(18,5)
IBExpert is reporting these as unindexed reads.
Is there an index I could create to speed up the loading?
Thanks in
On 13/09/16 11:09, jonatan.laurit...@yahoo.dk [firebird-support] wrote:
> I tried to create new topic in firebird-php but it is getting list, not
> visible. :((
On all the yahoo lists the fist posts are moderated. It's up now ...
--
Lester Caine - G8HFL
-
Contact - ht
13.09.2016 12:23, 'Djordje Radovanovic' softsis...@sbb.rs [firebird-support]
wrote:
> according to your plan I need to switch to firebird 3 as soon as possible.
You must check that index on partners.country is active and its statistic is
fresh. I
also hope that less than 60% of partners are
I am still using Firebird 2.5 and for same query my plan looks like this
PLAN JOIN (O NATURAL, P INDEX (PK_PARTNERS))
according to your plan I need to switch to firebird 3 as soon as possible.
Best regards,
Djordje Radovanovic
From: mailto:firebird-support@yahoogroups.com
Sent: Monday, Septe
I tried to create new topic in firebird-php but it is getting list, not
visible. :((
On 13/09/16 06:30, jonatan.laurit...@yahoo.dk [firebird-support] wrote:
> But it looks like from the Yii2 code that select and insert...returning
> is handled alike in the PHP Data Objects. Can it be possible that
> Firebird PDO driver deviates from the official PDO interface. Who
> develops pdo_fi
Hello jonatan.laurit...@yahoo.dk,
Tuesday, September 13, 2016, 5:30:28 PM, you wrote:
> But it looks like from the Yii2 code that select and
> insert...returning is handled alike in the PHP Data Objects. Can it
> be possible that Firebird PDO driver deviates from the official PDO
> interface. W
11 matches
Mail list logo
