Search results

I have a SmartBrowser which uses 4 tables: FOR EACH ReturnTransaction WHERE ReturnTransaction.ReturnNumber = ReturnHeader.ReturnNumber NO-LOCK, FIRST product WHERE product.p-code = ReturnTransaction.ProductCode NO-LOCK, FIRST Reason WHERE Reason.ReasonCode =...

Thanks for the help. Unfortunately I can't just switch to ADM2 - there is a small matter called this company that I work for... For practically everything else, ADM1 does the job that we need - I guess I'm just being a bit too 'adventurous' and should just stick to something a bit simpler.

Yes I am using ADM1 and the AppBuilder. It &SCOPE-DEFINEs some variables for the query, like {&OPEN-QUERY-{&BROWSE-NAME}} which contains the entire "OPEN QUERY ... FOR ... " etc. statement. I am trying to write some generic code to put in an include file that will work on all browses. See my...

Thanks for your reply. Please forgive me but I know little about Xref - it appears to be an option you choose when you compile something? I can't see how this is useful to my requirements. I can find the FOR EACH statement but that doesn't tell me which index is used for sorting.

If you don't specify an initial sort field on a browse, what determines the initial sort order and how do you find out what it is programmatically? It seems like Progress looks for any indexed fields (be it database table or temp-table) in the browse, and uses the first one it comes to within...

It works :cool:

I see, so it's just how I had it in my example code above. However, now that you mention using {1} I think I can do it. It's possible that a browse could have many external tables, so I have to loop through these within the include file to replace any reference to external table/field names...

Thanks for your reply Paul. I am not using different procedures or windows - I am trying to put this in a generic include file, which is referenced from the START-SEARCH trigger of a browse. You mention the default buffer handle - how do you obtain this? If I could get that, then I can use...

How to dynamically find value of field? I put this issue to the side for a while and got on with other stuff, but now I have come back to this. As I put originally, I'm trying to dynamically setup a query using the QUERY-PREPARE method, but it doesn't work with external tables. Given that...

Even in devhandbook.pdf it says: ...which clearly is not the case. The problem I have now is this: I add the first entry to the browse, no problem. I add the second entry...but it appears in the browse above the first entry, even though I specified INSERT-ROW("AFTER"). For most other...

I'm using 9.1E and the help file says the same as you quoted. I've managed to produce a work-around. When I want to insert the initial row I create a dummy entry in the temp-table, refresh the browse, select the dummy record, insert the new row, delete the dummy record, re-refresh...but how...

I have created a static temp-table and a dynamic browse. By default, the browse has no records. When I try to add a record to the browse using INSERT-ROW(), I get the error "Invalid use of browse method INSERT-ROW. There are no selected rows (382)" Well of course there's no selected rows -...

The problem I have is in substituting the part of the query which reads "JobHdr.JobId" with its actual value. I now don't think I need to create a dynamic query to do this - I should be able to use the FIND-BY-ROWID() method of the buffer, then substitute bhField:BUFFER-VALUE into the query...

Hi everyone :) I have read a number of threads on here which have been very useful but I'm still having trouble and wondering if anyone can help. (I'm using Progress 9.1E and ADM1 btw). I have 2 tables, JobHdr and JobDet (job header and job details respectively), of which there may be...