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

Problem in selection from table

ifat_bar
Participant
0 Likes
505

Hello,

I am trying to select record from table plmm_audit_roles with key object_guid = QD-QA-012008.

outside my program I have no proble, inside my program i get subrc = 4.

when using the convrsion routine CONVERSION_EXIT_PLMAM_INPUT , i get a long string of numbers,

and also subrc = 4.

there is no value in the guid field.

How can I get the record ?

Please advise.

Yifat

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
476

>

> when using the convrsion routine CONVERSION_EXIT_PLMAM_INPUT , i get a long string of numbers

That is what you need to pass in the select query...Check and revert back.

Regards

Karthik D

4 REPLIES 4
Read only

Former Member
0 Likes
476

Check how GUID is fetting stored in table.

QD-QA-012008, you may have to removed - in between before mapping.

Read only

ifat_bar
Participant
0 Likes
476

Hello,

Thanks for your reply.

I tried to take off the -, but itbstill doesnt work.

also in the conversion routine I get guid which is more then 16 characters.

In the table the field defined as 16 characters.

Regards

Yifat

Read only

Former Member
0 Likes
476

Hi,

Try to pass the GUID value in single quotes and then check.

Hope this may work.

Regards,

Prashant

Read only

Former Member
0 Likes
477

>

> when using the convrsion routine CONVERSION_EXIT_PLMAM_INPUT , i get a long string of numbers

That is what you need to pass in the select query...Check and revert back.

Regards

Karthik D