From: Jiri C. <di...@ci...> - 2008-04-07 15:26:27
|
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 |