LOV

Hi,
If i want to create a LOV for a dept_id field (number) but if i edit the LOV to include dept_id and deptname(character). and when i use this LOV in my @prompt function, what will be my 2nd parameter in the @prompt function? ‘A’ or ‘N’?


koushik7777 (BOB member since 2004-07-05)

It should be N as you are going to use number field in the prompt value.


JaiGupta (BOB member since 2002-09-12)

Using the LOV only returns the first column. The additional columns you add through LOV customization are just “helper” columns.


Dwayne Hoffpauir :us: (BOB member since 2002-09-19)

Thanks Jai and Dwayne


koushik7777 (BOB member since 2004-07-05)