Recent content by ASPI

  1. A

    Looking for the last record

    improvement There's somewhat of an improvement. Still takes longer than my user's patience. This is a program for our receiving department. FIND LAST WhseBin WHERE WhseBin.Company = CUR-COMP AND WhseBin.WarehouseCode = "ASP" NO-LOCK. DO WHILE LENGTH(WhseBin.BinNum) <= 4...
  2. A

    Looking for the last record

    Opps it's actually >4 Good catch, but my code actually says ">4". That being said if I run the code without my exclusions I'll get the last number as being "U5021". Sorry for my mistake. FIND LAST WhseBin WHERE WhseBin.Company = CUR-COMP AND WhseBin.WarehouseCode = "ASP" AND...
  3. A

    Looking for the last record

    Hmm Yea that's what I'm thinking. It's just got a bunch of records to search through. So are there any ideas out there for juicing up this search?
  4. A

    Looking for the last record

    index For index see above
  5. A

    Looking for the last record

    I've got a bin # table that has about 26,000 records in it(A001 TO Z963). We recently changed our bin numbering system to start with AA001. Also in the bin record there are a few erronious entered bin#s. It's taking too long to find that last record. Below is my snippet of code. Is...
  6. A

    Clienttimeout & Vantage by Epicor(how do U make it work?)

    what I've found There is a known bug in Clienttimeout with Progress 9.1C. I found this out from my software vendor. Has anybody discovered a workaround for this? I'm using the Vantage manufacturing package produced by Epicor.
  7. A

    Progress 9.1D release date

    Does anybody know when will be the possible release date for Progress 9.1D?
  8. A

    Clienttimeout & Vantage by Epicor(how do U make it work?)

    We are currently trying to upgrade from Vantage 4.0 (using Progress 9.0B) to Vantage 5.1(using 9.1C). Whent the Clienttimeout is added to the registry key for HKeylocalmachine it crashes the database. Does anybody have any insight into this?
See more
Top