Mitchell Vincent <[EMAIL PROTECTED]> wrote:
I know it's a long shot but is it possible to use the Windows API
GetCurrencyFormat() function to format currency strings?
I need a layer between my database and report generator to properly
format currency (money) strings for various countries.
I assume you want to have SQLite format values for you (though you are
talking about a layer above the database which seems to suggest
otherwise). You can install a custom function - see
sqlite3_create_function[16]. This function can do whatever you want,
including calling GetCurrencyFormat. Then you can do something like
select FormatCurrency(currencyValue) from ...;
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
