Setting NULL Value

2000-09-15 Thread Percy E Perez
Hello All, I am trying to set a field to null value, but I am getting an error. Error Diagnostic Information ODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot use empty object or column names. Use a single space if necessary. SQL =

RE: Setting NULL Value

2000-09-15 Thread Simon Halcrow
in the Knowledge Simon Halcrow Web Developer E [EMAIL PROTECTED] T +44 (0)1642 702100 F +44 (0)1642 702119 -Original Message- From: Percy E Perez [SMTP:[EMAIL PROTECTED]] Sent: 15 September 2000 13:14 To: [EMAIL PROTECTED] Subject: Setting NULL Value

Re: Setting NULL Value

2000-09-15 Thread JustinMacCarthy
not if it's working in Query Analyzer , check your odbc settings... ~Justin Sounds like it is enforcing a constraint - either via a CONSTRAINT, index or required field(s). Check for primary key violation and duplicated primary key indexes too. However if I run this statement in the