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 Chriss Miller 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. clawton

    File Permissions Question

    Background: I have a .NET web application that processes input files and places their contents record by record into a database. The input files are read from a folder \inetpub\wwwroot\appname\inputs The appname folder has the permissions: Administrators: Full control ASPNET: Read & Write...
  2. clawton

    Multiple Form Instance Identification at Runtime

    Apologies in advance if this is Kindergarten stuff, but I'm really struggling on this one... I'm developing an app with an MDI Form as it's main window. On startup, I dynamically create a varying number of MDIChild forms, dependent on data stored elsewhere. I use the following code within the...
  3. clawton

    Dates / Times and Daylight Saving

    Thankyou Brian. That information was just what I was looking for. The code sample should be fine to use asis. Once again, thanks. It is much appreciated. Chris Lawton Chris@Lawton.net
  4. clawton

    Dates / Times and Daylight Saving

    I have written several Stored Procedures that insert new records into various parts of the database of a separate commercial application. This app has been work fine for about 4 months, but started giving strange results 2 weeks ago. The application stores dates/times on the records as stamps...
  5. clawton

    Printing, etc...

    There is a crystal 'Special Field' available, Total Page Count. You could place this in your report header, with some text such as 'This report consists of xxxx pages'. Immediately the report is previewed, the total page count would be displayed without having to go to the last page. You...
  6. clawton

    Parameters in SQL-Query

    Oliver, The Select Expert and modifications to the SQL Statement are an either/or action - You can either use the select expert, or modify the SQL, not both. Whichever action you do overwrites the other. What you seem to be trying to do is put a complex SQL query directly into the report, and...
  7. clawton

    ODBC Driver for Exchange

    Hi, I have heard there is an ODBC driver available to link to MS Exchange mail system. If so, does anyone know where I can get hold of it ? Many thanks Chris. Chris Lawton Chris.Lawton@GoldMine.com
  8. clawton

    SYNTEX ERROR

    Junk_Male, Are you sure this is an SQL statement, and not an extract from a VB program that is accessing a SQL database via DAO/ADO. To be pure SQL, there seem to be far more errors than you identify - Variables within T-SQL are identified with an '@' symbol, the assignment statement must...
  9. clawton

    limitations of crosstabs?

    I have noticed this one as well. I don't beleive there is a limit to the size of the cross tab - I am more inclined to think it's to do with memory size on the PC. When I print the report, the cross tabs show fully, even they show as blank pages in Preview mode. Suggestions?? Try another PC...
  10. clawton

    Division by zero

    It's because you are mixing the return types of the function. A function must always return the same type - text or numeric. your function could potentially return a text or a number depending on the input value. Taking your example, do the following : if y>0 then ToText( x/y ) else...
  11. clawton

    How to know when a trigger was disabled or disabled??

    You can tell whether a trigger is enabled or disabled at any point in time by ANDing the status field in the sysobjects with 2048. If True, the trigger is disabled otherwise it's enabled : SELECT Name, (status & 2048) FROM sysobjects WHERE type = 'TR' I don't know a way of...
  12. clawton

    hh mm ss

    Try setting up a function with the following : DateTime( Date( {DateTime Field} ), Time(0)) For example, to get todays date at midnight : DateTime(Date(CurrentDateTime),Time(0)) Hope it helps... Chris Lawton Chris.Lawton@GoldMine.com
  13. clawton

    Renumber records without a cursor?

    Wow, Nice one Malcolm. Thanks.
  14. clawton

    Importing a csv file to a sql server table

    Try using the Data Transformation Service - a GUI based data manipulation tool accessible through Enterprise Manager.<br><br>You'll need to create a new package, add 2 connections, 1 pointing to your CSV file, the other pointing to your database.&nbsp;&nbsp;You then select the table you wish to...
  15. clawton

    Just Certified in ICW

    Hello all.<br><br>As of 2 days ago, I have just received my certification in Infracentre for Workgroups (ICW) - a subset of AssetCenter.<br><br>I am now very keen to put this knowledge into 'real life'.<br><br>I will do my best to look at as many issues as I can - after all, real life experience...
  16. clawton

    Printing Headers after the 1st page of CrossTabs report

    Although it is called a cross-tab report, it technically acts as a cross-tab module that can only be placed into the Header or Footer of a true 'container' report.&nbsp;&nbsp;Therefore. all page header/footer etc placements do not act on the crosstab, only on the report into which you have...
  17. clawton

    Need Help with Dates

    Oops - Me again.&nbsp;&nbsp;The last formula doesn't work in January.<br><br>The correct one takes the current month as the array location for the description of the month before ie.<br><br>If current month = 1 (Jan), show the name December, if month = 2 (Feb) show January .......<br><br>It...
  18. clawton

    Need Help with Dates

    As I understand your question, you have a report which is using the 'LastFullMonth' function within crystal to find all records with a date in the last month, and all you need a string containing the Name of that reporting month.<br><br>If so, the only way I can think of is to create a function...
  19. clawton

    Query that calls stored procedures

    How complicated are your stored procedures ?<br><br>If they are simple calculations, could they be rewritten as views that work out the new values based on the current two input fields.&nbsp;&nbsp;A simple select on the view may then suffice.<br><br>Chris.
  20. clawton

    Create a Table Using the current Date as the Name

    You cannot use a variable as the tablename within a create table statement.<br><br>However the EXEC statement can execute a piece of SQL stored within a variable.&nbsp;&nbsp;What you can do is create a stored procedure that stores your entire CREATE TABLE statement into a variable, substituting...

Part and Inventory Search

Back
Top