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

    Crystal 9: Set Datasource Location Properties

    Sadly, this doesn't help. Tried that and it still pops the database login dialog. Any thoughts on how to get the "Database" property to show up under Set Location Properties?... D DGaw Independent Consultant Seattle, WA
  2. nodwag

    Crystal 9: Set Datasource Location Properties

    Help... I am having an issue with an application calling my Crystal report. When the application launches the report it pops up a database login screen. I have had this issue before, and someone figured out a workaround about year ago. The workaround was to do the following: 1. Set the...
  3. nodwag

    Oracle 9i, Crystal 9, Stored Proc issues...

    Thanks! I think the "Procedure Returns Results" option was my initial issue. On my box, everything ran fine with the Oracle ODBC driver. On the production box, it wouldn't work at all, and that had the Crystal driver on it. Hence, my conclusion was that the Crystal driver was tweaky. Looks...
  4. nodwag

    Oracle 9i, Crystal 9, Stored Proc issues...

    Well... after banging my head against many walls for far too long, I may have answered my own question. Sadly, it was only after posting this question to the group. Turns out, if I create a Native Oracle connection instead of an ODBC connection, I do not get the error described above, and I...
  5. nodwag

    Oracle 9i, Crystal 9, Stored Proc issues...

    It's been about 4 years since I've worked with Oracle on a daily basis, having joined a company that works almost solely with SQL Server. It took quite a while to get weened off of Oracle, but now I'm experiencing the opposite on a side project where I'm working with it again. What I want to...
  6. nodwag

    Want to do a record count on all tables...

    Had also read that about sysindexes.rowcnt, so that's why I used this particular approach. Found some other code online for updating the Statistics, but it involved more effort that it was worth for what I needed to do. Good for general interest sake, but not when just trying to cram a...
  7. nodwag

    Want to do a record count on all tables...

    Thanks for all the suggestions, guys. Vongrunt pointed out my main problem. ...with the code that is. My real problem is that I've been up waaay too long and got stuck in one of those 'stupid-loops'. D DGaw Independent Consultant Seattle, WA
  8. nodwag

    Want to do a record count on all tables...

    Hi... Essentially, I want to do a record count for all tables within a database. I've done the following, but get an error that @sCurrTable is not defined. I'm assuming this is within the Dynamic SQL, but not sure why. Any advice would be greatly appreciated. CREATE PROCEDURE...

Part and Inventory Search

Back
Top