Home » Developer & Programmer » Forms » How to call procedure
How to call procedure [message #238345] Thu, 17 May 2007 08:48 Go to next message
siva27
Messages: 34
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 #238945 is a reply to message #238345] Mon, 21 May 2007 01:11 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please give a fuller example.

Does A3 go to A3-3 or just to 3?

What are the names of the fields? Please read the 'sticky' for this forum where it asks that you give a table definition for your exercise.

David
Re: How to call procedure [message #239027 is a reply to message #238945] Mon, 21 May 2007 05:23 Go to previous messageGo to next message
siva27
Messages: 34
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 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: .PLL Required
Next Topic: Multiple Rows
Goto Forum:
  


Current Time: Fri Dec 09 21:36:46 CST 2016

Total time taken to generate the page: 0.12761 seconds