Search results for query: *

I'm writing a console utility to download specific files from web sites. The problem I'm running into is that some web admins have taken it upon themselves to not return a 404 error of the URI of the file is incorrect. Instead they redirect the request to another page on the site to provide...

Absolutely, and thanks. Your standard INI file is formatted with key-value pairs in sections like this: [Section One] Key1=Value1 Key2=Value2 Key3=Value3 [Section Two] Key4=Value4 Key5=Value5 ... I would like to retrieve the data like this (if it's possible), using named groups...

I'm studying RegEx patterns for use in C# and I'm trying to find out if a subgroup scenerio is possible. I'm parsing an INI file and I'd like to return a single matches collection that contains the section, key, and value information for each entry. Here's what I have for patterns so far...

These are the simple considerations I usually make: Windows App: Localized distribution, utility based applications, heavy processing, light data transfer. Web App: Wide distribution, heavy transactional data applications, centralized business processes, simple interface. Hope this helps...

ComponentOne has their own newsgroup server and you should be able to get some decent support for their controls in the newsgroups: news.componentone.com Hope this helps. - Glen Know thy data.

From what you described, it sounds more like a project / time allocation database than a timesheets application. I've done something similar to this using lookup type fields for the project and task. These project and task items were kept in different lists and maintained seperately. Also...

I'm having a bit of problem with the Select Case logical expression in my formula. I have several parameter parameter fields that return arrays of values (using the Allow Multiple Values option). I'm trying to assign a group name based on which parameter array the item is found. Here's my...

One way I've found to get around the locking issue is to copy the DB to another location, compact the copy, then overwrite the original with the copy. You would not want to do this during the hours where there might actually be a user updating the database for any reason. But if you schedule...

I can tell you from our experience that the NOLOCK option in the queries does help with blocking issues that can occur on the database. As mentioned, this will allow for "dirty reads", but since most reports include filters such as date/time parameters it should not be an issue. An alternative...

We have CR 10 and CR Enterprise Server. When developing reports in the CR designer, I would like to set the datasource to the development SQL server and be able to change the source before deploying it to the enterprise server. This is standard practice in any development area in our...

Two ideas to consider: 1. Local data caching. Instead of binding the objects in the front end of the database directly to the back-end data, create empty copies of the data tables in the front-end and populate with filtered data from the back-end depending on the operation. This will speed...

Hi Sanj, You can use the Cast() function to accomplish what you want, but you will need to rearrange the position of the date values in the string because it expects the YYMMDD format in a 6 digit expression. Here's an example of how you might use it: declare @DateString varchar(6) set...

A question for the forum admins: Can you please set up forums for SQL Server Reporting Services? It's a relatively new product (January of 2004), but it's quickly becoming a hot topic in the Business Intelligence community. Two forums would probably be appropriate (one for setup & admin, and...

That's similar to what I had in the first example with some revision. You could also use the second example with the following changes to send a single email to each person using late binding and without overloading your memory. (note the changes in blue text) Public Sub Command0_Click()...

Hi Thanyellin, You could set the reference to Outlook under Tools->References in the VBA IDE. However, I don't generally recommend a direct reference to an Office application as that reference will break if the user has (or installs) a different version of the application. The best way is to...

If you post the code, it might be easier to identify the problem. Hope this helps. - Glen Know thy data.

Yes, the example is probably over simplified and as you said the use of variables will not work when computing against a table value. I was simply demonstrating the most efficient case scenerio I could think of where UDFs could be used without a performance consideration. This is getting a...

Probably the most efficient use of UDFs presently would be the assignment of variables where the computation would only have to be made once. For example: Declare @StartDate smalldatetime Declare @EndDate smalldatetime @StartDate = dbo.StartOfLastMonth_udf @EndDate = dbo.EndOfLastMonth_udf...

Nice analysis TR! This is what I suspected with regard to inline vs. UDF computation. Maybe we'll see better UDF optimization with Yukon and the integration of the .Net framework. - Glen

AHA! Nested packages is probably the best solution. Thank you John, I appreciate the speedy response to my post. - Glen