Sorry I'm using a long data type and I'm thinking it was a numeric field. :)
-----Messaggio originale----- Da: Dittmar, Daniel [mailto:daniel.dittmar@;sap.com] Inviato: gioved� 24 ottobre 2002 13.47 A: 'Umberto Angelini'; [EMAIL PROTECTED] Oggetto: RE: SQL sintax > Why must I put the value of a numeric field in insert/update statement > between '' > When I used other database I did not find this rule. > Can I eliminate this property of SAPDB ? There is no need to pass numeric data as strings. Some modes allow this and convert the data, but this is generally frowned upon. If there has indeed been an error reported, please post - the table definition - the insert statement - the tool/programming interface - the SQL mode Some of the programming interfaces put the error position into the error message, so please check that the error really occurs where you believe it to be. Daniel Dittmar -- Daniel Dittmar SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
