Search results

It seems to me that 'Search' is not currently working..

Yes, Osborne- AppBuilder created, thanks for the clue . appreciate it.

I have a simple Dialog form, with a single Browse. The Query hits a couple of tables (ie: FOR EACH 'this', FIRST 'that',...). I'm looking to capture the default 'PREPARE-STRING' attribute and store it in a variable. I can see in Help that the 'Prepare-String' attribute will return '?' if...

Does Progress 4gl have the 'short-circuit' behavior like some other languages, in a multiple condition 'If' statement? ie: If ( (varA = False) OR (varB = False) Or (varC = False)) then do: //stuff end. Else do: //other stuff End. 'short-circuit'...

I would like to exit a 'for each' loop early if conditions are met, not sure of the syntax.

Thanks Andrew. The code change, adding the 4th table is where the problem is, I would expect to see exactly what your test shows. Could be that I messed something up in the source code, although when I first made the change the problem occured, before any fiddling w/code. I'm...

And everything looks fine there, code from procedure Editor of .w file: /* Browse definitions */ DEFINE BROWSE BROWSE-1 &ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS BROWSE-1 wWin _FREEFORM QUERY BROWSE-1 NO-LOCK DISPLAY...

The Section Editor does take me to the 'open-query' section, added my table there, no problem. But to re-define the 'browse' is another deal altogether, the Section Editor doesn't get me there. As I said earlier, I did get into the Procedure Editor and updated some of the...

I did use the Query Wizard, then went to 'free-form' as the app went along . The problem arose when I needed to add another table to the browse/query that is now 'free-form'. Code Editor, revising the 'Open Query' trigger, no problem. However, the Code Editor does not allow me to get to the...

The App Builder is what I am using, the problem is : when editing the .w file, the Section Editor does not allow me to edit the 'browse' definition (to add another table ) that was originally created using the Query Wizard. I can open up the .w with the Procedure Editor, make required...

I'm working on an App Builder-Smart Window- added a browse with the 'browse wizard' . Later on I decide I need another table to be 'joined-in', the query is by now a 'free-form' query. I cannot remember how to get to the 'browse definition' code, I can view it fine. The Section Editor does...

Thank you, I did it this way : /* On Change of first browse, to clear order-browse */ order-browse:SELECT-ALL(). order-browse:DELETE-SELECTED-ROWS().

Can-Find is not 'usable'' in a Query, I may have to go the 'temp-table' route

I'll give that a try, thank you Casper.

Is there a 'keyword' , or similar , in Progress, when querying (?) that would give me 'Unique' records, such as using 'Distinct' in SQL? ie: I want all customers that have placed orders , but I don't want repeats , each customer only (1) time, I'm using a Browse w/a Query?

I'm developing an app, 2 browses, First holds 'CUstomers', click on customer, 2nd browse enabled to show all orders from that Customer. I don't know how to clear 'browse 2' after a new 'Customer' is selected in browse 1.

Casper, Is this 'granting' scripting done thru a progress tool? Also, is the 'username' a 'username' defined thru a System DSN/ODBC Driver? Thanks

Thanks Casper, I'm not at work now and cannot check for sure but I believe it was Access Denied . But , I know that the ODBC user/password are valid and I can retreive data. Granting 'update' to a user is done thru a Progress tool? I will get back to you on Tuesday.

We have the Merant 3.6 sql-92 ODBC driver , set up to connect with our progress 9.1D database. I've been developing ,to date, app's which only 'get' data, in mostly vb 6.0 using ADO and recordsets. I now need to to some data modifications , I've been trying to use the .Update method with my...

We have a progress DB ver 9.1D9020 running in support of a Vantage by Epicor Manufacturing Business System. I was working thru the Progress 4GL Tutorials and discovered that my version of Progress does not allow me to alter any databases from the Pprogress tools, not even the sample 'db'...