Results 1 to 5 of 5

Intrinsic value of true.

  1. #1
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 10 Access 2016
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    649

    Intrinsic value of true.

    Wednesday I encounted a bug where a query that ran with the value set to -1 for years... stopped working in every query. I had to change everything from -1 and 0 to true and false, has this happened to you?
    Patience serves as a protection against wrongs as clothes do against cold.

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    6,840
    Never, they are all the same:
    yes/no
    -1/0
    true/false

    if anything, -1 would work and true would fail.

  3. #3
    Perceptus's Avatar
    Perceptus is offline Expert
    Windows 10 Access 2016
    Join Date
    Nov 2012
    Location
    Knoxville, Tennessee
    Posts
    649
    I know right? If anything it should have been the opposite. Reverse big endian returning memory leak from hell I guess.
    Patience serves as a protection against wrongs as clothes do against cold.

  4. #4
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    4,406
    stopped working in every query.
    Curious as to what this means.
    0 is always false. True is anything else.

    Maybe somebody changed a comparison somewhere from (e.g.) x <> 0 to x = -1 (or x = 1) ? The former is better because, as I said, 0 is always False.
    Something had to change to cause the 'failure'. Methinks even a windows update could cause it.
    - "doesn't work" is no help. Post err msgs and where.
    - Use code tags for code/sql. Implement changes in copies of your database.
    So, like, why do you, like, start a sentence with, like, "so"?

  5. #5
    GinaWhipp's Avatar
    GinaWhipp is offline Competent Performer
    Windows 7 64bit Access 2013 32bit
    Join Date
    Jul 2011
    Location
    Ohio, USA
    Posts
    141
    This happened to me years ago and if memory serves me correctly it was because the Backend was upsized and -1 which is True in Access was not so for the Backend but True was True no matter what backend I upsized to or what language I was coding in. So, I just switched to True. Okay, that doesn't explain why it suddenly broke... just food for thought,
    Gina Whipp
    Microsoft MVP (Access 2010-2015)
    https://www.access-diva.com/tips.html

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Intrinsic Constant Names
    By yeah in forum Programming
    Replies: 14
    Last Post: 05-13-2018, 04:41 AM
  2. Replies: 8
    Last Post: 10-06-2014, 02:02 PM
  3. If value is true... Cannot be used.
    By DTK0902 in forum Access
    Replies: 6
    Last Post: 11-27-2012, 06:49 AM
  4. Intrinsic filter tool undoes itself?
    By ConfusedDatabaseDesigner in forum Forms
    Replies: 1
    Last Post: 07-20-2012, 08:41 AM
  5. If any of the following are true
    By Steven.Allman in forum Queries
    Replies: 7
    Last Post: 08-30-2010, 05:10 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums