Member Avatar for Smeagel13
Smeagel13 5 Junior Poster in Training

Field defined as DECIMAL(5,2), trying to INSERT (250.00).

When query is performed remotely to DB server, it fails with 'Out of range value for column...', when query is performed locally on the DB server, the query works. The query works remotely when the value being inserted is 226.24 (yes, that specific) or less. The query also works when inserting into a duplicate database on another machine locally.

Any ideas...?

Edited by Smeagel13
  • 1 Contributor
  • 0 Replies
  • 90 Views
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.