I'm trying to put a hyperlink on a window. just wondering if there any way of doing that? The hyperlink is coming from a database field.. So e.g. company.web = www.google.com then user clicks on it and takes them to the website. I've tried putting a fill-in box on and changing the colour. But...
ah right well prob going to stay the same way unless it makes its faster or something. always done my no-locks at the end. I've been told to leave that query for now so not sure how much faster it will be only so much i can do without making changes to the database
Thanks for all your help
Yeah thats kind of what i want.. though this is running at startup from a P file and a window is created behind the dialog-box (due to there being no existing window which it doesnt do with the message command) which i dont want and i have no idea how to get rid of it... I've also tried creating...
if you put a message "TEST" view-as alert-box. can you wait for a certain amount of time for user input then close it down? not sure how this would be done any suggestions would be great cheers (progress 10.2b(
Well I've taken the breaks out as that seem to slow it down the most and it a temp table is created anyway so if can just sort that. Also removed the use-index as that index only has compno ordack and ordstat in it. I’ll have to put a database request in for an index with compno ordack ordstat...
Thanks guys I'll have a look at those suggestions and see what I get. Another quick question, is it a bad idea to use a OR on sophdr.ordstat do OR's cause a slow down?
Hi all
I'm currently working on a query taking a long time on site. I’m just wondering if anyone could point me in the right direction for documentation on query efficiently. As its a bit of a dark art for me. I’m currently working on open edge 10.2 b.
There isn’t currently an index that fits...
managed to sort it by getting the column names as a handle and going through each one of my "closure codes" Ive put the code down below incase anyone has the same issue
assign hbrCol = BRDetail:first-column in frame fmain.
repeat:
/*loop through browse...
Hi I'm currently using open edge 10.2b I've got a variable from a database filed that is an array 99 long. I want to display all of them in a browse but i dont want to hardcode all the labels in. I’ve got the following code at the moment lots of case statements is there a way to use the closure...
Right think I've got it :
DO iRow = 1 TO br_search:NUM-SELECTED-ROWS:
MESSAGE br_search:FETCH-SELECTED-ROW ( iRow ).
MESSAGE a-chd.kcode. /*field in table*/
END.
you get the row then its looking at the correct record, I need to test it but looks good to me
I'm Having the same issue I'm using progress 9.1c, FETCH-SELECTED-ROW returns a bool thats why you are just getting yes. But I'm not sure where to look for the row index/row id? So I can actual know what record I'm looking at
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.