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