Browse

[SKaushal]

Hi Everybody,

I'm having a problem:
I want to send the Column(C-No) to a Temp-table from a "Browse" Widget that is begin displayed in a frame, NOTE :But only the results which are in the screen i.e just 17 row's C-No's, however the query may return 30 or 40 rows.One more thing, also the we can scroll through the window.All this must be done on press of some key like "F8" or so:

Following are the declarations I hv done in the program:

DEFINE QUERY q1 ...
DEFINE BROWSE b1 QUERY q1
DISPLAY C-No Name
.......................
.......................
WITH 17 DOWN.
DEFINE FRAME f1
b1
WITH SIDE-LABELS
ROW 1
CENTERED
NO-BOX.


Regards
Skaushal

 

[Norman Biggar]

To skip throught the records in the browser viewport, use the following code


ip-hBrowser:SELECT-ROW(1).
ASSIGN iStart = ip-hQuery:CURRENT-RESULT-ROW
iEnd = iStart + ip-hBrowser:NUM-ITERATIONS - 1.

DO iLoop = iStart TO iEnd:
ip-hQuery:REPOSITION-TO-ROW(iLoop).
END.


ip-hBrowser is the handle of the browser, and ip-hQuery is the handle of the browser's query.