Hello list,

I sometime use commands to see if a value exist

Example 1
CHOOSE testabc FROM #VALUES FOR...
-ERROR- No values are available from which to choose (942)

Most of the time there are no values to choose from. But when there is the user as the option to choose one of the values.

Example 2
SELECT custid INTO vcustid INDICATOR vcustidin FROM customer WHERE ...
<WARNING> No rows exist or satisfy the specified clause (2059)

If no rows are retreived then I insert one.

Can those commands make the application lag?

Thank you

Michel Séguin


Reply via email to