Search results

Thanks, Stefan. So there's no way to pass a variable array or a string list of fields to an update or set statement? You have to handle it through the fill-in widget? If so, I'd like to understand why this is the case.

Progress: 10.2b SP7 OpenEdge Architect: 3.4.2.R342_v20090122-9I96EiWElHi8lheoJKJIvhM3JfVsYbRrgVIWL OpenEdge OS: Windows 7 Professional 2009 SP1 I’d like to create a function which receives a record or list of records. If a user has Can-Read rights to a field in that record, then the program...

I guess a size limit would reduce fragmentation and force users to enter information correctly in some cases, but I doubt that advantage outweighs flexibility.

Aha! Thanks! That's good to hear. Makes my life easier.

Progress: 10.2b SP7 OpenEdge Architect: 3.4.2.R342_v20090122-9I96EiWElHi8lheoJKJIvhM3JfVsYbRrgVIWL OpenEdge OS: Windows 7 Professional 2009 SP1 I need to use the Can-* fields in _File and _Field to specify database rights for lists of users. However, the Can-* fields are Character x(63) by...

Aha! Got it. Thanks!

Just as a best practice, you might want to add a function to your .p file that checks for the right number of arguments: IF NOT NUM-ENTRIES(SESSION:PARAMETER) = 2 THEN DO: OS-COMMAND echo "Wrong number of arguments!". /*etc.*/ END.

Thanks, RHD. I'm trying to create a new authentication domain for my database, but I can't choose a type (see screenshot). My database uses auditing, so what else am I missing?

Progress: 10.2b SP7 OpenEdge Architect: 3.4.2.R342_v20090122-9I96EiWElHi8lheoJKJIvhM3JfVsYbRrgVIWL OpenEdge OS: Windows 7 Professional 2009 SP1 I want to assign permissions based on which group(s) a user belongs to rather than using individual user names. In my permissions table, could I use...

Aha! Now why didn't I think of that? Thanks!

Is it possible to use optional parameters in OpenEdge 10.2.b? For example: METHOD PUBLIC VOID createAllLog(INPUT isConcat INITIAL TRUE): IF isConcat THEN DO: ..... END. END METHOD. ..... /*call the function within the class:*/createAllLog(). createAllLog(FALSE). I know that 10.2.b has...

Works like a charm! Thank you, Larry! By the way, I had tried using "DOWN" in my "DO" block, but it didn't work: DEF VAR array AS INTEGER EXTENT INITIAL [1,2,3]. DEF VAR lv-i AS INTEGER. DO lv-i = 1 TO EXTENT(array): DISPLAY array[lv-i] WITH FRAME A DOWN. END. It seems that wasn't...

Cringer, my loop works fine. My problem is getting the entire array to display on a frame. Currently, I only know how to display the array elements one at a time. Here's my current code: DEF VAR array AS INTEGER EXTENT INITIAL [1,2,3]. DEF VAR lv-i AS INTEGER. DO lv-i = 1 TO EXTENT(array)...

How can I display the contents of a dynamic array as a list within a frame? For example, let's say the array contains "1","2","3". I want to display those values like this: 1 2 3 So far, I can only display them one at a time. I'd rather not throw those contents into a temp-table if there's...

Ah, I see what you mean. We could include the port numbers in the preference files, and that would require a preference file for each environment. Fortunately, we only have three environments, so our current approach is reasonable. If we had dozens of environments like you do, then it wouldn't...

When you say "changing the port number," do you mean the actual port number for the database or the parameter we pass to the program? In the case of the former, I've written the program so that it throws an error if it does not recognize the port number. If someone in IT decided on a whim to...

You could run prodict/load_df.p (or whatever program calls it to run) in batch mode and pipe the output to a file. That way, the program can run without your input, and you can see the errors in a file. Is that what you're trying to do?

Thank you for your help! Since you asked why I'm doing this: I'm using three different environments: live, testing, and development. Each environment uses a different database. When I run my program, I must pass the port number as a startup parameter to connect to the correct database. By...

We launch Progress with a “–S 2640”. At runtime, how can we find out what our –S value is within any program? Progress: 10.2b SP7 OpenEdge Architect: 3.4.2.R342_v20090122-9I96EiWElHi8lheoJKJIvhM3JfVsYbRrgVIWL OpenEdge OS: Windows XP Professional 2002 SP3

Good explanation. Thanks, RHD.