>VFP 5.0 is not accepting the following code:
>
>
>IF NOT EXISTS(SELECT c.guro_id FROM (this.cursor_name) c ;
>WHERE c.guro_id = EVAL(cur+'.guro_id'))
>
>
>this.cursor_name is the name of one cursor and cur is the name of another. VFP gives me the compile error 'Function name is missing )'.
>I do not see any missing parens, so something must be provoking the compiler to expect a close parens prematurely. BTW, my usage of EVAL and the parens around this.cursor_name are based on what has worked for me through trial and error.
>
>Thanks in advance
One of the endearing (?) oddities of Fox is the it gets REAL picky about macro substitution.
Have you tried:
IF !EXITSTS(SELECT c.guro_id from &this.cursor_name c;
WHERE c.guro_id = &cur..guro_id
?
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place