Post reply

Double quotes verses single

  • July 23, 2007 at 8:22 am

    #117785

    I have a st.proc which does an insert after checking the value for a certain column. ex if check_status = "y" then insert...

    If i have the status check in double quotes the st.proc returns an error and if i change it to single quote it works. I have set quoted_identifier turned on . Has anyone seen this problem before. Any thoughts or ideas will be greatly appreciated.

    TIA

  • July 23, 2007 at 8:31 am

    #721533

    If you have quoted_identifier set to be on, the "y" is thought be SQL to be a column.  If you want to use double quoted, quoted_identifer need to be set to be off.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply