M
Manikandan.G
Guest
how to fetch the value from db in progress 4gl, initially have a input from user to select the record based on the value the record will be displayed. we try that but we cant fetch the exact value, please help us ?
this is our program..
def var b as int. def var obj as int. /set obj. prompt-for obj./ def var sum as int. def var a as int no-undo. def var i as int no-undo. for each po_mstr break by po_nbr. select count (*) from po_mstr. assign a = 1 b = 583 . repeat: if first-of (po_nbr) then set obj. prompt-for obj. if (a le obj and obj lt b) then disp po_nbr po_vend po_ship po_ord_date with 2 col. end. end.
i can retrive a single data only if we give more than 2 value means it will display the same 1 st value , plz help us..
Continue reading...
this is our program..
def var b as int. def var obj as int. /set obj. prompt-for obj./ def var sum as int. def var a as int no-undo. def var i as int no-undo. for each po_mstr break by po_nbr. select count (*) from po_mstr. assign a = 1 b = 583 . repeat: if first-of (po_nbr) then set obj. prompt-for obj. if (a le obj and obj lt b) then disp po_nbr po_vend po_ship po_ord_date with 2 col. end. end.
i can retrive a single data only if we give more than 2 value means it will display the same 1 st value , plz help us..
Continue reading...