Search results for query: *

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...

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...

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...

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...

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...

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...

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...

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...

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?

Swi, Check out a product called PDF995

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

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

in other words........

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

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

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

meny21 Try looking into STOP/QUEUE/ENTRY

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

try ...ConnectionTimeout = 0

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