Search results

  1. cmorgan

    Replace character in a field

    If you want to replace multiple characters with different values, you might also want to take a look at the SUBSTITUTE function.
  2. cmorgan

    Finding the clients IP address

    You should be able to get the client's name from the _Connect VST. Then you can do an nslookup to get the IP. HTH
  3. cmorgan

    Slow performance appserver terminal server

    I don't know much about performance tuning on Windoze, but here are a couple of things to look at. First, you mention that you are using AppServer on this Win2K box. Are the clients and the databases also on this same box? If not, how is the AppServer connecting to the database, and where...
  4. cmorgan

    New Test DB

    Whoa. You can't bring a database directly from linux to Windoze. You'll need to dump and load if you want to change platforms.
  5. cmorgan

    Open Edge 10.0 Requirements

    Pete, OE will take advantage of whatever processing power the OS gives it. Whether you have 1, 2 or 4 processors is transparent to the RDBMS (athough you can use -spin to tune performce for mult-processor systems). Assuming you are using a 32bit OS, each database can only reference (about)...
  6. cmorgan

    creating records based on long, delimited variable.

    Try something like this: do i = 1 to num-entries( temp1, " " ): create tablename. assign tablename.fieldname = entry( i, temp1, " " ). end. /** i **/ HTH !
  7. cmorgan

    Platform Change Rules - Anyone else irritated?

    In the past when PSC has dropped support for a platform (VMS, CTOS, etc) they have waived the platform change fee for users of those platforms. Solaris Intel and SCO Openserver are likely candidates for this exception in the near future.
  8. cmorgan

    Executing a 4GL procedure

    <I>There is a server running for this database. I know this because Tyler know's this.</I> Really? Try 'pro' instead of 'mpro', just to be sure.
  9. cmorgan

    Whats new in 9.1C?

    There are a few new things: 1) 4 action segments instead of one, addressing the 64k limit. 2) The 2Gig file size limitation is gone. 3) Intellistream (an instalation/update manager for WebClient) There are probably more new features and bug fixes, but these are the ones I can...
  10. cmorgan

    Extracting Lots of Data

    If this is a one-time event, you might be better off writing a 4gl procedure to export the data to a text or csv file, and then loading that into Access. What type of progress license do you have?
  11. cmorgan

    Search by an string (use matches)

    How about this: Def var x as char no-undo. assign x = freply("andré") for each table where table.name matches ( "*" + x + "*" ) no-lock: create table2.....etc etc.... end.
  12. cmorgan

    Search by an string (use matches)

    I know it isn't an ideal solution, but you could try something like <PRE><BIG> display "a" matches replace( YourString, "á", "a" ). </BIG></PRE> You could even write a function to handle all of the relevant replacements, so you could write <PRE><BIG> FUNCTION ReplFunction returns...
  13. cmorgan

    Clearing Fill-in help message.

    If status default doesn't work try status input. status input "Your message here". You could also try changing the help message for the field in question: YourField:HELP = "".
  14. cmorgan

    Clearing Fill-in help message.

    Try adding a status default and/or status input line. For instance: status defualt "processing...". or even status default "". HTH
  15. cmorgan

    Return Value from Selection-List

    The symptoms you are describing could be the result of defining your selection list with LIST-ITEMS instead of LIST-ITEM-PAIRS. Also, be aware that there is a bug with LIST-ITEM-PAIRS, where you cannot use the same description twice for different values. HTH
  16. cmorgan

    Uninstall Progress

    <I>If you answered yes to "Copy scripts to /usr/bin", delete any progress scripts in this directory. </I> There are a couple more that don't start with 'pro': /usr/bin/rfutil /usr/bin/mpro /usr/bin/bpro /usr/bin/mbpro /usr/bin/asconfig /usr/bin/asbman /usr/bin/genpassword...
  17. cmorgan

    My problem...

    There are many ways to skin a cat, but this is an example (untested) of how I might do it.... Define variable SOTotal as decimal no-undo. Define variable WRTotal as decimal no-undo. for each tablename no-lock break by tablename.item: if tablename.trans-id eq "so" then assign...
  18. cmorgan

    procgi

    You'll need to edit procgi.pl and procgi.cfg to alter the path and propath environment variables. There are also sections in procgi.pl that manipulate various path variables using a "/" (forward slash). You'll need to change those sections to use a backslash. HTH
  19. cmorgan

    Midlevel Progress Programmer - Clearwater, FL

    33 year old established company in beautiful Clearwater, Florida is looking for a midlevel Progress P/A. Some GUI experience is a must. Other usefull skills include ChUi Progress, SCO Unix, Linux, HTML, data conversions, and accounting and/or ERP experience. Contact: Scott McIntyre...
  20. cmorgan

    Replication Question

    Replication First, let me suggest that you look into upgrading to version 9. V9 has some nice replications features built in. If you are stuck in v8 then read on. I've been down this road in v6 and v7, and let me tell you - it was no fun. What we did was add a new table to the database...
Top