Recent content by mwardle

Well, you're missing the line ';Integrated Security=True' from your SQLConnection string. I'm not sure how to write a security-free .NET app - it's rather integral to the whole thing. Really, there's nothing unusual about your app and it should be a simple matter for the IT Support guys to...

I think the change to SQL Server is a bit of a red herring here. Executables held on network drives acquire by default the permissions of the Intranet role. This blocks most access to the registry as well as automatic access to the local file system and security policy settings. The Access DB...

I'm having great fun with using a combobox to update other fields. The combobox is bound to a main dataview via the SelectedValue, and the Datasource, DisplayMember and ValueMember are all set, apparently correctly. The idea is that one of the values in the combobox is a default, 'unchosen'...

I also need to do this - until this is possible using Crystal in dotNET is of limited use to us. I submitted it as a product enhancement request nearly a year ago (well prior to CRXI's release), but as yet it is not included.

You could also check if you have declared a variable elsewhere called 'row'. If so, the code 'me.rows.add(row)' may be using that rather than the parameter passed to the sub.

I don't think it can be done in the manner you wish. If you are using SQL Server, you can write a stored procedure that will can adapt the table into a suitable form. Eg SELECT CostType, TheYear, Period1Spend AS AmtSpent, 1 AS ThePeriod FROM tblData UNION ALL SELECT CostType, TheYear...

It contains a lot of the code, but it seems to rely on knowing the location of the Dll via a setup file, or at least the path to it. But if I always register the file from the same place then it will be easier in the future. How this will work with Citrix sessions, I don't know.

I am trying to write a little app that will check whether a dll has been registered and then, if it has, compare the version of that Dll with the latest version. If the latest Dll has not been registered, then it will be. Registering the Dll is straightforward, as is getting the version no of...

The problem with the Excel export converting pounds to dollars has been plaguing us for over a year. Crystal sent us an old version of the dll which does not have this problem, but it is version 7 and is riddled with other bugs, not least the fact that any report exported using it zooms to 9-11...

Auto Update Statistics is on. I just tried DBCC ReIndex on the main index used by the sp, and it seems to be back to speed, indeed slightly faster than the original. Cheers.

After restoring a database under a different name to use for testing, it seems to run considerably slower than the original. A number of stored procedures that analyse the data contained therein run take between 2 to 10 times longer in the restored database than they do in the current database...

How the stored procedures interpret dates parameters depends on the Language of the login. An sp with code such as TheDate BETWEEN '12/06/02' AND '19/06/02' will work fine for a British English login, but not for an English (US) login.

Using the standard ado-bound datagrid, no. By using other grids like TrueDBGrid, yes. But if alternating colours is all you want I'd abandon the idea becuase the third party grids are quite expensive. The datagrid that comes with .NET allows for alternating row colours, but I have not yet had...

You can play AVIs using either a form or a picturebox as the screen. Code for this can be found at http://www.andreavb.com/tip090006.html The code is for a picturebox but can be adapted for an entire form. I don't know if you can do other movie types though, and the code doesn't allow for the...

You can play AVIs using either a form or a picturebox as the screen. Code for this can be found at http://www.andreavb.com/tip090006.html