Lucian

Recent Blog Comments By Lucian

• Data Truncation: Truncated Incorrect DOUBLE Value When Updating Timestamp

  Posted on Apr 22, 2010 at 1:58 AM

  @Ben Keep me posted. Who knows? Some things might have changed. Lucian... read more »

• Data Truncation: Truncated Incorrect DOUBLE Value When Updating Timestamp

  Posted on Apr 21, 2010 at 10:15 AM

  @Ben Weeeeelll ... it did apply to MySQL and SQL Server and Firebird. Can't be sure about Interbase, though, it's been a long time. Lucian... read more »

• Data Truncation: Truncated Incorrect DOUBLE Value When Updating Timestamp

  Posted on Apr 20, 2010 at 2:37 AM

  @Ben: No, double quotes work as well. He just has to pay attention to the letter case. Greetings, Lucian... read more »

• Data Truncation: Truncated Incorrect DOUBLE Value When Updating Timestamp

  Posted on Feb 18, 2010 at 4:55 PM

  @Ben Yes, Ben, couldn't they just have used that tiny "+" sign? :)) Oh, another thing! After using the concat, i kept receiving this error: "No data fetched and-some-other-thing-bla-bla" Said to myself: "Bugger! What could be wrong this time?" Well, since I am a Delphi developer, at my origins, ... read more »

• Data Truncation: Truncated Incorrect DOUBLE Value When Updating Timestamp

  Posted on Feb 16, 2010 at 11:52 AM

  MySQL raised same crappy error on the following syntax: select IFNULL(id,0)+1 into nextval from nextids where UPPER(tablename)=UPPER('''' + tbname + '''') The correct syntax should be: select IFNULL(id,0)+1 into nextval from nextids where UPPER(tablename)=UPPER(CONCAT('''',tbname,'''')); Thank y... read more »