Search results for query: *

Hey thanks...Ill see if I can test it. I appreciate your assistance.http://www.tek-tips.com/

Hello, The past couple of days I'm getting these errors on an old Intuity phone system. While the system is booting I get this: cannot allocate controlling tty on "" there maybe another session active on this port and after I log on this scrolls constantly: SA "su - spm - c "/spm/spm319...

I do appreciate your comments. However, since the individuals that would use the wireless network would already be logged into the Domain WAN via their username / password, this would not pose a security risk at all. My whole facility is Wireless running SAP WM. I'm simply trying to automate...

I would appreciate some comments / examples on how I could create a batch file or script that when executed would completely configure a Cisco 350 NIC and connect to my Wireless environment. I have a large number of visitors coming into the plant that have wireless capabilities, but constantly...

Thanks for having a look at my problem. CR 8.5 VB 6 I am trying to display multiple values derived from a recordset loop to show on my report. I can see the different values being shown in VB, but it returns no data as a parameter to the report, eg; If I select info from the MachineOrder...

Hello, First off, I have not used CR parameters from VB much. I am wondering if value of txtMachine is blank, how do I show all of the data from a report table. Im using CR 8.5 and VB6 If Machine <> "" Then crRpt.ParameterFields.GetItemByName("Machine").AddCurrentValue (txtMachine)...

This may be the wrong place to ask, but can the SAP DCOM Connector be installed on XP? Well I guess I have already answered that. I have installed it, but it does not work. I have created several VB BAPIs and they are running fine on a 2000 box using the connector. It appears that if I could...

Gentlemen, I really appreciate your persistence in helping resolve my problem. It is hard for me to believe that the – instead of an = sign in select @to_shift - 11-7 was the root cause of the whole thing, but Ill take it. Obviously, an oversight on my part. I have no way of knowing the shift...

Thankx for the assistance, synapsevampire. Just saving the report after verifing database, does not work, Ive tried that many times before. Although the underlying structures do not add a field, I have explicitly named the select statement, it makes no difference. The SP works, it just does...

Interesting observation, vidru. I didnt notice the GO. In fact, I didnt even put it in the proc. I deleted it, ran the report again, and it appears again! I can't get rid of it. At any rate, the sequence of events in the report has not changed. 1. Run Report - Select Daterange -nothing 2...

Thankx for the reply. In essence, Im attempting to select an SQL daterange (shown in CR), delete a table of data, select new data via the daterange and populate the table, then update it, with a cursor and a series of updates. Here goes the proc. Its long and probably poorly written, anyway...

My procedure includes a datarange parameter. First, I need to delete the table. Then the daterange populates the table, finally the procedure loops through the table and updates it with additional info. Seems to work fine except, when I put in the new daterange in CR, the table info is not...

Thankx for the reply Andy, however I still have a problem. Perhaps I was not clear earlier. The dashed name is the database not the tablename. I must admit, I have never seen a database named with a '-' , E-CPT. In Query Analyzer for instance &quot;select * from e-cpt..machine, and...

I was trying to connect database with a '-' in its name eg; DatabaseName E-CPT, Tablename Machine. I was actually trying to validate that a machine was in the table from VB eg; &quot;Select machine_id from machine where machine_id = &quot;' & machine. Im getting syntax errors, all relating to...

I need to convert a char(17) to numeric for a MSSQL view. In VB it goes like this If PartType <> &quot;&quot; Then mantissa = CInt(Mid(SideMillType, 5, 2)) num = CInt(Mid(SideMillType, 7, 2)) den = CInt(Mid(SideMillType, 9, 2)) Width = CDbl(mantissa + (num / den)) End If...

I have help build several BAPIs apps. Sometimes the code becomes “very intensive&quot; in VB. I looked at a product called TablePro, and eventually bought it. It is very fast and configurable, in terms of data retrieval. By the way this is not an advertisement. I am curious though, I see...

I dont have an answer but I do have a comment about this.. ----FYI-it's poor coding to create a procedure that has a name beginning with SP_ (or sp_). Why? Because when it's run, SQL Server will first try to find it in the Master database since that (sp_) is the built-in identifier for SQL...

Thankx for the quick responses. Guess Ill just create a stored procedure, put it in VB and run a timer.

Is there a way to auto refresh a report when viewed in the Crystal ActiveX viewer on the client side? Say to refresh every minute. I have tried the rf=1, in the URL, won't work for me. Cant really find a lot of info on the subject.. CR 8.5 Enterprise Thankx in advance