handling currency values in sql server

Posts   
 
    
andieje
User
Posts: 28
Joined: 17-May-2006
# Posted on: 21-Jun-2006 17:10:36   

Hi

I am using a sql server 2000 database. When you return a value from a sql server database of type currency the value normally has 4 decimal places.

To handle this, I normally cast the currency values to a decimal with 2 decimal places before i return it from the database

Can i set up llblgen pro so that is handles currency values this way (with a type converter perhaps?)

thanks andrea

bclubb
User
Posts: 934
Joined: 12-Feb-2004
# Posted on: 21-Jun-2006 23:55:31   

I would say that a type converter would be your best bet to do this in multiple locations. A good example of a typed converter is included in the SDK that you can download in the extras section of the customer site.