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

    get next N records

    Hi I'm sure this is an old perennial, so feel free to refer me to earlier answers.. How so I get SQL to return me the next/previous N records from a table that does not have a suitable unique key I can use to fix the start point? I can get the first N with SELECT TOP, but after that it gets...
  2. JohnSouth

    E-mail reports

    Thanks for that Benjamin I can see that should work, but I don't see why I should not be able to set the Export DestinationType to crMAPI and sent the file directly. I can with a Crystal OCX control, but when I try with the Report Engine Libray I get various errors. I need to use the Report...
  3. JohnSouth

    E-mail reports

    Hi Using VB6 and Crystal Report Engine 7 Object Library I need to e-mail reports directly to a recipient whose address is available to the VB code. Does anyone have a simple example of how this is done. Cheers John South JS Associates Pangbourne UK
  4. JohnSouth

    Truncate Trans Log Every Night

    Hi I've a SQL 7 Application program that clears some Tables and Reloads them with new data every night. The Transaction Log grows at an alarming rate! How can I ensure that the Transaction Log is cleared down every night? I've tried various combinations of backup but it's still growing...

Part and Inventory Search

Back
Top