topic Re: avoid DB650 at selection in Application Development and Automation Discussions

avoid DB650 at selection

Former Member — Thu, 07 Apr 2011 07:13:19 GMT

Hi Expert,

Could You pls help me to handle a standard DB650 message at selection?

I have a selection screen, where a field need to be used - low and high values. The domain behind refer to quantity with no decimals - vnztv. If is use selection 3 - 10 I get the error message DB650 - lower limit is grater than upper, so I have to set 03 - 10. I have already tried to have different data types but I get the same result / error.

Could any of You pls let me know how to handle this issue?

Anserws will be appreciated.

Re: avoid DB650 at selection

Former Member — Thu, 07 Apr 2011 08:40:15 GMT

Hi,

Just tested the selection on a amount in a table. No problems.

But use the table and field.

TABLES: <table>.

SELECT-OPTIONS: s_fldnm FOR <table>-<field>.

SELECT * FROM <table>

INTO ....

WHERE <field> IN s_fldnm.

Succes,

Rob

Re: avoid DB650 at selection

Former Member — Thu, 07 Apr 2011 08:57:04 GMT

Hi Rob,

thank You for answering, but my selection field actually does not refer to a table field directly. This is a relative date, and i calculate the actual date based on this, and then that actual vaue is refer to a db-table.

Such as: date handling - my selection field - relative date have value 3 means: 3 days from today, (10th of April - will be the actual date for selection in program run).

Re: avoid DB650 at selection

Former Member — Tue, 19 Apr 2011 10:28:12 GMT

Solved by myself

Re: avoid DB650 at selection

deepak_dhamat — Tue, 19 Apr 2011 11:25:22 GMT

Hi ,

Please share your solution . It will help others

Regards

Deepak.