In article <[EMAIL PROTECTED]>, IML- [EMAIL PROTECTED] says... > I'm by no means an expert on SQL, so just an observation... > > You seem to be treating integers with quotes... I've never done that with my > SQL. To me '0' would make sense for VARCHAR, but not int.
I agree - this code is from existing SW - PostNuke - and it works with several RDBMS's. It's not necessary, but definitely should not cause an error. > Trying to insert '' into a INT field? To me, only allowable would be > integer numbers or NULL. An _empty string_ is neither a number or null. So how would you say, "assign the default value to this numeric field" ? If ...,'',... is invalid, and ...,,... is invalid? > To me, the error is that SAPDB doesn't error on the '0' too :) Why? Just tried on Informix, DB/2, MySQL and PostgreSQL - all accepted it. I agree that it is not necessary, but why make it an error ? Thanks, -- Yours, Andrej Falout, http://www.falout.com/disclaimer.html Visit the OpenSource alternative, Aubit 4gl: http://aubit4gl.sourceforge.net PLEASE NOTE: All HTML email sent to me WILL BE DELETED AUTOMATICALLY WITHOUT READING. _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
