Hello,

I got an error and I am trying to understand why this is a problem.

For example if I run the following code

lcName='Kevin Emmrich'
select lcName, pk from usersecurity into cursor temp  && works fine
lcName = .NULL.
select lcName, pk from usersecurity into cursor temp  && error

When I set lcName to NULL I get the error ' does not accept null values'. Why wouldn't the sql*select just create a field in temp that can accept nulls. Is the problem that the sql*select can't figure out the data type even though it is a "C"?

Thanks in advance,

Kevin

Kevin Emmrich
www.jkt9000.com