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

    Errors on Intuity / Merlin system

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

    Errors on Intuity / Merlin system

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

    Wireless setup script

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

    Wireless setup script

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

    Display Multiple AddDefaultValue on CrRpt

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

    Show all field data ?

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

    SAP DCOM Connector

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

    Stored Procedure problem...

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

    Stored Procedure problem...

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

    Stored Procedure problem...

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

    Stored Procedure problem...

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

    Stored Procedure problem...

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

    Syntax Error both VB &amp; SQL

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

    Syntax Error both VB &amp; SQL

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

    Convert char to numeric

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

    Access to SAP via Oracle ODBC

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

    Help with Stored Procedure

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

    Auto Refresh Report

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

    Auto Refresh Report

    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

Part and Inventory Search

Back
Top