Strange behavior with a Sybase stored procedure

From: Danny Crowell (DannyCrowell_at_discussions.microsoft.com)
Date: 01/28/05 

Date: Fri, 28 Jan 2005 11:31:08 -0800

I call a stored procedure using the Sybase SQL Advantage tool and view the
resultset. I don't see any NULLs in my results.

Next, I call the stored procedure from my .NET application and one of the
columns occasionally has NULLs. I tried this using ODBC drivers and the
Sybase ASE client and had the same results both times. I made sure I am using
the same environment.

I'm stumped. Does anyone have any ideas on how to resolve this?

Thanks,
Danny Crowell
www.crowsol.com

Relevant Pages

  • Strange behavior with a Sybase stored procedure
    ... I call a stored procedure using the Sybase SQL Advantage tool and view the ... resultset. ... I don't see any NULLs in my results. ...
    (microsoft.public.sqlserver.connect)
  • Re: hashtable to pass to proc
    ... Have you checked to see if it is a problem with the stored procedure? ... the SP has the code to convert nulls into empty strings. ... private voide UpdateCars(string Make, string Model, string Notes) ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Checking for null
    ... >> email address to recover a forgotten username. ... After I execute the stored procedure I try ... >> is the correct way to check for nulls in ASP.NET? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: date as null
    ... If you need to pass it to a stored procedure, and you require a value, you ... If you allow nulls, just use DBNull.Value. ... >> Steve C. Orr, MCSD, MVP ...
    (microsoft.public.dotnet.framework.aspnet)