Hi :-)
Because many DBM'ses accept something that does not mean that it is
valid SQL. That is not standard behaviour. If you do not want to set
a value, just don't give it: (I also don't give user, password,
maxrows,siteurl,options, so they will be set to their default values)
INSERT INTO PNCVS_headlines
(pn_id,pn_sitename,pn_rssurl) VALUES
(2,'PostNuke','http://postnuke.com/backend.php')
You will see this is much shorter and it _will_ work with any SQL DB.
Ralf
> 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
>
--
theCo.de AG
Oranienstr. 10-11, 10997 Berlin
fon +49 30 617 897-0 fax -10
[EMAIL PROTECTED] http://www.theCo.de
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
