Member Avatar for hkeng08

Hi all,

I am using php code to write some server code. I wanted to convert some float value to decimal value for storage into the sqlanywhere database server. I declare the attribute type as decimal as I wanted to insert a float value into this attribute. I will encountered any error saying "Warning: sasql_query() [function.sasql-query]: SQLAnywhere: [-157] Cannot convert '1275546391.0732' to a decimal in C:\Users\HweeKeng\Documents\server\htdocs\PhpProject1\includes\class_sql.php on line 64".

The float value that I wanted to convert is actually a time instance.

Can anybody give me some help to the above problem. Thanks a lot!!

Edited by hkeng08 because: n/a
  • 2 Contributors
  • 1 Reply
  • 63 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by rajarajan2017
Member Avatar for rajarajan2017

Is this your decimal value '1275546391.0732'?

Try to just give small digit number as 35.4 and test it whether it updates.
If yes then the limitation may be a problem

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.