Search:

Type: Posts; User: Todd Forsberg

Page 1 of 72 1 2 3 4

Search: Search took 0.02 seconds.

  1. Replies
    11
    Views
    625

    Re: Details on Mertech INT Files

    ah... I've look there in the past, but sorta forgot about it. Maybe because I didn't find what I needed.

    Thanks Garret
  2. Replies
    11
    Views
    625

    Re: Details on Mertech INT Files

    Thanks. Do you know if there is any documentation on all other possible settings in the .int file?
  3. Replies
    11
    Views
    625

    Re: Details on Mertech INT Files

    What did you find out from Mertech?
  4. Re: SQLSTATE: 42000 - StartTransaction failed:

    Maybe. I'll try anything at this point. :confused:
  5. Re: SQLSTATE: 42000 - StartTransaction failed:

    Yes, my code is very similar, but I did not have any of the Cursor stuff (in red above), so I added it. After, I was not able reproduce the error, but other users are still reporting the error. ...
  6. Re: SQLSTATE: 42000 - StartTransaction failed:

    We are still getting the error, however much less frequently now. I don't know if that is related to this change or just coincidence.
  7. Re: SQLSTATE: 42000 - StartTransaction failed:

    I removed the "commit;" and added just a ";" at the end of the UPDATE statement. Testing it now.
  8. Re: SQLSTATE: 42000 - StartTransaction failed:

    Here is my SQL code...

    UPDATE a
    SET [NOTES] = 'testing customer note' + CHAR(13) + CHAR(10) + 'editttttttttt tesssssst'
    , [RO_YN] = 'Y'
    , [EditedBy] = 'JoeDirt'
    , [EditedAt] =...
  9. Re: SQLSTATE: 42000 - StartTransaction failed:

    Thanks.
  10. SQLSTATE: 42000 - StartTransaction failed:

    We are getting this error.

    WARNING: ERROR: 3988 - SQLSTATE: 42000 - StartTransaction failed:
    New transaction is not allowed because there are other threads running in the session.

    13224
    ...
  11. Replies
    4
    Views
    182

    Re: Temporary Indexes

    As long as all tenants have identically defined tables, then there should not be any issues.

    I am working on a multi-tenant project now also, although it is not in DataFlex.
  12. Replies
    30
    Views
    483

    Re: Incorrect Boolean Logic

    I did not actually try splitting it into 2 statements in my code, but you can see I did split it up in the watch window.
  13. Replies
    30
    Views
    483

    Re: Incorrect Boolean Logic

    Yup! nROCostAmt and nNonROCostAmt are Numbers and ROSEG.TOTAL_Taxes is a table column defined as decimal(10,2)

    But checking the pieces individually was correct.
    (nROCostAmt + ROSEG.TOTAL_Taxes)...
  14. Replies
    30
    Views
    483

    Re: Incorrect Boolean Logic

    So other than just changing the 0 to 0.0 in the expression, is there a better way to do this?
  15. Replies
    30
    Views
    483

    Re: Incorrect Boolean Logic

    Mike, I agree. See my response to you above. I did use "more specific logic" and it still failed. There is still some kind of Integer conversion going on where there should not be.

    For the...
  16. Replies
    30
    Views
    483

    Re: Incorrect Boolean Logic

    Well, that is similar to the actual line of code that made me start this post.

    13159

    The highlighted line is the code that failed.

    In this case, I found that changing the 0 to 0.0 corrected...
  17. Replies
    30
    Views
    483

    Re: Incorrect Boolean Logic

    I think in older versions of DF, a Boolean was really just an Integer, but I think it is now a first class variable type.

    Snippet from FMAC...

    #REM
    #REM Types from Runtime. Command...
  18. Replies
    30
    Views
    483

    Re: Incorrect Boolean Logic

    Also, I noticed that there is no Boolean function like there is for Integer, Date, Number, String, etc..
    ...
  19. Replies
    30
    Views
    483

    Re: Incorrect Boolean Logic

    So a number must convert to an integer before converting to a boolean?
  20. Replies
    30
    Views
    483

    Incorrect Boolean Logic

    Showln (0 or 0) // False
    Showln (1 or 1) // True
    Showln (0 or 1) // True


    All is good above, but here is the problem.


    Showln (0.5 or 0.5) // Incorrectly returns FALSE, should be True
  21. Replies
    22
    Views
    1,021

    Re: VDF-Guidance 20 years

    +++++++1

    Ditto what everyone else said!

    Thanks Wil and all contributors!
  22. Replies
    2
    Views
    104

    Re: Error include proces

    You can't include a CLASS twice.

    My guess is that your views are deferred. If you access the second view before the first view, then the class is not yet defined.

    I suggest to include the file...
  23. Replies
    17
    Views
    1,070

    Re: Can't Open Tables

    This has happened to me again... 3rd time.

    13077

    I know I can resolve it by reducing the overall size of the "paths" of the workspace and all libraries.
    ...
  24. Re: Somewhat OT - MySQL Select Statement

    FYI: This works the same in TSQL. Repeat the escape character to escape itself.
  25. Re: ProgressBar: piMaximum > 2,147,483,647 records

    Ya, I am sorta surprised that I never hit this issue in the past ten years... I have made the appropriate changes. All is working well now.
Results 1 to 25 of 1777
Page 1 of 72 1 2 3 4