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

  1. KJSDAD

    DTS packages taking 100% processor

    Check sql server web site... there is a post sp2 bug/fix for oledb pegging processor.... Kevin Herbert Software Developer kevin@ioutsource.com
  2. KJSDAD

    CONVERT DATE TO STRING

    '**************************************************************************************************** ' Function to convert a datetime field to text regardless of how you have your short date definged ' m/d/yy or mm/dd/yyyy both will work. Public Sub CvtDatetoText() dim dd, mm, yy...
  3. KJSDAD

    I want to change from one .qry to another .qry file

    I later used a hex editor to change the old .qry name to the new one. This is very sensitive but it worked.... remember to always make a copy before trying this. [peace] Kevin Herbert Software Developer kevin@ioutsource.com
  4. KJSDAD

    I want to change from one .qry to another .qry file

    No it's that I am using crystal info and when I change the dictionary name and location it still leaves one entry in my report pointing to the original qry file. This is a bug as far as I'm concerned. Your probably right copy the old sql to a new name and move your new one into place with the...
  5. KJSDAD

    Select on a datetime field = null (Sybase) using .qry

    I need to select out all records that are null. When I try to use the qry builder in info 7.5 it places a ts next to the field and will not allow me to select with null. I have tried to use expression fields to no avail. I have overridden the sql by hand to get around this. I would really...
  6. KJSDAD

    I want to change from one .qry to another .qry file

    I change the location, verify database and everythings works fine. When I come back in the report still wants to use the old .qry file. I created the .qry with info 7.5. I tried changing the default dictionary to point at the new qry file "~ci31fup.qry". It still wants to use the...
  7. KJSDAD

    Sum up summaries from a main report w/ summaies of sub report

    Be careful there is a size limitation on the amount of data that can reside in your shared variables within your sub report formulas. You might have to create several formulas in your sub report if you have say 10 seperate totals you want to bring back.

Part and Inventory Search

Back
Top