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

    Cisco Split Tunnel SIP traffic only on edge routers

    I have a full tunnel hub and spoke corporate network with 80+ spokes. I have a new requirement to allow SIP and RTP packets to route through the WAN interface on one of my Cisco 871 without being tunneled back to the corporate head end. The IP PBX provider stated that this will result in lower...
  2. DaveSatIBP

    Crystal 8 with MAS200

    I have Crystal 8 Professional installed on my system. I use Crystal reports within MAS90/200. When I try to print a Crystal report in MAS200, I receive the error PESTARTPRINTJOB - Crystal error detected in database dll. I loaded the MAS200 version of Crystal on another workstation that did...
  3. DaveSatIBP

    3COM NIC & SWITCH PROBLEMS

    We have experienced a similar situation with a Dell Dimension 2100 that has a CNET Pro200WL NIC. I had to set both the NIC and the switch port to 100/full. It was having connectivity issues when set at auto.
  4. DaveSatIBP

    3COM NIC & SWITCH PROBLEMS

    We are experiencing the same issues. We are running MAS90 Client/Server on Dell Machines (3com NICs) connected to Cisco 3548 and 3524 switches. Currently only the servers (Dell w/Intel NICs) are hard coded to 100/FULL. We experience sporatic connection issues and have not been able to pin...
  5. DaveSatIBP

    crpgsvr.exe

    We are running a custom web app that passes data to Crystal 7 via Perl scripts for report generation. Often times the Crystal Web Page server (crpgsvr.exe) appears to not be responding. The service does not stop or crash, it just appears to slow to a crawl. The task manager shows the...
  6. DaveSatIBP

    MAS-90 v. MAS-200; Number of Users

    I belived that MAS200 CS is just a version upgrade from MAS90. We are currently running MAS90 CS v.3.41 and our maintenance support has provided us with MAS200 CS v3.6 Hope this helps.
  7. DaveSatIBP

    Subreport prompts for username and password

    I have a report that currently has one working subreport. When I added two additional subreports to the main report, I now get prompted for a username and password for each of the NEW subreports, but not the original one. After providing the information the reports work correctly. I am...
  8. DaveSatIBP

    Need help with update query

    Terry, After a little tweaking I realized that I needed the following line: where upd.[price level] = pri.plt_id and this solidified my one-to-one relationship. Thanks for all of your help. Dave
  9. DaveSatIBP

    Need help with update query

    Terry, I changed the line in question to: upd.ind_officecode = inv.ind_officecode join and the query now runs without error. When I ran the query I received the message that 591 rows were affected. I had 425 rows in the edwards_unfaced table, how would it have affected 591 rows in the...
  10. DaveSatIBP

    Need help with update query

    Terry, I changed the query like you suggested and now I receive the message: Invalid column name 'officecode' The third table prd_pricing_detail_104 does NOT have field to reference 'officecode'. I am trying to associate the officecode between the first 2 tables edwards_unfaced and...
  11. DaveSatIBP

    Need help with update query

    I tried to simplify my request by using aliases on my initial post, but that might have just confused me further. Here is the exact query that I am trying to run. begin tran update prd_pricing_detail_104 set prd_price = upd.prd_price, plt_id = upd.[price level] from edwards_unfaced upd...
  12. DaveSatIBP

    Need help with update query

    when I try to adapt this sample query into my scenario, the query parses correctly but when I execute it I receive the following error: Invalid object name 'price_details' in the line where my update statement is located. When I run a select statement on price_details I receive output. Any...
  13. DaveSatIBP

    Need help with update query

    I am trying to update pricing through an intermediate table. The 3 tables in question are: updated_prices, inv_detail, and pricing_detail The updated_prices table consists of 3 columns: description, level, and price The inv_detail table has several columns but I would join on description for...

Part and Inventory Search

Back
Top