>I added the parameter to opentables with a value of 0 which isn't quite the same as nodata but does provide the same result. It is just interesting that with this type of query, nodata does not work!
>
>Hi Bob,
>
>That's interesting. Could you expand a little more on how you did with the opentables().
>
>Thanks in advance.
>
>José

I use the codebook framework (actually Mere Mortals) so all of my views, etc are opened from within a subclassed data environment and cursor class. So in my subclass of the dataenvironment that opens the cursor I added this function to override the default

FUNCTION OPENTABLES

v_objcompkey = 0 && keys will always be 1 or greater so no data is returned
DODEFAULT()
ENDFUNC

Of course opening the view from the project manager or the command window will always prompt for the variable name, but now within my program.