topic Re: Problem in selection from table in Application Development and Automation Discussions

Problem in selection from table

ifat_bar — Sat, 20 Jun 2009 20:18:42 GMT

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

Former Member — Sun, 21 Jun 2009 05:20:15 GMT

Check how GUID is fetting stored in table.

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

ifat_bar — Sun, 21 Jun 2009 07:34:38 GMT

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

Former Member — Mon, 22 Jun 2009 03:39:54 GMT

Hi,

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

Hope this may work.

Regards,

Prashant

Former Member — Mon, 22 Jun 2009 04:03:00 GMT


> 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