OK Alam,

I'll try to detect the firebird version into my software and not allow
the execution of my software if the client or server version of Firebird
is incorrectly.
My major concern if my software run on a incorrectly configuration I can
have serious problems with the database where I can lost informations.

Thanks again

Fabrício F. Kammer

-----Mensagem original-----
De: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] Em nome de Adam
Enviada em: quinta-feira, 5 de janeiro de 2006 20:18
Para: firebird-support@yahoogroups.com
Assunto: [firebird-support] Re: Migrating from FB 1.0 to FB 1.5


--- In firebird-support@yahoogroups.com, Fabrício Fadel Kammer
<ffkammer@c...> wrote:

>
> Hi all,
>
> I've a software that works with Firebird 1.0 and I'm needing to
> migrating to 1.5, because I need of some functions available only in

FB

> 1.5 version. But I've a lot of customers that using my software and

I'm

> afraid to update my software with a new version that use Firebird 1.5
> and my tecnicals don't update the Firebird Server and Client on the
> machines of my customers... What will happen???

Obviously any new feature of 1.5 will give an error if you try and use
it against the 1.0 engine. It is possible that your error message
codes may be different and you may get some odd error messages if you
upgrade the client but not the server.

> How can I prevent
> this??? And what's is the best form to do the migration from FB 1.0 to
> 1.5???

Firstly, you must ensure you do not use ambiguous queries that 1.0
accepts but 1.5 will return errors. For example

select id
from table1 t1
join table 2 t2 on (t1.id = t2.table1id)

will return (something) in FB 1.0 but will be rejected by FB 1.5 as
ambiguous if ID is a field in both tables.

In other words, FB 1.5 may not accept some poorly written queries (as
seen above).

As for your second concern, it is really a non issue. When upgrading
your software, instruct the technical staff (in writing!) that part of
the upgrade procedure is to remove 1.0 and install 1.5, you may need
to write step by step instructions. As far as upgrading the client,
well all you need to do is put the new fbclient / gds32 dll (depending
on your connection components) in with your new binaries and presto.

I doubt the sky will fall in if you mismatch versions, just some
annoyed customers who get some error dialog box saying "undefined
function coalesce" or something like that.

Adam






++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++





SPONSORED LINKS
Technical
<http://groups.yahoo.com/gads?t=ms&k=Technical+support&w1=Technical+supp
ort&w2=Computer+technical+support&w3=Compaq+computer+technical+support&w
4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w6=Micro
soft+technical+support&c=6&s=196&.sig=-XIO8GxY6hqd3NaD5WSEyw> support
Computer
<http://groups.yahoo.com/gads?t=ms&k=Computer+technical+support&w1=Techn
ical+support&w2=Computer+technical+support&w3=Compaq+computer+technical+
support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support
&w6=Microsoft+technical+support&c=6&s=196&.sig=B29J78SYXnNTjjMFBMznqA>
technical support Compaq
<http://groups.yahoo.com/gads?t=ms&k=Compaq+computer+technical+support&w
1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+tec
hnical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+
support&w6=Microsoft+technical+support&c=6&s=196&.sig=7_je1A94xs82CFXUjE
qA6g> computer technical support
Compaq
<http://groups.yahoo.com/gads?t=ms&k=Compaq+technical+support&w1=Technic
al+support&w2=Computer+technical+support&w3=Compaq+computer+technical+su
pport&w4=Compaq+technical+support&w5=Hewlett+packard+technical+support&w
6=Microsoft+technical+support&c=6&s=196&.sig=2zMAuRCo5cJrVBr1Bxa3_w>
technical support Hewlett
<http://groups.yahoo.com/gads?t=ms&k=Hewlett+packard+technical+support&w
1=Technical+support&w2=Computer+technical+support&w3=Compaq+computer+tec
hnical+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+
support&w6=Microsoft+technical+support&c=6&s=196&.sig=_ytYU7aXb57AVaeUfm
vLcA> packard technical support Microsoft
<http://groups.yahoo.com/gads?t=ms&k=Microsoft+technical+support&w1=Tech
nical+support&w2=Computer+technical+support&w3=Compaq+computer+technical
+support&w4=Compaq+technical+support&w5=Hewlett+packard+technical+suppor
t&w6=Microsoft+technical+support&c=6&s=196&.sig=4hRo6NXYavRAbTkaYec5Lw>
technical support

_____

YAHOO! GROUPS LINKS



* Visit your group "firebird-support
<http://groups.yahoo.com/group/firebird-support> " on the web.


* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe

>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service <http://docs.yahoo.com/info/terms/> .


_____




[Non-text portions of this message have been removed]