>Roxy,
>
>I think you need to add aliases to that second query and add a condition, like this:
>
>
>SELECT * FROM ALPHA_X A WHERE NOT EXISTS( ;
> SELECT * FROM ALPHA_X B WHERE A.Somefield = B.Somefield AND B.stype="WL " AND B.progtype="NP") ;
> INTO CURSOR ALPHATMP
>
>I think that ought to do it.
>
I tried playing around with something similar to that, will try again if I get the chance. For now I just changed code to reflect Fast Eddies response.
>How come no new picture of you from DevCon (with hat, of course)?
>
Actually, I did have one taken when I was stuck at Chicago airport with me wearing my hat backwards and working on DevCon article. But I didnt put it up on the webpage with my other pics because I look really hungover, and I didnt want boss to question the fact I missed my plane out of SD. :D)
Roxanne M. Seibert
Independent Consultant, VFP MCP
Code Monkey Like Fritos