firebird-net-provider

[Firebird-net-provider] 'cast is not valid' error - can't insert rows to my FB :-(

[Umberto <um...@kk...>]

Hello,
I have just started with FB-net-provider and VB.NET Standard and there is
problem from the beginning...
I can not insert rows to my table with numerical values. Char typed fields
works OK, but when I use 'insert... values ('abc', 'defgh', 12) I get an
exeption about that last field: 'cast is not valid'.
I was trying use different methods to put the value into table ('abc',
'defgh', '12'), ('abc', 'defgh', cast(12 as decimal(3)), but the result is
always the same.

Please help me, because I will have to look for another DB (I hope it will
be not nessesery).


Best Greetings,
Robert AbramQ
Poland

Re: [Firebird-net-provider] 'cast is not valid' error - can't insert rows to my FB :-(

[<car...@te...>]

Hello:

> Please help me, because I will have to look for another DB (I hope it will
> be not nessesery).

Ah and another thing :) have you tested it using parametrized querys ??




--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] 'cast is not valid' error - can't insert rows to my FB :-(

[<car...@te...>]

Hello:

> Please help me, because I will have to look for another DB (I hope it will
> be not nessesery).

Have you checked that the sql statement works in other tool ( Like 
IBExpert or isql ), can you post the table structure ??





--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain

Re: [Firebird-net-provider] 'cast is not valid' error - can't insert

[Umberto <um...@kk...>]

> Have you checked that the sql statement works in other tool ( Like
> IBExpert or isql ), can you post the table structure ??

Hello again,
I use Visual Basic.NET Standard, FireBird 1.5, Firebird-Net-Provider 1.5.1.
STRANGE NOTE: Mentioned error I get only when running (lauching) my
application, NOT when debuging program 'step by step' ! realy strange fact
:-O
The table is very simple:

symb_odb CHAR(20)
nazwa_odb CHAR(30)
rabat_odb DECIMAL(5,3)

And the code:

Dim myFBConnect As New
FbConnection("Database=fb_nordis;User=sysdba;Password=masterkey;Dialect=3;Se
rver=192.168.0.2;Pooling=False")
Dim myFBCommand As FbCommand = New FbCommand

myFBConnect.Open()
myFBCommand.Connection = myFBConnect

myFBCommand.CommandText = "insert into ODBIORCY2004
(symb_odb,nazwa_odb,rabat_odb) values ('a1111','aaaaa',5.3)"
myFBCommand.ExecuteNonQuery()

When I remove last numerical field from table and code everything works
great.

Best greetings,
Robert AbramQ.
Poland

Re: [Firebird-net-provider] 'cast is not valid' error - can't insert

[<car...@te...>]

Hello:

> When I remove last numerical field from table and code everything works
> great.

Seems to be working for me, what character set are you using in the 
database and the connection string ??

Can you do a test using parameterized queries ??



--
Best regards

Carlos Guzmán Álvarez
vigo-Spain

Re: [Firebird-net-provider] 'cast is not valid' error - can't insert

[Umberto <um...@kk...>]

> > When I remove last numerical field from table and code everything works
> > great.
>
> Seems to be working for me, what character set are you using in the
> database and the connection string ??
>
> Can you do a test using parameterized queries ??

Sorry I was using your time. The problem is solved and the fault was on the
other side (ODBC), not Firebird.
Thanks for you to working to make so good RDMS. Firebird rulez !

Best greetings,