Hi Alex, > It seems to be a very fragile point in the underlying core. Is there no > hope of unifying the API or putting it into a single interface to try > and avoid to deal with such problems ?
The answer is twofold: Sometimes, there is some better API. For instance, you can ask a database/table column for it's numeric value, or, if it's a date, for its date value. Both methods are present at API level. "Unfortunately", the getDate method works for dates only, while the getDouble methods works for nearly all types of columns. That said, guess what clients of such an API prefer to call in the first attempt ... But sometimes, it's not always as easy as this. For instance the recent "Calc ranges pasted as HTML into a database table are 2-off" problem was since we could not even figure out that we had a problem: The clipboard format just transfered the double value, not the "null date", so there was no chance to use another API. Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
