Search results for query: *

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

The option you want is ExportOptions.ExcelAreaType. This has options like Details and Page Header to base your column widths on

First of all, what kind of database are you connecting to? In Crystal, make sure that Reprompt User When Connecting is not ticked. Secondly, have you tried using the RecordSelectionFormula property instead of the SQLQueryString? According to Crystal Decisions, when using the SQLQueryString in...

The method below works fine on CR 8.5 and probably on CR 8.0 dim cappAny as New CRAXDDRT.Application dim crptAny as CRAXDDRT.Report Set crptAny = cappAny.OpenReport(path of report) Now you can play around with it to your heart's content.

You don't need to mess around with Declares for this kind of thing. Update t_timeoff Set accrual_rate=4.69 WHERE user_id IN (SELECT DISTINCT id FROM t_user WHERE hire_date = DATEADD(yy, -5, GETDATE()) AND YEAR(hire_date)>1996) AND type='vacation'

If you set the value of the DatePicker to a date, any date, the checkbox is automatically ticked. If you set it to Null, the checkbox is unticked and the date faded out. When unticked, the value visible will be the last value. So if you want the DatePicker to show today with the checkbox...