Groups > Interbase > Interbase SQL > Update




Re: Update

Re: Update
6 Mar 2008 06:43:40 -0700
Serra wrote:

> what should i do ?

	Format the string to the format that InterBase expects. 

-- 
Craig Stuntz [TeamB] · Vertex Systems Corp. · Columbus, OH
  Delphi/InterBase Weblog : http://blogs.teamb.com/craigstuntz
IB 6 versions prior to 6.0.1.6 are pre-release and may corrupt 
Post Reply
Update
Thu, 6 Mar 2008 09:28:58 +0200
IB 6,02

Uprice Field=Numeric(15,2)
Table UPrice Value= 100,50

SqlQuery.Sql.Text:='Update Parts Set Uprice='+OrdDetUPrice......(?)

cause of UPrice value=100,50 ( interbase doesnt accept COMMA,it accepts
DOT (100.50)) i'm getting error.
what should i do ?

Thank you 

Post Reply
about | contact