2005 Nov 29 6:12 PM
How do you handle a function parameter intended for a field that uses a conversion routine?
For example if I want to declare a parameter of type PS_PSPNR there is a conversion routine (KONPD) that raises an error if the input parameter does not exist. Mabye I want to use the parameter in a SELECT statement that uses a BETWEEN in the WHERE clause.
Do I have to have to just use a generic parameter of TYPE C and convert it prior to my SELECT statement?
How do you specify a field length for an import parameter?
Would it be easiest just create my own data element type?
Thanks for any help or tips you can provide.
Greg
How do you handle a function parameter intended for a field that uses a conversion routine?
For example if I want to declare a parameter of type PS_PSPNR there is a conversion routine (KONPD) that raises an error if the input parameter does not exist. Mabye I want to use the parameter in a SELECT statement that uses a BETWEEN in the WHERE clause.
Do I have to have to just use a generic parameter of TYPE C and convert it prior to my SELECT statement?
How do you specify a field length for an import parameter?
Would it be easiest just create my own data element type?
Thanks for any help or tips you can provide.
Greg
2005 Nov 29 6:16 PM
Yes, create the Char field and prior to select you use conversion routine.
it is the one of the best way to proceed
regards
vijay
2005 Nov 29 6:18 PM
I dont think u have to create a data element, instead find out the length of the PSPNR from the domain of the current data element and delcare a CHAR type field of same lenght.
2005 Nov 29 6:26 PM
2005 Nov 29 7:04 PM
Thanks everyone. I guess I was just stuck on using the data element types for my import parameters because they are formatted for size when running the test tool.
I just wish there was a way to create an import parameter and declare a length with creatinga custom data element.
| User | Count |
|---|---|
| 6 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |