Search results

  1. jongpau

    Using asynchronous option in Run statements

    Hi, You can only run programs asynchronously on an appServer. Progress does not do multi-threading so you would not be able to do this within a single Progress session (so what you are trying to do now is not possible). Remember, when you do ansync runs on an appServer each running program...
  2. jongpau

    Passing temp-table as parameter and receiving updated fields

    Hi, Try something like this: Create an include ttTest.i /* ttTest.i */ DEFINE TEMP-TABLE ttTest NO-UNDO FIELD custNum AS INT FIELD custName AS CHAR INDEX iDef IS PRIMARY custNum. Next create procedure proc1.p /* proc1.p */ {ttTest.i} RUN proc2.p (INPUT-OUTPUT TABLE ttTest). FOR EACH...
  3. jongpau

    Export the column headers and contents of a browse into a csv file

    Solution 1: Create a new buffer on the table in the browse and then do a for each on that and export the data Solution 2: Do a for each on the table in the browse and export the data (refresh the browse afterwards) Solution 3: Position the browse in Row 1 of the browse with a GET-FIRST on...
  4. jongpau

    proutil (db name) -C conv910

    Hi Sander, Your DLC environment variable is probably still pointing to V9 - this environment variable is used in the proutil script to find the executable that will be running - and if it points to v9 it will of course find and run the v9 version :) Paul
  5. jongpau

    Field LENGTH vs Field Format

    Hi, Length of a field in Progress/OpenEdge means the length of the actual contents, so LENGTH("ABC") will return 3, regardless of the format. However, unlike in other databases, the format of a field really only relates to how it is displayed and updated and does not restrict the length of the...
  6. jongpau

    proutil (db name) -C conv910

    Are you sure you are running the version 10 proutil? Looks to me like you may still be using the version 9 proutil, which of course knows nothing about a 9-10 conversion. Note sure if you have done this, but also make sure you truncate your bi with version 9 berfore running the 9-10...
  7. jongpau

    Starting Databases Automatically

    What do you mean when you say "successfully start"? Do you have error messages in the various log files or does nothing at all happen? Do you have a log of the cron that you can look in for possible other error messages? First thing I would check is to make sure that the required environment...
  8. jongpau

    ODBC and Function Sequence Error

    Hi Tom, There are quite a lot of possible answers to that question, depending on configuration and when the message pops it's ugly head up. If you want to read about those, just go to the Progress Knowledge Base (http://progress.atgnow.com/esprogress/categoryBrowse.do), type "bad swap block"...
  9. jongpau

    which function can convert lowercase character string to capital character string

    That'll be the CAPS function... Try: MESSAGE CAPS("abc") VIEW-AS ALERT-BOX. And just in case you want to know, LC does the reverse: MESSAGE LC("ABC") VIEW-AS ALERT-BOX. HTH Paul
  10. jongpau

    How to accept input parameters in Progress procedure ?

    Don't forget that you can get tons of information (for instance the full set of Progress/OpenEdge documentation) from the psdn (Progress Software Developers Network) website: http://www.psdn.com. Paul
  11. jongpau

    Checking Integrity when Import Text Files

    If I read your question right, this may be what you are after: def var i as int no-undo. Assign i-number = INT(ENTRY(5,cLine)) d-dtsale = IF INT(SUBSTRING(ENTRY(23,cLine),7,4)) <> 0 THEN DATE(ENTRY(23,cLine)) ELSE ? de-csqty = DEC(ENTRY(9,cLine)) NO-ERROR. IF ERROR-STATUS:ERROR THEN DO i =...
  12. jongpau

    Is it possible to undefine a shared variable?

    Aha!! So you may have a very different problem. What exactly IS the problem in relation to shared variables and the AppBuilder that you are experiencing and attempting to resolve? :confused: If you explain this in some more detail, then perhaps people here can be of more help to you :)
  13. jongpau

    External Includes

    Hi, Progress/WebSpeed also know include files. You can reference an include in your code by using "curly braces". For instance in WebSpeed: <script language="SpeedScript"> {myinclude.i} </script> will include the contents myinclude.i in your code. If you use a relative path the file must be...
  14. jongpau

    Difference b/w INPUT THROUGH & INPUT TO

    First of all, I think you mean INPUT THROUGH and INPUT FROM ;) Input through allows you to start another process from within the 4GL/ABL (on the machine you are running your Progress/OpenEdge session on) and read the output of that process - basically a pipe. Input from on the other hand...
  15. jongpau

    Dump data to multiple sheets in a CSV file

    Hi, I don't think this is possible since a csv file is nothing but a flat file that only contains data and delimiters. If you need to create separate sheets you can dump the data into an xml file, with the appropriate tags of course, and save that as an xls, which a modern version of Excel...
  16. jongpau

    Please help - widget position!

    Instead of coding it widget by widget, maybe you can: - Put all the fields you want to move in a separate (child) frame and then just move the whole frame up or down as required OR - Write a little code that "walks the widget tree" and moves the fields (and labels) that need to be moved...
  17. jongpau

    Please help - widget position!

    Move the label to where it is supposed to go after moving the fill-in. The handle of the label is available through FILL-IN-FIELD:SIDE-LABEL-HANDLE.
  18. jongpau

    Is it possible to undefine a shared variable?

    Hi ezequiel, No, this is not possible. The only way to no longer have the shared variable available is to run a procedure that does not declare the shared variable, or to return to a procedure higher in the procedure stack where the variable was not yet declared. In those procedure you will...
  19. jongpau

    Old Dog, New Trick

    Some new 4GL commands between v6 and v10? Man, you must not have read the docos yet :eek: Well, you are fortunate to have skipped the stormy times of Templates and the first shaky versions of the UIB in V7, then ADM1 in v8, which was quickly followed by ADM2 and then a stint of Dynamics (which...
  20. jongpau

    Old Dog, New Trick

    In that case, welcome to the wonderful world of events, methods, objects, functions, appservers, internal procedures, persistent procedures, PUB/SUB, multi language support, the debugger, widgets, dynamic temp-tables, dynamic queries, xml, datasets and so many more extremely exciting things ...
Back
Top