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  && 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"?

---

Armin Neudert
Regional Director (Stuttgart) of German FoxPro User Group dFPUG

MCP for Visual FoxPro

Expert/Editor of the VFP section in the German Codezone community portal