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...
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...
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.
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...
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...
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.
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...
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
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.