I am running Squirrel version 2.3 rc1, against Oracle
9i release 2 database, oracle thin driver, on Linux.
If I run a sql select for update statement, then click
on a cell (not necessary a date cell) in the results
and edit, click on another cell, I get a warning message:
"Exception seen during check on DB. Exception was:
ORA-01830: date format picture ends before converting
entire input string"
Oracle documentation suggests this is caused by display
format incompatible with input format.
Could Squirrel query the DB for date input format, and
display it in a compatible format?
Or is there another solution?