Recent content by clawton

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

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

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

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

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

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

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

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

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

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

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

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

Wow, Nice one Malcolm. Thanks.

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

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