Access datas frm Browser

[santhosh22s]

Hi,
I need to access datas frm browser or a SDO.
I know to go from the query which picks up data for the browser.
Since I hav many filters and queries running for that SDO, its hard to find that.
So can anyone help me out in doing this.

Thanks in Advance,
Santhosh.S

 

[Osborne]

Santhosh, I may be totally on the wrong track so not sure if this is what you require, but the following is something simple that gives the result of a selected record from a browse - based on the Sports database:-

DEFINE QUERY q1 FOR Customer SCROLLING.
DEFINE BROWSE b1 QUERY q1 DISPLAY cust-num name credit-limit balance WITH 22 DOWN.
DEFINE FRAME f1 b1 WITH SIDE-LABELS ROW 2 CENTERED NO-BOX.
ON VALUE-CHANGED OF b1 DO:
IF AVAIL Customer THEN
MESSAGE Customer.Cust-Num Customer.Name Customer.Credit-Limit
VIEW-AS ALERT-BOX INFORMATION.
END.
OPEN QUERY q1 FOR EACH customer WHERE customer.Credit-Limit > 1000 NO-LOCK.
ENABLE b1 WITH FRAME f1.
WAIT-FOR END-ERROR OF FRAME f1 OR WINDOW-CLOSE OF CURRENT-WINDOW.

For all records you could use something like this:-
GET FIRST q1.
DO WHILE AVAILABLE(Customer):
DISP Customer.Cust-Num Customer.Name Customer.Credit-Limit.
GET NEXT q1.
END.

I don't know anything about SDO but wondered if Progress solution P20080 is similar to what you are after.

 

[santhosh22s]

Hi Osborne.,
Thanks for your reply.
Wat u said is basic manipulation of data frm a query to a browser.
Wat I want is just a reverse process.

If anyone knows it, help me out.

Thanks in Advance,
Santhosh.S