Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Conversion Routine

Former Member
0 Likes
362

I am working with a field (field_1) in a database table called db_table.

The data element of the field_1 is linked to a domain, which

has a conversion routine.

The value stored in field_1 of the table is 11808.

When I use transaction and search with this value,

the conversion routine runs and the field value is

output as 104003.

I have a program that has a select statement as follows:

select * from db_table where field_1 = '11808'.

This select statement returns no record.

Why is this happening?

1 ACCEPTED SOLUTION
Read only

former_member156446
Active Contributor
0 Likes
338

call cnvertion_routine

in = '11808'.

out = lv_out.

select * from db_table where field_1 = lv_out.

1 REPLY 1
Read only

former_member156446
Active Contributor
0 Likes
339

call cnvertion_routine

in = '11808'.

out = lv_out.

select * from db_table where field_1 = lv_out.