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.
Sponsors of the 1st Northern Information Security Conference
http://www.nisc.org.uk
Sapphire Technologies Ltd.
Secure 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
>
> 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 = "UPDATE tdc_doc_infocard SET file_zipped=NULL WHERE info_card_id =
> '25261640596840'""
>
> However if I run this statement in the Query Analyzer, it works.
>
> Any suggestions?
>
> Thanks in advance.
>
>
> Percy E Perez
>
> --
>
> Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
---
Any opinions expressed in this message are those of the individual and not necessarily
the company. This message and any files transmitted with it are confidential and
solely for the use of the intended recipient. If you are not the intended recipient
or the person responsible for delivering to the intended recipient, be advised that
you have received this message in error and that any use is strictly prohibited.
Sapphire Technologies Ltd
http://www.sapphire.net
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.