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.

Reply via email to