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 strongm 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. TerraSamba

    VB .NET Not Recognizing DTS Error

    Take a look at this: http://support.microsoft.com/?kbid=221193
  2. TerraSamba

    call function on inherited form from another form

    if you are using more the same function over again, declare it as a shared routine. Or put the function in a module. When your function is based on parameters of the forms, which I suspect, you might consider to capture all the parameters in a class, and pass these parameters to your function...
  3. TerraSamba

    Reading in a certain number of characters

    to get like the first 10 characters: dim strMyvar as string=MyCtrl.text.Substring(1,10) The gap between theory and practice is not as wide in theory as it is in practice.
  4. TerraSamba

    error creating windows handle in usercontrol

    Hi guys, done it again, got myself stuck ... this time on the following issue: I have made a user control that more or less simulates a grid. You can set the amount of columns,rows, cell size, colors etc. This works fine. This user controls simulates a grid by placing checkboxes on the...
  5. TerraSamba

    Very large Dataset - Paging??

    I am pretty much used to work with big datasets, but my experience is that once your set is bigger than, lets say a number, 25000 records the result is useless, your user will not find anything in such a big set. The best you do in my opninion is to have some sort of resume of the result on...
  6. TerraSamba

    New schedule task using VB.NET

    you can schedule running schtask through the shell function in Microsoft.VisualBasic.Interaction type schtask in the commandwindow to see the options The gap between theory and practice is not as wide in theory as it is in practice.
  7. TerraSamba

    image in datagrid

    Does anybody know if it is possible to place an image in the datagrid ... and not unimportant how? The gap between theory and practice is not as wide in theory as it is in practice.
  8. TerraSamba

    Fundamental Question: How do I "hook up" a DataGrid with SQL Conn.?

    make sure the data adapters select command property was filled, make a new datatable. Use the fill methid of the dataadapter and that set the datasource property of the grid equal to the datasource. lookup some of the walkthroughs of microsoft to get a nice start...
  9. TerraSamba

    Watching for events in Form2 while Form1 does something.

    try this: (pseudo-code) code on form1, this is the form that makes you show the dialog //form1 private withevents myfrmDialog as frmDialog sub DoSomething myformdialog=new frmdialog myformdialog.showmodal end sub sub myfrmDialog_Cancelled() myformdialog=nothing / or close or...
  10. TerraSamba

    Install exe as service in Visual Basic .NET

    I have no clue about XBase++, but I guess writing a .net class with routines what to do on start, stop etc. These routines would kick of or kill your XBase++ program. I guess that would do the trick The gap between theory and practice is not as wide in theory as it is in practice.
  11. TerraSamba

    Install exe as service in Visual Basic .NET

    (Copied from the 101 .net samples:) Create the Windows Service. Simply create a new Windows Service project in Visual Basic. You are provided with a overrides for the OnStart and OnStop methods. Add code to these methods, and implement any additional overrides (such as for the OnContinue and...
  12. TerraSamba

    debug

    by waiting for a version that supports that feature, unfortunately you can however through the options put off the prompt and make the changes, but changes will not be applied in your program untill after recompile. The gap between theory and practice is not as wide in theory as it is in practice.
  13. TerraSamba

    passing user defined type to a DLL function.

    The best way to use your types is to put them into a class module and them pass them within the class: MyClassModule public prop1 as string public prop2 as ... Then when calling the function: dim mytype as new classmodule myvar.prop1=x myvar.prop2=y set somevule=dll.myfunction(mytype)...
  14. TerraSamba

    Singleton/channels

    I am creating a server component that will supply one to many clients with events in case certain values in database tables change. This component will be implemented as a singleton class by a host application (a windows service) on the server machine so I will be sure all the clients receive...
  15. TerraSamba

    Class module query

    Ok, no pointers are available in VB6, so you will need to point the MyServerCOM to the executing proces of MyClass to be able to supply the callback functionality. You must use the adressOf operator, but somehow this only works with modules and not with the class that you referenced. There is...
  16. TerraSamba

    Testing DLL in design-time environment

    Open the dll project, add a new exe project to that project, save this project-group and you can put breakpoint etc in the dll project like a regular project The gap between theory and practice is not as wide in theory as it is in practice.
  17. TerraSamba

    Hi, Can somebody tell me how can

    Just raising the event is not sufficient. The active exe does not exist until you create it. See it like a class in a different process. try this 1: on your event (say print) instantiate your form class in the active exe 2: run the print routine residing in this form 3: let this public class...
  18. TerraSamba

    optimizing query

    Yep: final is :Select from BIGONE inner join on small inner join on small It is impressive how much time it saves, just changing the order and playing around. It now executes within a minute, and I will not be touching it for a while. I will have a...
  19. TerraSamba

    optimizing query

    The extra indexes made no difference, but the table-order change saves me about 30 secs ! Great thanx. I have added an extra where clause to exclude the null values, this together with your tip has finally put this query down from about 5 mins to less then 2 mins. Which is more than I had...
  20. TerraSamba

    optimizing query

    Guys, I have a query that is executing somewhat slowly ... Here is the query: SELECT @strPeriod AS Period, __QCWhs_W1.WhsShortName, __QCInput.strWhsProdCode, __QCInput.strCPostOrig, SUM(__QCInput.decUnitsOrig) AS decUnitsOrigSum, SUM(__QCInput.decValuesOrig) AS decValuesOrigSum...

Part and Inventory Search

Back
Top