Re: [Firebird-net-provider] I've got decimal issues with other cultures and need help

[Jiri C. <di...@ci...>]

On 4/7/08, Rolf Marsh <rm...@fa...> wrote:
>   string fbInsertString = "insert into tBooks  values ('" +
>   BookNbr + "', '" +
>   Title.ToString().Replace("'", "''") + "', '" +
>   Author.ToString().Replace("'", "''") + "', '" +
>   ISBN + "', '" +
>   Illus + "', '" +  //
>   Locn + "', '" +
>   decPrice + "', '" +
>   decCost + "', '" + ...

Use parameters(!), not composing query. Here you have 2 problems
(except composing). 1. You're placing >'< around number. 2. The FB
server is accepting only >.< as decimal separator so using >,< is
mistake (that's why you get the wrong number).

-- 
Jiri {x2} Cincura (CTO x2develop.com)
http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com