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 gkittelson 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: moniB
  • Order by date
  1. moniB

    Updating large no of rows

    Hello everyone, I have a table with approx 7 million rows and need to update one field for each row. Can anyone tell me the best way to do this update. I'm aware that simply running an update statement will fill the transaction log. Thanks in advance, Monica.
  2. moniB

    run-time error -2147417848 (80010108)

    I sometimes get the following error when using a Microsoft SSTab control in VB: Run-time error -2147417848(80010108) Method 'Tab' of Object 'ISSTabCtl' failed. It seems to happen after I have got some results from an SQL Database via an ado Recordset and loaded them into a DomDocument and then...
  3. moniB

    ODBC Data sources and stored procedures

    I am trying to display a report which consists of data returned from a stored procedure but it only seems to work if I create the ODBC Data Source with NT authentication. When I try and run the report providing a connection string it wont display the report but err.number is 0 in VB. Has anyone...
  4. moniB

    Crystal and ODBC

    Thanks for the code to run a Crystal Report from VB providing stored procedure parameters. I have managed to display my report but it only seems to work if I create the ODBC Data Source with NT authentication. When I try and run the report providing a connection string it wont display the report...
  5. moniB

    passing parameters in Crystal for VB

    I'm currently using Crystal Reports Pro (shipped with Visual Basic) and have created a report. I wanted to allow parameters to be passed to this report (e.g. if users only wish to see data in a certain date range) but can't work out how to do this. I tried to create the report again using a...

Part and Inventory Search

Back
Top