[firebird-support] problem - change smallint fields to boolean fields

[Nico Speleers - Carfac BVBA [e-mail] [firebird-support]]

Hello,


I want to change my smallint fields made in firebird 2.5.4 to boolean fields in firebird 3.0.1. Can someone give me an useful script or another solution ?
We work in an superserver model and our data access interface is FB Maestro 15.11.0.4.


Thanks in advance.


Nico Speleers
Analyst










Carfac bvba


Driving on experience




Rijksweg 53
9680 Maarkedal
Tel. [phone]
Fax [phone]
***@carfac.com
www.carfac.be<http://www.carfac.be/>
[cid:***@01D11613.C23F19C0]<Loading Image...@01D11613.C23F19C0]<http://www.linkedin.com/company/hdc-software-nv> [cid:***@01D11613.C23F19C0] <https://twitter.com/carfacbvba>


[Beschrijving: Beschrijving: Beschrijving: CarfacAS (klein)]<http://www.carfac.be/>










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

[Dimitry Sibiryakov [e-mail] [firebird-support]]

Post by Nico Speleers - Carfac BVBA ***@carfac.com [firebird-support]
I want to change my smallint fields made in firebird 2.5.4 to boolean fields in firebird
3.0.1. Can someone give me an useful script or another solution ?

Drop all dependencies, create a new field, update it to values from old field, drop old
field, rename new field, recreate dependencies.
--
WBR, SD.


------------------------------------

------------------------------------

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

Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.

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

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
------------------------------------

Yahoo Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-***@yahoogroups.com
firebird-support-***@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-***@yahoogroups.com

<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/