Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. TracyB250

    Relative Record Number in a Logical File

    I have a program stuck in a loop that is using a logical. I'm wondering how I can find the record within the physical. I assume the I/O record and relative record number are referring to the logical and not the physical. Is there anyway to display a relative record number in a logical...
  2. TracyB250

    Cannot do INSERT INTO

    Thank you all for your input. Removing the alias did the trick!
  3. TracyB250

    Cannot do INSERT INTO

    I had already tried that. I get the same error. :(
  4. TracyB250

    Cannot do INSERT INTO

    I am new to SQL and am having difficulties inserting data into my file. I have two files. Both the priority_address and the mailing_address files have the exact same layout: PRIORITY ACCOUNT TENANT ADDRESS1 ADDRESS2 ADDRESS3 ADDRESS4 CITY STATE POSTAL The Priority_Address file may have up to...
  5. TracyB250

    Select Query in Access 2007

    Worked beautifully!! Thank You!
  6. TracyB250

    Select Query in Access 2007

    I have a make table query in Access 2007 that has a city field that is in all caps. I want to convert the city to lower case, but I want the first letter of each word in the city to be capitolized. Is this possible in the expression builder? If I use LowerCity: LCase([B5CZTX]), all words in...
  7. TracyB250

    Updating a packed field

    Please disregard my previous post. We found that all we had to do was an SQL: update supportq/csb6rep set b6klnb = b6klnb where b6klnb > 9999
  8. TracyB250

    Updating a packed field

    I have a packed field that is 4.0 long but when you look at it in hex the first and last positions are not valid. I have a field that looks like: 217 60C the 6107 is valid, the 2 should be 0 and the C should be F. Is there a way to write an RPG program to fix this problem? I have not written...

Part and Inventory Search

Back
Top