Search results

  1. L

    Answered Binary D&L from 10.2B08 to 11.7.5

    We are moving a customer to a new server and converting the db from 10.2.B08 to 11.7.5. Is it possible to do a binary dump on the 10.2.B08 server and load the binaries directly into the 11.7.5 db or do we need to move the db to the new server, conv1011, then do the dump and load into an empty...
  2. L

    Question Import from a dynamic CSV

    Unless I don't know what else you need to do, I think you are overcomplicating this read a file, put out another based on some condition on the input line? Here is a simple read a line no matter how many columns, and put it out based on a condition: def stream a. def stream b. def var myline as...
  3. L

    I need some advise

    I have to agree with all of Rob's points... and here are other factors: Do you have replication? That is a separate cost to the reseller per user and hence to you. Do you have an AppServer or PASOE? That too has a separate cost. Do you have other licensed OpenEdge products that are included...
  4. L

    Progress kbase acting strange?

    I received this email titled "Progress Support Enhancement: New Search Capabilities " Powerful Search Capabilities – At Your Fingertips Searching for Progress product and support information and not finding what you need? Now when you search the Knowledge Base, Documentation and...
  5. L

    Error OVERLAP FACTOR

    when I googled "Team Boscom", it said Did you mean: team bascom However, "Team Bascom" came up with about 1,280,000 results. Big Tommy B is so popular and so awesome.
  6. L

    Question HOW DO I MODIFY THE ISO DATE FORMAT MASK?

    Cecil, While a bit 'old school', we've had to do this too within XML. What we did was define the variable as a character, then set it to iso-date(today) + "T" + string(mytime,"HH:MM:SS")
  7. L

    Question more efficient query to modify

    Good catch Rob on the FIRST -- cut/paste/not paying attention error on my part. And thanks for the clarifications on the ROWID -- we changed years ago but I couldn't remember the exact reason other than it is deprecated.
  8. L

    Question more efficient query to modify

    You want to keep your transaction small and concise. Also, "RELEASE" does not do what you might think -- it is pretty much unnecessary. Try this: DEFINE BUFFER bCustomer FOR CUSTOMER. do for bCustomer TRANSACTION: FIND FIRST bCustomer WHERE RECID(Customer) = RECID(CUSTOMER)...
  9. L

    What is the fastest way to move a very large table to a new area.

    If paid by the hour, I would use proutil tablemove. Could be a wash with the data dictionary.... :)
  10. L

    Lighttpd as an Alternative to Apache or IIS

    Just saw something on the Progress forums on this... lightppd
  11. L

    Dynamic Query which might contain " or ' quote marks

    Can you try using a back slash to escape the single or double quotes?.... but that may or may not be *nix only.
  12. L

    Thank you

    Tom, looks like they took your post to heart.... the latest batch of spammage doesn't have the 'http'. :(
  13. L

    FIND FIRST

    Tom, don't blame Cringer! He got that from my code example which was cut/pasted from the original poster.... I did not retype it just added my .01999 worth to which Cringer added his improvement ... On the upper/lower casing and using abbreviations -- we all have our own styles. ;)
  14. L

    FIND FIRST

    First of all, something you must do: ALWAYS specify the type of locks (NO-LOCK or EXCLUSIVE-LOCK) when reading records from any database table table. Otherwise you are asking for lock table overflows and locking issues with other users. as to your code you posted, it makes absolutely no...
  15. L

    RPG

    My fist programming job was using RPG in the early 70's with an IBM 360 96 column card system. So Pete, it looks like back to the future?
  16. L

    Thank you

    A sincere thank you to forum management for always cleaning up the spambot garbage that periodically shows up in spurts on these forums. Much appreciated.
  17. L

    Write an ABL which captures the triggers of Customer table and stores it in a table "EventLog" (action,time,date,oldvalue,newvalue).

    What have you tried that doesn't work (post code for this)? What is the context? Program, db trigger, something else? I'm not sure what your question is with such a vague post other than asking for someone on this forum to write some code for you.
  18. L

    10.2B Obsolete - how to encourage customers to upgrade

    To me, the biggest issue facing our customers that are on 10.2B08 is which version of OS's (in our case RH and Centos) are supported by 11.7.x. Upgrading OS's is not always a simple task.
  19. L

    validation function and continue statement once validated

    Note that it won't work as written with the update statement. I also would strongly suggest calling the frame name something other than the same as the variable name. However I agree with Osborne as using event driven ENABLE .. WAIT-FOR. . Should be: DEFINE VARIABLE username AS CHARACTER...
  20. L

    Using Dates with ADD-INTERVAL

    ummm... did you try to Google for it? --- look at DATEADD but I have no idea if it works with the SQL 92 in OE.
Back
Top