Kevin,
I'm not sure if this works, but you could try SET NULL ON. Just tested it. It doesn't help.
Can you create the cursor in advance and do an append from your select resultset?
Armin
>
>lcName='Kevin Emmrich'
>select lcName, pk from usersecurity into cursor temp
>lcName = .NULL.
>select lcName, pk from usersecurity into cursor temp
>
>
>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"?