Search results

  1. G

    Iops

    Thanks for replying Tom. We have an existing system and running out of resources. We're looking to purchase a new SAN - but we're trying to get our cost in line with resource requirements. Right now, we have 3 databases running on the same server - the biggest being about 20 gig. We have 150...
  2. G

    Iops

    Was wondering if anyone has any data regarding IOPS (Input/Output Operations Per Second) for QAD? We are trying to spec out a server and it would really help to know if this data exists.
  3. G

    Hardware for QAD 2009SE

    We are in the planning stages of the upgrade and I'm wondering if anyone has a reflection on hardware. If you are running QAD 2009SE, what you are running it on now? Do you recommend it? What is the new standard for this version? Thanks! Any information would be helpful.
  4. G

    Creating Monthly/Weekly Buckets

    Thank you!!!! That really helped to point me in the right direction.
  5. G

    Creating Monthly/Weekly Buckets

    I've been trying . . . . working with this all week now. I can get the header info to display by week, but I'm not getting the sum by week. Here's what I have - can someone review and tell me where I'm making the errors. This code is VERY slimmed down to simplicity (I took out form, display, and...
  6. G

    Creating Monthly/Weekly Buckets

    Thanks vinod_home for the info! That makes sense now. Still looking for an example on grouping data by week though. Let's say v-begin-date is 2/1 and v-end-date is 2/28. How would I group the below by week? So I would have a 4 week column report. for each schd_det no-lock...
  7. G

    Creating Monthly/Weekly Buckets

    Does anyone have an example of grouping data by week? Please . . .
  8. G

    Creating Monthly/Weekly Buckets

    Hi All, I have the below code that is somewhat confusing to me - being new to the 4GL world. I'd like to get and explanation and also ideas of how to bucket this up from monthly to weekly. I rem'd some of the monthly code out and substituted weekly. I tried to cut it down to make it more...
  9. G

    Calling Program

    Perfect!! Thanks much!
  10. G

    Calling Program

    I have program abc.p and def.p. They both call ghi.p. How can I tell which program called ghi.p? I've tried execname with no luck.:blush:
  11. G

    Cache?

    Nope - only 1 copy. Plus only 1 folder for r code. That would be \custom\us\xx
  12. G

    Cache?

    I looked - no r-code. Lots of *.pl in the propath though.
  13. G

    Cache?

    Thanks TomBascom. That does help. I'm just really baffled here. It's not just 1 program but a few. Most of the custom programs were not written by me - and I'm new to this - so it's still a little fuzzy. But . . . how can a custom application act differently based on the database. The...
  14. G

    Cache?

    The propath for the custom dir is first in line in both databases. Do you think that compiling against both databases is the issue? If I have one custom directory with 2 databases. Do I need to compile against both databases even though the file name/path is the same? Someone suggested that...
  15. G

    Cache?

    Hi All! We have 2 databases all using the same custom code path. I changed some custom code and it works fine in one database - but not as expected in another. What was changed was a label and some math. I see both the label and math changes in one database but only see the label changes -...
  16. G

    Like or begins or matches

    Sorry - works fine. My error was in another part of my statement. I just assumed it was the LIKE statement. Never mind . . . :lol:
  17. G

    Like or begins or matches

    I don't seem to be able to find the SQL equivalent to LIKE. What would be the Progress equivalent to the below? (abs_par_id LIKE 'sPL%') AND (abs_id LIKE 'isPL%') :biggrin:
  18. G

    Printer UNC

    Yes, I pulled the document as it's not my code. It's from a consultant company and I'm not sure what kind of trouble I can get into with displaying it publicly. Is there a way for you to view it only? Can I email it to you? I CAN view it on the *.prn. It is not displayed on the "page"...
  19. G

    {&soivrp10-p-tag38}

    That's very helpful! Thanks much!
  20. G

    Printer UNC

    I would appreciate it so much! This is an example document where the unc path will display. It only happens when you output to printer though. I usually pause the printer and grab the .prn file out of the spool dir. Output to page will not display it. I just can't figure it out! It must be in a...
Top