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 SkipVought 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: *

  • Users: nikhilmehrotra
  • Order by date
  1. nikhilmehrotra

    write a cursor

    Hi,<br><br>what kind of cursor do u want to write.<br><br>the general structure for the cursor is<br><br>CREATE &lt;cursorname&gt; CURSOR FOR<br>&nbsp;&nbsp;&nbsp;&nbsp;&lt;your select query&gt;<br><br>OPEN &lt;cursorname&gt;<br>FETCH FIRST FROM &lt;cursorname&gt; INTO &lt;field list specefied...
  2. nikhilmehrotra

    How can i copy a database to another server(computer)?

    Hi,<br><br>&nbsp;If you are using SQL Server 6.5, then there is an option for database transfer. Just select your source and the destination databse and server name.<br><br>After selecting just start the transfer, rest will be managed bu sql server.<br><br>Nikhil
  3. nikhilmehrotra

    SQL Task Scheduler for 6.5 not running.

    HI, <br>Check whether the msdb database exists or not(this database handles all the scheduled tasks). The problem could be because of that also. If it exists check for the stored procedure that manages the tasks in the msdb database.
  4. nikhilmehrotra

    Datagrid

    just add a new column in the grid (if u designed it at desgin time) buit if at runtime then make an object of grid.columns and add a new column<br><br>Hop it helps<br><br><br>Nikhil<br>
  5. nikhilmehrotra

    Repair an Access database via ODBC

    You could try using the database object and the CompactDatabase function<br><br><br>Nikhil<br><A HREF="mailto:nikhilmehrotra@mailmetoday.com">nikhilmehrotra@mailmetoday.com</A>
  6. nikhilmehrotra

    Adding a control Array to the Form.Controls Collection ?

    if you are in design mode then just create a textbox and go on pasting it (after copying the text box) on the form . for the first time VB will ask you to create a control array or not. if u want to do it through code  then just create a textbox and set its index property to 1. Now the following...
  7. nikhilmehrotra

    ocx problem

    you just reinstall crystal again
  8. nikhilmehrotra

    SQL and Datagrid Problem

    Could you please show up the code that you are trying.<br><br>Nikhil<br>
  9. nikhilmehrotra

    Multi User Program

    try using a connection object and trap querytimeout and the error handler.<br><br><br>Nikhil
  10. nikhilmehrotra

    Installing Desktop Edition

    which version do u want to install?<br><br>
  11. nikhilmehrotra

    Change Password for SQL 7.0 logon user id from VB6.0

    there' s a stored procedure sp_password which allows you to change the password of the logins. try it out.<br><br>

Part and Inventory Search

Back
Top