Search results

Yep, that did it. Thanks! Tamhas, I want to join two tables together in a temp-table, but one of the tables has a unique index for one of its fields.

I have a dynamic temp-table that can be like any table the user enters. However, I don't want the temp-table to have any of the source table's indexes. Here's my code: DEFINE INPUT PARAMETER tableName AS char. DEFINE VARIABLE ttxxMult AS HANDLE. CREATE TEMP-TABLE ttxxMult...

Thanks! The more I learn about auditing in OpenEdge, the more I like it. :D

Progress: 10.2b SP7 OpenEdge Architect: 3.4.2.R342_v20090122-9I96EiWElHi8lheoJKJIvhM3JfVsYbRrgVIWL OpenEdge OS: Windows 7 Professional 2009 SP1 We need to keep a log of our users' changes to tables and fields. Specifically, we need: to select which tables and fields to log, to log who made the...

Progress: 10.2b SP7 OpenEdge Architect: 3.4.2.R342_v20090122-9I96EiWElHi8lheoJKJIvhM3JfVsYbRrgVIWL OpenEdge OS: Windows 7 Professional 2009 SP1 Is there a way to suppress alert box messages or reroute them to an output file? Is there something like "quiet mode" in OpenEdge?

The "use-index" phrase was in the old code. (Not a great reason, right? :)) I should probably clarify: I want to do a join without needing to explicitly check row ids if that's possible - unless that would require a behind-the-scenes row id check anyway.

So I guess I can't make it any faster than 30 seconds? Darn. Well, I figured out how to query the table itself, and that seems to help. Unfortunately, the browse also needs to let the user sort by column and/or search for records beginning with a string. This is how I'm trying to solve this...

You could use a regular expression. This article is a good starting point: http://knowledgebase.progress.com/articles/Article/000039027

0) It takes about 30 seconds to read the table. 1) I'm not sure. It might be possible to query the base table itself. The trick is getting the existing code to cooperate. 2) Raising the -tmpbsize from 4 to 8 did help performance slightly. 3) I'll try that and see if it improves performance...

I'm populating a dynamic temp-table for a browse widget. The user can request: the table, the where condition, and which fields to show. However, sometimes users want to see an entire table. In one example, such a request results in 137,656 entries in the browse widget temp-table and a 67...

Okay, thanks! I think I was confused because this code... DEF VAR searchString AS CHAR. searchString = " ". DISPLAY (searchString = "") /* true */. ...lead me to believe that a single space is always treated like a blank space, even in a BEGINS statement.

I'm having trouble setting the current column of a browse widget: CREATE BROWSE hBrowsePopup ASSIGN FRAME = FRAME popupFrame:HANDLE QUERY = hPopupQuery TITLE = "Select" COLUMN = 1 HEIGHT-CHARS = 10 DOWN = 10 SENSITIVE = TRUE READ-ONLY = TRUE COLUMN-SCROLLING = TRUE...

Is it possible to store blank spaces in a character variable? By default, if a character variable contains only blank spaces, then Progress treats the value as a blank string. For example, the following code would display "yes": DEF VAR searchString AS CHAR. searchString = " ". DISPLAY...

Okay, thanks! I'll see if I can find it.

Is there a way to turn off emoticons/smilies in a post? It's kind of annoying when I type in something like "frameName: Parent" (no space) and end up with "frameName:parent."

Is there any way to set a frame's X (column) and Y (row) coordinates relative to the current screen without regard to any parent frames? In other words, how can I place a frame at the center of the screen, not the center of the frame's parent frame? This is my current solution: frameColumn =...

Why shouldn't we use it? Is it because validation expressions can't be found in the code?

Setting the browse's NO-VALIDATE value to TRUE fixed the problem. In my case, this is a safe maneuver because the user only selects from the browse list; my program does not allow the user to update entries within the browse widget. (By default, the validation expression of a dynamic browse...

Aha! I found that expression for item.prod-code: can-find(PRODMSTR of ITEM) Whoever set up the item table must have done that. Makes sense. Is there some work around to this error? I think I'm getting it when I run ADD-LIKE-COLUMN.

I created a program that can receive parameter values and use dynamic queries and buffers to create a browse widget in a popup window: /* *************************** Definitions ************************** */ ROUTINE-LEVEL ON ERROR UNDO, THROW. /* ******************** Preprocessor...