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

    Delete Single Instance of Redundant Rows

    vongrunt, Perfect! That works exactly how I need it to work. Definitely worth a star!
  2. jtheis

    Delete Single Instance of Redundant Rows

    I am trying to figure out how to delete one instance of a redundant row from a table with a single column. For example, in table QueuedLoads I have one column, LoadNumber. The value in LoadNumber can (and will often be) the same as other rows in the table. Table: QueuedLoads LoadNumber...
  3. jtheis

    Subscript out of range

    tsuji, Thank you for being so patient on this one. Yes, I now understand the problem with using () and I will never use them again! I also understand that CLng can only be used on the individual elements of the array and not on the entire array. My question now - since I can convert each...
  4. jtheis

    Subscript out of range

    tsuji, OK, I think I understand what you're getting at. When I take out the (), I get the type mismatch because SyncWrite is expecting that NumItems, svrHdls, and Errors will all be Long and OutValues will be Variants. I think the only one that would be right by default is the OutValues...
  5. jtheis

    Subscript out of range

    I've got an update on this one. Instead of using .AddItems, I made a loop and used .AddItem instead. So where I had Group.OPCItems.AddItems NumItems, szItems(), clntHdls(), svrHdls(), Errors() I now have For I = 0 To NumItems szItem = szItems(I) clntHdl = clntHdls(I)...
  6. jtheis

    Subscript out of range

    tsuji, Thanks for the link. I'll read up on it and post back with my results. Joe
  7. jtheis

    Subscript out of range

    tsuji, I agree that the arrays would be empty, or uninitialized, if I didn't ReDim them. What I meant was that omitting the () in the .AddItems is the kind of thing I'm used to seeing as being different between VB and VBScript. For grins, I did take the ReDim statements out. I get the out of...
  8. jtheis

    Subscript out of range

    tsuji, Good idea, but I get a type mismatch error without the (). That seems like the kind of thing that would be different between VB and VBScript. Thanks! Joe
  9. jtheis

    Subscript out of range

    tsuji, Thanks for reminding me. I had checked the UBound before on all of them and got a 48 back. I double checked and for all of the arrays they come back with a 0 for the LBound and 48 for the UBound. So now I have confirmation that the arrays are all 49 elements (0 to 48) but I still...
  10. jtheis

    Subscript out of range

    Sheco, Time for me to ask another stupid question - how would I know if it is going from 0 to 47 instead of 1 to 48? Is there something I could write to check this? If I understand what I've read about arrays, since I ReDim'd the arrays to NumItems, it should be creating the dynamic array...
  11. jtheis

    Subscript out of range

    I'm getting a "subscript out of range error" in my script at the following line Groups.OPCItems.AddItems NumItems, szItems(), clntHdls(), svrHdls(), Errors() Before this line is called I do the following Set objServer = CreateObject("OPC.Automation") Set Groups =...
  12. jtheis

    Passing from VB6 to VBScript

    PHV, You had it right, I just didn't understand at first what you meant in your reply. What I needed to add at the end of the MODULE function was Call_ShowLoadBuildDlg = bolShowLoadBuildDlg Then in my CLASS MODULE function I added vbsShowLoadBuildDlg = modHTS2.Call_ShowLoadBuildDlg And...
  13. jtheis

    Passing from VB6 to VBScript

    PHV, Sorry, I left out that the vbsShowLoadBuildDlg always returns a False value for Result. earthandfire, I use the 1 because if I leave it as the variable LoadNo it doesn't do anything because LoadNo does not have a value at the time that it is called. I apologize in advance if I'm...
  14. jtheis

    Passing from VB6 to VBScript

    I've got what I think is an unusual question. I have a very messy situation with multiple languages and trying to pass info from one to the other. Here's the short version. I use VBScript to call a function in a VB6 .dll file. The VB6 .dll calls an old Delphi .dll and the Delphi .dll spits...
  15. jtheis

    String to Integer to String

    Yes, I'm a little slow today. I just figured out what is happening there. So basically what needs to happen is that the decimal number (13600) needs to be dvided by 256 (number of ASCII characters) and the whole number returned is the first character. The remainder is then the second...
  16. jtheis

    String to Integer to String

    I've dug a little deeper and here's (part of) why I think this doesn't work. If I type a '5' on my HMI, the PLC doesn't turn this in to the 53 I would expect to represent it. Instead it returns a decimal value of 13600. The PLC converts ASCII to some decimal value in the range of -32767 to...
  17. jtheis

    String to Integer to String

    No, it appears that no one ever looked too closely at this to begin with and it has never worked properly. As I'm not familiar with a PIE system, I can only assume that's not what I'm dealing with. What I've got is an Allen Bradley PanelView Plus talking via Ethernet to an Allen Bradley SLC...
  18. jtheis

    String to Integer to String

    I'm trying to decipher some code I inherited that isn't working. Here's what I'm trying to do... A 10 character string value is entered at an HMI. This string is sent down to a PLC where it is copied over to an integer file. This integer file is read by the Delphi app via an OPC server. The...
  19. jtheis

    Problem Creating and Deploying .CAB File

    I found today that I didn't have my read/write access set correctly and that was causing the problem with deploying the .cab file to the server. Now I can run through that process (so long as I don't try to unpack and install on the server) and it looks ok. I still have a problem on the...
  20. jtheis

    Problem Creating and Deploying .CAB File

    I'm having a problem getting my .cab file to work properly when called by the client computer. When I open the web page on the client, the .cab file is called for and a prompt comes up asking if I want to install it. I click OK and it looks like nothing happens. The two DLL files that I wrote...

Part and Inventory Search

Back
Top