Search results

  1. jdpjamesp

    Unable to start adminserver and brokers

    Have you tried a Knowledgebase search? This one looks relevant: Progress KB - Error 9908 9909 trying connect to AdminServer on UNIX.
  2. jdpjamesp

    Right approach when using transactions and strong scope to conditional update

    Definitely heading the right way. As Patrice said, the chances of there being an update elsewhere are very slim but if you have to account for it then you're ok. One note though - FIND FIRST should almost never be used. If there really are multiple records that satisfy the FIND then you want...
  3. jdpjamesp

    Right approach when using transactions and strong scope to conditional update

    DEFINE VARIABLE cChanges AS CHARACTER NO-UNDO. DEFINE TEMP-TABLE ttRechnung LIKE Rechnung. FIND FIRST Rechnung NO-LOCK. CREATE ttRechnung. BUFFER-COPY Rechnung EXCEPT Rechnung.RG-DAT TO ttRechnung. BUFFER-COMPARE Rechnung TO ttRechnung SAVE RESULT IN cChanges. MESSAGE cChanges VIEW-AS...
  4. jdpjamesp

    Right approach when using transactions and strong scope to conditional update

    If you define "changed" as a character you should get a list of the changes. I think.
  5. jdpjamesp

    Right approach when using transactions and strong scope to conditional update

    Just to make sure I understand - you want to ensure at the point of locking the record in the new buffer that it hasn't been changed by another process? If so, then you can use the BUFFER-COMPARE keyword to compare the find-customer to the upd-customer and at that point make a decision as to...
  6. jdpjamesp

    Error Radio-Set vertical attribute is not working

    One thread will suffice. I've closed this so there's no confusion.
  7. jdpjamesp

    Question Realese Buffer

    The obvious question is why you want to do that. What are you trying to achieve?
  8. jdpjamesp

    Question Scratchpad Selective Amnesia

    It's superbly good for little snippets of code. I'm with Stefan - if it has meaning it goes into SCM. I use it in 12.2.6 without any issues like you mention. It's still dysfunctional as Stefan says but I never lose code. I don't remember it being a problem in 11.6 either but that was a very...
  9. jdpjamesp

    Epicor - ABL export to excel

    It would help if you would give us the errors you receive rather than just saying it doesn't work. In this case I guess it doesn't work because you need to define the output location: output to value (vCSVFileName) [append]. And you'll need to close the output as well once done.
  10. jdpjamesp

    Database Change Request Form - Template

    Another one to watch out for is changes to the length of an extent.
  11. jdpjamesp

    Database Change Request Form - Template

    I've worked under numerous folks over the years, all with different approaches, but the one that caused the most food for thought was the policy that all schema change requests had to also come with sample data in a .d file. This had a number of purposes. 1) The developer has actually tested...
  12. jdpjamesp

    Question Copy replication trigger assignments.

    Aren't they in the df of the database? Can't you just therefore create an incremental df to load?
  13. jdpjamesp

    ODBC data sources in VBA using .ADP Access forms

    Hi @Ross55, this forum has nothing to do with Pervasive databases. I doubt anyone will be able to help.
  14. jdpjamesp

    Answered Query performance

    It does indeed work. Although I agree with @Stefan that the complication is bad.. FUNCTION MyFunc RETURNS INTEGER (): MESSAGE 111 VIEW-AS ALERT-BOX. RETURN 10. END FUNCTION. DEFINE VARIABLE i AS INTEGER NO-UNDO. DO i = myfunc () TO 1 BY -1: END.
  15. jdpjamesp

    App Server not starting

    Your appserver will have a broker and server log file. These are a good place to look for errors.
  16. jdpjamesp

    Answered Query performance

    In reality assigning the NUM-ENTRIES () to a variable probably makes very little difference, but Tom is correct, that one probably should. I'll leave the religious wars on keyword casing to others. As well as the variable naming conventions. I write my code based upon the conventions of the...
  17. jdpjamesp

    How long has this been wrong?

    o_O
  18. jdpjamesp

    Answered Query performance

    I was a bit busy earlier, but I have had time to write a more efficient solution for the Sports DB as an example: DEFINE VARIABLE cCountries AS CHARACTER NO-UNDO INITIAL "USA,Finland,France". DEFINE VARIABLE i AS INTEGER NO-UNDO. DEFINE VARIABLE cCurrentCountry AS...
Back
Top