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 =
'200005261640596840'""
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/[email protected]/
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.