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.
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. To me, the error is that SAPDB doesn't error on the '0' too :) Stephen -----Original Message----- From: Andrej Falout [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 15, 2002 3:38 PM To: [EMAIL PROTECTED] Subject: Possible bug in insert - empty string not allowed on coloumns with default? Hello again, Table: CREATE TABLE PNCVS_headlines ( pn_id serial NOT NULL, pn_sitename varchar(255) NOT NULL default '', pn_rssuser varchar(10) default NULL, pn_rsspasswd varchar(10) default NULL, pn_use_proxy int NOT NULL default '0', pn_rssurl varchar(255) NOT NULL default '', pn_maxrows int NOT NULL default '10', pn_siteurl varchar(255) NOT NULL default '', pn_options varchar(20) default '', PRIMARY KEY (pn_id) ) SQL: INSERT INTO PNCVS_headlines VALUES (2,'PostNuke',NULL,NULL,'','http://postnuke.com/backend.php',10,'','') Error: Error in assignment;-3016 POS(61) Invalid numeric constant. Works fine: INSERT INTO PNCVS_headlines VALUES (2,'PostNuke',NULL,NULL,'0','http://postnuke.com/backend.php',10,'','') Thanks for your comments, -- Yours, Andrej Falout, http://www.falout.com/disclaimer.html Visit the OpenSource alternative, Aubit 4gl: http://aubit4gl.sourceforge.net PLEASE NOTE: All _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
