Re: How to get the value of a column

"Roger" <rbruening_at_ups.edu> wrote in message news:878789c6.0111280805.24b3021f_at_posting.google.com...
> Thanks for reading this.
>
> I need to get the value of a column (display only) in a multi-row
> form.
>
> I have the row number using Get_Block_Property( blk_id,
> CURRENT_RECORD).
>
> I assume there is some function that I can call that needs the column
> name and row number to get the value.
>
> TIA
IIRC, there actually isn't.

You'll need to navigate to the record, get the value, and navigate back again to where you were when you started.

For example, if you were in something like PowerBuilder, you'd do something like this (been a while but it's kinda like this):

GetItemString(This,5,"item_code",Primary!)

This = datawindow handle (sort of the equivalent of a block in Forms) 5 = the record number
item_code = field (column) name
Primary! = primary data buffer

There isn't really an equivalent function in Forms. Pretty much the record you get when you refer to an item by :BLOCKNAME.ITEMNAME is the current record in the current block or whatever record was last active in the block you are referring to if you aren't sitting in that block right now.

-Matt Received on Thu Nov 29 2001 - 04:09:34 CET