Displaying specific record without using WHERE condition?

Hi:D!

Is there anyway to display specific record without using WHERE condition with global variable?

Or more importantly is there anyway to stop the application to prompt for an undefined global variable?

Because I want to display a certain record by the value passed from the other application,
I can do it with the WHERE condition in the SQL settings,
but is there anyway to stop the application to prompt for the undefined global variable?
Because I don’t want the user see that prompt if they try to open that application alone(without passing parameter from another application).

Prompting can be changed by declairing the global variable (see application section) to out in stead of in.But if you need to pass the value to the application from another application then it should remain in. SC will only prompt while developing and running the one application.

Brian,

You can use the “optional” checkbox to avoid the error during runtime in production mode.

Dave

screen2.jpg