|
From: Robert M. <rob...@gm...> - 2006-02-21 18:24:48
|
Mark, As far as the number formatting, try this: General Preferences -> Data Type Controls In the section called FLOAT, REAL, DOUBLE, NUMERIC, DECIMAL choose "use default format (3.14159)" Rob On 2/21/06, Maury Hammel <ml1...@sh...> wrote: > > Mark Neher wrote: > > > I downloaded and installed the snapshot referenced. I have partial goo= d > > news -- some of the tables which I was unable to edit before work now > > (including the minimal sample that I submitted last week), but I am > > still unable to save an update to the rest. As I get a chance, I will > > try to determine what data conditions might cause these differences. > > If I understand the fix that Gerd implemented, then the tables where the > update doesn't work are probably tables where you have multiple rows > where date values that are on the same day (e.g. 2 Feb 2006 12:00:01 and > 2 Feb 2006 11:48:33, etc.). > > The fix truncates the date when doing the comparison. In such cases, > the code is going to find (what it thinks are) duplicate rows, so it > will not do the update. > > > Maury > > > > > > ------------------------------------------------------- > This SF.net email is sponsored by: Splunk Inc. Do you grep through log > files > for problems? Stop! Download the new AJAX search engine that makes > searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! > http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D103432&bid=3D230486&dat= =3D121642 > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
