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 Mike Lewis 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. Dalel23

    How To Invoke an ActiveX Control

    I am sorry again can you show an example? Thank you
  2. Dalel23

    How To Invoke an ActiveX Control

    Thank you Sheco for your help. My ActiveX control (Which is going to be compiled into a dll) provide user with functionality. That is there will be a lot of user's interaction. Is it possible upon clicking a button on my asp page the ActiveX Control is invoked in a browser window? Maybe I am...
  3. Dalel23

    How To Invoke an ActiveX Control

    Do you have any example please to create an instance in memory on the web server then wrap it in an ActiveX DLL project and use Server.CreateObject My ActiveX Control (Dll) has a use interface.
  4. Dalel23

    How To Invoke an ActiveX Control

    I hope someone can shed some light on this issue I am facing. I desined an ActiveXControl in VB 6. Now I want to call/invoke my ActiveX control from my asp page . When user clicks on a button I want my ActiveX Control Program to Display in a browser. I am still unable to find any helpful...
  5. Dalel23

    Use of Having In a stored procedure

    ESquared Thank you very much. That is exacly what I needed. And I would like to also thank everybody else for thier valuable help. Thank you again
  6. Dalel23

    Use of Having In a stored procedure

    I am familiar with sql language. Not that I am an expect by any mean. I just wanted to find out how to handle a multivalue parameter in my stored procedure. The link you sent can not help me in any way. But Thank you. I am just looking for some directions.
  7. Dalel23

    Use of Having In a stored procedure

    I have no idea how to cast on this dynamic sql. Could you help me write the stored procedure please? Thank you
  8. Dalel23

    Use of Having In a stored procedure

    I tried executing the stored procedure exec myStoredProcedure '550', '553' The where clause of stored procedure now looks like this Where tblShutDownProcedure.EquipmentNoFk In (' & @EquipmentList & ') It's not working. It says 'Procedure of function has too many arguments specified' Any idea...
  9. Dalel23

    Use of Having In a stored procedure

    Hi LNBruno Thank you for segment of code. Now how do I define the data type of @EquipmentList in my stored procedure? The EquipmentNoFk is defined as an integer in my table
  10. Dalel23

    Use of Having In a stored procedure

    Let me clarify one more thing please The were clause should look like this WHERE tblShutDownProcedure..EquipmentNoFk = @EquipmentList I am retrieving by equipments. The goal is to pass multivalued variable to a stored procedure. I believe the where clause will only handle one value parameter at...
  11. Dalel23

    Use of Having In a stored procedure

    Thank you so much for the code. I just have a question. Will the where clause handle more than one variable? Because that's what could happened.
  12. Dalel23

    Use of Having In a stored procedure

    Hi mrdenny Thank you very much for the response. Pretty much what I am doing is trying to convert an existing sql statement to a stored procedure, and then call the stored procedure by passing the correct parameter from VB. The sql statement that I am trying to convert to a stored procedure...
  13. Dalel23

    Use of Having In a stored procedure

    I am using VB as a front-end. I would like to call a stored procedure by passing a parameter with multiple value. I having difficulties creating the stored procedure. The use of Having is because I could have multiple values seletected by the user. CREATE PROCEDURE...
  14. Dalel23

    Record Auditing

    I have an interface designed in VB 6 with an Access Database Backend. I have a couple fields defined in my database CreatedDate, CreatedByID, LastAuditDate, LastAuditByID, LastRevisionDate, and LastRevisedBy. User clicks on create button, at that point and capturing the user network logging...
  15. Dalel23

    Group by Max Date

    Thank you monksnake It did the trick. Could you please explain to me what the difference is? I mean you had to .0 for it to work? Thank you
  16. Dalel23

    Group by Max Date

    I have this Stored Procedure that I converted from an Access Query that is not returning the correct result. The SumOfWt_Add is retuning incorrect result. For example if Bales_Add for a particular Row is 0 and the Avg_Bales_Wt is 1200 then result I get is 0. It should be 0.6. CREATE...

Part and Inventory Search

Back
Top