Results 1 to 5 of 5

Thread: Query Issue

  1. #1
    Join Date
    Oct 2011
    Posts
    71

    Unanswered: Query Issue

    Good Morning,

    I attempting to place specific individuals into a table. The individuals are selected by a 7 to 10 digit unique number. There is a query I use to place the individuals into a table and ensure they are part of the roster. And this works, for the most part.

    The issue is when the number becomes a 9 didgit number it stops working. It says it cannot find the individual and errors out. Anything less than the 9 didgit number works perfect.

    The fields are all set the exact same.

    Anyone have any ideas as to what might be causing this?

    I appreciate your time, thoughts and knowledge.

    Thanks

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    without seeing your query and table design then its down to peering at a crystal ball...


    sorry can't help you the crystal ball needs a d*&^(*&n good clean...
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Oct 2011
    Posts
    71
    So attatched is a map of qry

    Basically I want to track each clients invovlement in an event.
    the ACCESS_CLTMST is an ODBC this is an AS400 system.

    I use the qry_ClientInfo to put to gether the information into useable and friendly information. So when a number is put into the tbl_ClientInvolved it will bring up their name and other info plus ensure the number is valid.

    The Primary Keys in both tables are the exact same data type. This works perfectly on anything with 8 digits or less.

    If you need more info let me know and I'll give what I can.

    Thanks!
    Attached Thumbnails Attached Thumbnails qry_Map.jpg  

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Still not seeing the table design (the column types, sizes etc
    nor the SQL

    as you report the problem is when using a nine digit number
    my guess is that you have stored a number as text (which is nearly always asking for trouble)
    somewhere in your design I suspect you have a column size of 7 and in another table 9 digits or noweher is it allowed to have a 9 digit unique number

    it could also be a formatting issue (ie in one form there is a format mask
    it could be that there is something in one of the joins
    it could be a limitation in the db running on the AS400
    it could be somethign to do with the ODBC connection
    who knows
    ,,in the absence of your SQL and table design certainly we don't
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Oct 2011
    Posts
    71
    Thanks for the help. I just cloned the table recorset, put the information in through an update, and it works. Can't update it through the query, but with the information in the table the query works just fine.

    Very odd, don't know. As I said the two fields were set to the exact same data type. both Long Integers. As far as queries they were all basic select queries nothing fancy. Done these queries a thousand times now.

    Anyways thanks. Again

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •