How to call procedure [message #238345] |
Thu, 17 May 2007 08:48 |
siva27
Messages: 41 Registered: April 2007 Location: Chennai
|
Member |
|
|
Hi All,
In my form i have one List Item is there
When i click on that column In the Form Front-end i will display
A1
A2
A3 .....ETC
But in the back end XX Number(3) in the table
If i try to insert the data through Front end it have to store aa for A1-1,A2-2 ,A3-3 ...etc
For this we need to write a procedure.If any one is having the code or knows the code plsss send me ,urget
If i query it has to dispaly corresponding number-char
Regards
Siva
|
|
|
|
Re: How to call procedure [message #239027 is a reply to message #238945] |
Mon, 21 May 2007 05:23 |
siva27
Messages: 41 Registered: April 2007 Location: Chennai
|
Member |
|
|
hi David ,thxs for ur reply
In my form i'm having Item List,if i click the button i will get list of values.i will select as per my requirment.
Display List A1,A2,A3,A4,A5
but in the back end parameter is number.
If i click A1 in the back end it has to insert as 1
If i click A2 in the back end it has to insert as 2
If i click A3 in the back end it has to insert as 3
If i click A4 in the back end it has to insert as 4
If i click A5 in the back end it has to insert as 5
That is the senario behinde this,if u what any more clarification i will tell
IF u have code of this type of package,or if know just tell me
Regards
Siva
|
|
|
Re: How to call procedure [message #239654 is a reply to message #239027] |
Wed, 23 May 2007 00:05 |
|
djmartin
Messages: 10181 Registered: March 2005 Location: Surges Bay TAS Australia
|
Senior Member Account Moderator |
|
|
Just create a two column record group with 'A1' & '1', then 'A2' & '2', etc. then when you select the item use the column mapping of the item's LOV to which you have associated the recourd group to use the second column to populate the background field. Alternatively, you can use a When-Validate-Item on the non-database field containing the 'A1' to decompose the string to '1' and use it to populate the hidden database field.
David
|
|
|