Re: [firebird-support] How To Change Column DataType From Varchar To Integer ?

2015-04-22 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
At 11:41 p.m. 22/04/2015, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] wrote: If I make all values to null of that column which is of type varchar and then go for Alter, would you share the sql for it ? Changing the values to null does not change the data type of the column.

Re: [firebird-support] How To Change Column DataType From Varchar To Integer ?

2015-04-22 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On Wed, 22 Apr 2015 05:38:39 + (UTC), Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] firebird-support@yahoogroups.com wrote: Hi All, I have a Table called Table1, in that I have a column called Status which is of type Varchar and contains values link '1', '2', '3' etc, i.e. all

Re: [firebird-support] How To Change Column DataType From Varchar To Integer ?

2015-04-22 Thread Tim Ward t...@telensa.com [firebird-support]
On 22/04/2015 09:26, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: Create a new column, assign/convert the values from the old column, drop the old column, rename the new column (optional). ... and sort out, manually, however many hundreds of dependencies you have (triggers,

Re: [firebird-support] How To Change Column DataType From Varchar To Integer ?

2015-04-22 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On Wed, 22 Apr 2015 09:28:09 +0100, Tim Ward t...@telensa.com [firebird-support] firebird-support@yahoogroups.com wrote: On 22/04/2015 09:26, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] wrote: Create a new column, assign/convert the values from the old column, drop the old column,

[firebird-support] Dussen failures to access to the embedded database

2015-04-22 Thread Wolfgang Janz wolfgang.j...@exxcellent.de [firebird-support]
Hi, we are recently getting an error when using * firebird (embedded) 2.5.3 * firebird client 4.5.2 * Windows 7 x64 * Nhibernate (.Net) Here is the stacktrace: FirebirdSql.Data.FirebirdClient.FbException: operating system directive CreateFile failed ---

Re: [firebird-support] How To Change Column DataType From Varchar To Integer ?

2015-04-22 Thread Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]
If I make all values to null of that column which is of type varchar and then go for Alter, would you share the sql for it ? On Wednesday, 22 April 2015 3:10 PM, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] firebird-support@yahoogroups.com wrote:   On Wed, 22 Apr 2015

Re: [firebird-support] How To Change Column DataType From Varchar To Integer ?

2015-04-22 Thread Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]
Is there no Alter like SQL available ? On Wednesday, 22 April 2015 2:01 PM, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] firebird-support@yahoogroups.com wrote:   On Wed, 22 Apr 2015 09:28:09 +0100, Tim Ward t...@telensa.com [firebird-support]