> Yes, I know about creating a function but I'm wondering if I can hook > into the already-existing Windows API function for it.
You don't need to write a totally custom function, just something that bridges the two API's. Create a function that implements the expected SQLite call spec and then call out to Windows to get the results. HTH, Sam ------------------------------------------- We're Hiring! Seeking a passionate developer to join our team building products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mitchell Vincent Sent: Friday, April 06, 2007 11:17 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Re: Currency Formatting within SQLite Yes, I know about creating a function but I'm wondering if I can hook into the already-existing Windows API function for it. Currency formatting is quite complicated (much more than just storing a currency "symbol") and Windows has already done the leg work - I just need to see gain access to the API function for it. The reasons are complicated but suffice it to say that currency formatting is one area that ReportMan (reportman.sourceforge.net) is lacking in. It's really not the job of a database to do this stuff but I'm left with either getting SQLite to do it on the fly or adding another "formatted" text field for each currency field already in the database. Thanks Igor! ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------