We have a client that is trying to integrate software. Their questions are:
Do you know whether escaped aliases are supported in Firebird?
In MSSQL for example you can SELECT column AS [column name]. The "column name"
can contain spaces and be named a reserved word because it's escaped with the
Michal,
>
> The OAT moves freely, it's really just the OIT that is blocked. I still
> don't understand why it stops just because of database restore (only
> through nbackup, gbak is ok), but if it's not going to cause a performance
> penalty, it's not an important issue.
>
>
As Sean said, gbak an
Michal,
> --- In firebird-support@yahoogroups.com, Ann Harrison
> wrote:
> > >
> > > The Oldest Interesting Transaction (OIT) is the oldest transaction
> > > in the
> > system that is not committed. Ordinarily, that's a transaction that
> > rolled back and could not be cleaned up automatically.
Of course you can use a foot to kill an ant, or a rock, or a nuclear bomb
I'm pretty sure for the actual application and future use, is not a risk, and
even in case of an eventually error, any nuclear missil will be fired by
mistake ;)
It's only a database for an store, with multiple users,
I'm also quite of this... (developer ;))
And the project is safe in this way, believe me, after more than 8 years with
this sequence, no one customer has reported problem (may be some time has
occurred) and the simplicity and speed deserve this really little risk (if some
error is reported, the
I would also strongly advise against this design. It is a design for
failure. Not immediate failure but eventual failure.
On Wed, Apr 17, 2013 at 8:12 AM, chris.waldmann <
christian.waldm...@rte-ag.ch> wrote:
> As a senior software and database developer, this is my experience:
>
> If anything ca
As a senior software and database developer, this is my experience:
If anything can go wrong, it will! also known as "Murphy's law"
Happy coding
Christian
--- In firebird-support@yahoogroups.com, "skander_sp" wrote:
>
> Is not a problem the concurrence, because this specifica case, only a dozen
Thks, is a great appendix for all the prior messages,
And is definetively the explanation and solution.
Tks very much
--- In firebird-support@yahoogroups.com, Christian Mereles
wrote:
>
> Ok, some querys:
>
> 1 - No index:
>
> select coalesce(max(o.N_ORDEN), 0) + 1 from ORDENES O
> where
LOL, nice try,... and really pretty curious, they "seems" works,
but don't do in this way.
May be you must remember in strings "9" is higher than "80"
then for a (tricky) aproach to working way...
CREATE DESCENDING INDEX ix_ordenes_produccion_orden ON ordenes_produccion
COMPUTED BY (cast(eje
You can design your own index, as you consideration for the pourpose.
I'll try it
--- In firebird-support@yahoogroups.com, fabianoaspro@... wrote:
>
> This index uk_... Is the descending one?
> Give-me the ddl of this index.
> Em 16/04/2013 13:06, "skander_sp" escreveu:
>
> > **
> >
> >
> > the
Is not a problem the concurrence, because this specifica case, only a dozen of
user working toghether and not probably they insert in the same milisecond, but
thks for the notice.
And about the optimized index, I finally undestand, but i hope to get a instant
result for last year (actually only
On Wed, 17 Apr 2013 07:52:47 -
"un_spoken" wrote:
> We have few hundred of clients and each client is using database with
> the same structure. How should we do the conversion? What is your
> exeprience with this? Can it be done automatically? What tools could
> you recommend?
fbclone [1] re
--- In firebird-support@yahoogroups.com, Ann Harrison wrote:
> >
> > The Oldest Interesting Transaction (OIT) is the oldest transaction in the
> system that is not committed. Ordinarily, that's a transaction that rolled
> back and could not be cleaned up automatically. Only sweep can change
We have few hundred of clients and each client is using database with the same
structure. How should we do the conversion? What is your exeprience with this?
Can it be done automatically? What tools could you recommend?
Thanks.
14 matches
Mail list logo
