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!

Register Log in
  • Congratulations Chriss Miller 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: *

  • Users: WZUP
  • Order by date
  1. WZUP

    Problem with users credential when connecting to SQL server

    Hi, I'm having intermittent problem with users try to run a SSRS report. The web server sometimes prompts the user for their name and password before the app will open. They enter their windows name and password but it still rejects them stating that the credentials are invalid. They can try...
  2. WZUP

    Searching for Table Column values from another Table Column

    All, Found the solution, the only problem was P.Pattern needed to be Rtrim in combination with the other condition SELECT p.pattern, d.ponumber, convert(varchar,h.DOCDATE,106) as PODate, d.itemnmbr, d.itemdesc, d.qtyorder, d.unitcost, d.extdcost, d.vendorid, r.vendname, c.cmmttext FROM...
  3. WZUP

    Searching for Table Column values from another Table Column

    wbodger SELECT p.pattern, d.ponumber, convert(varchar,h.DOCDATE,106) as PODate, d.itemnmbr, d.itemdesc, d.qtyorder, d.unitcost, d.extdcost, d.vendorid, r.vendname, c.cmmttext FROM POP10110 d left outer join pop10100 h on h.ponumber=d.ponumber left outer join pop10550 c on...
  4. WZUP

    Searching for Table Column values from another Table Column

    wbodger This SELECT p.pattern, d.ponumber, convert(varchar,h.DOCDATE,106) as PODate, d.itemnmbr, d.itemdesc, d.qtyorder, d.unitcost, d.extdcost, d.vendorid, r.vendname, c.cmmttext FROM POP10110 d left outer join pop10100 h on h.ponumber=d.ponumber left outer join pop10550 c on...
  5. WZUP

    Searching for Table Column values from another Table Column

    wbodger I've tried that, it returns no results. The first conditions is the only items that will include the p.pattern. The problem I've had with all attempts is p.pattern is being treated as a constant (as a string value) and not the contents of p.pattern. P.PATTERN=2846 d.itemnmbr=Pattern...
  6. WZUP

    Searching for Table Column values from another Table Column

    I'm trying to find PO for each sepecific pattern number if there is one. We are trying to capture the purchasing cost total cost of each one. Since our purchasing people sometimes put the pattern number within the item number I need to try and search for it. There are 3 other fields that need...
  7. WZUP

    Searching for Table Column values from another Table Column

    When I use "and d.itemnmbr like p.pattern" no records are returned. SELECT p.pattern, d.ponumber, convert(varchar,h.DOCDATE,106) as PODate, d.itemnmbr, d.itemdesc, d.qtyorder, d.unitcost, d.extdcost, d.vendorid, r.vendname, c.cmmttext FROM pop10100 h left outer join POP10110 d on...
  8. WZUP

    Searching for Table Column values from another Table Column

    Hello, I need some direction with searching for a value using two tables. I need to search for the p.pattern value with the d.itemnmbr Exmample SELECT p.pattern, d.itemnmbr, d.itemdesc, d.qtyorder, d.unitcost, c.cmmttext FROM pop10100 h left outer join POP10110 d on d.ponumber=h.ponumber...
  9. WZUP

    Content of Text Box not printing on document when printed

    Hello, I have added some comments into a text box which appear fine when the pdf is open but do not appear when the pdf is printed. Any suggestions?
  10. WZUP

    Printer.Print to PDF

    Swi, Check out a product called PDF995
  11. WZUP

    Masking a inputbox response

    SBerthold..Thanks for the link. Kinda of like using a bazooka to kill a fly but nice to now if needed.
  12. WZUP

    Masking a inputbox response

    Is there a way to mask (*) the characters typed into a inputbox without having to create a form to act as one?
  13. WZUP

    Most annoying English phrase?

    in other words........
  14. WZUP

    On error only works once ???

    1st - Where's the END IF? 2nd - Goto Restart - How does user input again?
  15. WZUP

    Cycling through a TDBGrid

    Are your grid rows predefined?(i.e. 100 rows) What is the datamode for the grid?
  16. WZUP

    How to check if a process is already running?

    If App.PrevInstance = True then ......... end if
  17. WZUP

    Stop Command Question (Multiple PID)

    meny21 Try looking into STOP/QUEUE/ENTRY
  18. WZUP

    Congratulations StrongM

    Strongm Same goes for me. You've always came up with the [idea] solutions. Thanks for the time you give!!!! [blues]
  19. WZUP

    need help with error -2147217871 ODBC time out

    try ...ConnectionTimeout = 0
  20. WZUP

    Keep user from ctl+alt+del to kill app

    Without management support/enforcement what else do they expect you to do?

Part and Inventory Search

Back
Top