Conversion Routine

Former Member — Thu, 21 Jan 2010 22:58:37 GMT

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?

Re: Conversion Routine

former_member156446 — Thu, 21 Jan 2010 23:16:18 GMT

call cnvertion_routine

in = '11808'.

out = lv_out.

select * from db_table where field_1 = lv_out.