Search results

No problem. If you hit any problems, post questions. I've done this here to put our Dev and Test WSAs on the same server as two seperate instances.

If you want native multi-select, you're going to have to use a multiple-select browse widget as opposed to the standard browse used by a smartDataBrowse as default. Not sure that this is available in v8 though. Time to upgrade! Back in the day, when dinosaur-shaped single-select browse...

Try: IF chWorkSheet:Cells(3,1):VALUE = "200" THEN.... You may need to cast the value around into decimal variables for your purposes.

Hi there, Yes, this is very possible. Have a look at KB P91699, which explains how to do this. Basically you take another copy of the WSA installation directory, copied to the webapps directory on your webserver, and configure the new web.xml as required.

On the database server side of things there is a pool of memory (determined by the -B database startup parameter). When records are read for the first time, they are placed in this buffer pool. Subsequent reads then appear much faster because they are retrieved from the pool as opposed to...

You could try using PUT UNFORMATTED?

I did a conversion from 9.1D to 10.1A a few years ago. We moved to v10's ADM as well as converting the database, and found very few problems (the worst one was a few badly-behaving SBOs, but that was related to the crazy way the original developer decided to use them in the v9 app). In...

Hi there! What version of Progress are you using? We've done lots of work on webservice generation and hosting here using v10.1A, and here's a quick run-down of the components involved: 1. Create and configure an appserver, connected to your host database. 2. You now need a webserver. We...

A dialog is a FRAME with a view-as phrase, so the simplest way is to fiddle with the FRAME's attributes: ASSIGN FRAME {&FRAME-NAME}:HEIGHT-PIXELS = 200 FRAME {&FRAME-NAME}:WIDTH-PIXELS = 200. Be aware that you should move field-level widgets around (fill-ins, combos, etc) before...

The problem is here: I know nothing about the table M_polcostos (is it a real table or temp-table? How is the data arranged?). But if the FIND is failing because more than one record is found, then that's where the problem is. First off, you need to add NO-ERROR to suppress any standard...

The use of FIND does NOT automatically result in a full-table scan using WHOLE-INDEX. If your FIND or FIND FIRST doesn't pick a "good" index, then you run the risk of a full-table scan either way. I guess the point is to ensure that any FIND (FIRST or otherwise) uses a correctly-defined...

Automating Excel is generally a slow process when compared with a flat extract to text (or csv file). Each COM operation has an inherent overhead that's difficult to avoid! The only suggestions I can give: 1. I've seen a variety of anti virus packages get involved with Excel automation...

It generally takes a large volume of data to cause a stack overflow with a recursive call like the one you posted. Have you examined the data to make sure it's not faulty? Say, for example, the data relationship could be incestuous with a grandchild parenting its grandparent, resulting in an...

It's perhaps best to consider CAN-FIND as a logical interpretation of the following statements: FIND [FIRST] table WHERE <some-criteria>. IF AVAILABLE table THEN RETURN TRUE. ELSE RETURN FALSE. (although the CAN-FIND wouldn't actutally read the contents of the record) Now, if...

Doesn't work on my 10.1A02 here. Looks like the ENTRY function doesn't support longchars when using it for assignment purposes. In your example, this works: message entry(35000,cc,',') view-as alert-box. So, reading the entry works. However, when you try to assign a value to the...

As Tom said, in an ideal world there shouldn't be a need to use USE-INDEX. However, in the real world we sometimes have to work with badly-designed database schemas which use many crazy indexes, and we can't change them for one reason or another. In those cases, the use of USE-INDEX is pretty...

Or, if your list doesn't have guaranteed delimiters, use the INDEX function: DEFINE VARIABLE cString AS CHARACTER NO-UNDO. cString = "23146-P-006". MESSAGE INDEX(cString,"-p") VIEW-AS ALERT-BOX INFO BUTTONS OK.

You can use the buffer handle of the table to loop around each field of a table and grab the field name (and value if you so require): DEFINE VARIABLE hBuffer AS HANDLE NO-UNDO. DEFINE VARIABLE iLoop AS INTEGER NO-UNDO. DEFINE VARIABLE hField AS HANDLE NO-UNDO. hBuffer =...

Hi there, You need to establish a method of grabbing the combo-box value from within the viewer. There are lots of potential methods of doing this - here's an example: 1. In the smartDataBrowse, on value-changed of the combo, set a user property in the container with the combo's screen-value...

You can modify the master of folder.w. It's in src/adm2/folder.w. You just add the function, ship it out with your application as normal, and then every screen which uses folder.w will have access to your fantastic new function! It's the very essence of object orientation. If you're not up...