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