[Squirrel-sql-users] String to date conversion error despite global prefs

[<jan...@ya...>]

Hi,

I get a "String to date conversion error" when I'm trying to do this:

update bla set blabla='6/21/2007' 

despite having in the global prefs, data type controls, date, the "use default format (2007-06-22)" unchecked, and for "or locale-dependent format: Short (6/21/2007)" selected.

Am I doing something wrong?

I checked/unchecked the "allow inexact format on input", same result.
If I change my update to say '2007/06/21', I don't get the exception anymore.

This is the informix driver, 2.5, windows.

Thank you.