Search results for query: *

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

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

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

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

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.

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