Urgent Please Help.

[Tim Bailey]

I have a Dephi 3 C/S app which accesses a table using a TQuery
on a SQLServer 6.5 Server. One particular field in the table I have
specified as MONEY. Whenever I try to post an amount with more than 2
decimal places the figure is rounded. I must be able to enter
3 decimal places.

I looked in the SQLServer documentation and found that SQLserver
stores money fields with 4 decimal places. I have set the DBE to be
4 decimal places and the Windows regional settings to be 4 dp but I cannot
figure out why this is still happening.

This is causing major problems and I need to sort a solution ASAP

Any Ideas.....

Tim Bailey

[Bob Tucker]

I have this problem and keep raising it to Borland to no satisfaction. Use
a numeric field with scale of 3 to 5 and you get same thing. You can enter
40.40 and it stores as 40.39999. It is a problem in sqlserver 7 as well
with new beta drivers. The only way we have gotten around it has been to go
odbc. This required cleaning up queries a bit but it made our code cleaner
in long run. And, I know it sounds strange but we've found odbc to be
slightly faster. Also, with odbc, you can use tcpip and specify the server
by its ip address which really helps performance.

Let me know if you get a fix for rounding problem using sql links. I can't
believe everyone is screaming about this.
btu...@lp-systems.com

Tim Bailey wrote in message <78nvti$2s...@forums.borland.com>...

[Rogerio]

Bob Tucker escreveu na mensagem <78obmm$2s...@forums.borland.com>...

Try to set ENABLE BCD = True in BDE

I use numeric field with scale 3 to 5 in MSSQL 6.5, Sybase ASE 11.5.1 and I
don't have problems.

Rogério César de Aquino
www.riosoft.com.br

[Bob Tucker]

Using BCD requires repopulating all query components with new fields as they
change form float to bcd.

Rogerio wrote in message <78s9hd$65...@forums.borland.com>...

[Tim Bailey]

Do you think this is a BDE problem?
If so it must be a simple fix surely?

Tim

Bob Tucker wrote in message <78obmm$2s...@forums.borland.com>...

[Bob Tucker]

I do think it is a BDE problem. I can't figure out why everyone isn't
screaming about it. I did a test on it yesterday and the problem still
exist with latest BDE and latest mssql 7 links driver.

I suppose most people are using BNC numbering. The problem with that is
that your application must have the exact scale set in the Tfield
properties. If I use numeric (float) user can change the scale at will
without the program having to be altered. A good example is the price of
product a company might sell. It might be only 2 behind decimal or as much
a 5. One of my customers sells propane for .2175 cents per gallon.

Hopefully this will get recognized soon.

Tim Bailey wrote in message <78v1f2$8e...@forums.borland.com>...