Some suggestion using sqls with bind variables in sqlnav. (scan defines ON)
- When you specify variable as :variable , variable menu does not carry about format of the datatype, for example when you set numbers - you can input any string you want, but only numbers shoul e allowed.
- When I try to bind a date variable (choosing date as type) error occurs:
Invalid variant type conversion.
Other types works ok.