Recent content by MacLeod72

I'm not 100% sure, but I've never seen many underscores in a method name. Have you tried GetRange()? --Rob

I believe this might be what you are looking for: Dim inputStr as String = "-0000000123456" Dim sign as String = inputStr.Substring(0, 1) Dim outputStr as String outputStr = String.Format("{0}.{1}{2}", _ inputStr.Substring(1, 11).TrimStart(New Char() = {"0"c}), _...

You're right; I had cut-and-paste issues. The correct code is: foundRows = tdtReportPermissions.Select("PlatformID_F IS NULL AND RoleCD_F IS NULL AND ContactID_F IS NULL") Sorry! --Rob

I believe you want: foundRows = tdtReportPermissions.Select("PlatformID_F IS NULL AND RoleCD_F = IS NULL AND ContactID_F = IS NULL") --Rob

Glad to help! --Rob

I have only used it to merge 2 datasets, but MSDN says that a Dataset, Datatable, or array of Datarows can be used. Here is the link (for .Net 1.1): http://msdn2.microsoft.com/en-us/library/system.data.dataset.merge(vs.71).aspx Hope this helps! --Rob

If the 2 datasets are identical, you should be able to do: ds1.Merge(ds2) This should add the rows of "ds2" to "ds1". Hope this helps! --Rob

My mistake! I'm still half a cup of coffee away from that solution :-). --Rob

I don't think that you can assign each control to a textbox variable. You probably want something closer to: For Each c as Control in Me.controls If TypeOf c Is TextBox Then c.width = 400 End If Next This example will only set the width on textboxes within your...

I again apologize; I forgot to check the knowledge base. In case anyone else encounters this: Sorry! --Rob

I apologize; I forgot to mention that I am using Informatica 7.1.3. Thanks! --Rob

Good morning- I have created a session in which I have added an aggregator. When I select the "Sorted Input" property, I get the following error: When I de-select the "Sorted Input" property, it runs fine but it spends needless time caching my entire table to file. Does anyone know why...

The problem is that when you filter using "like" or "IN" or equalities, NULLs aren't included. NULL is a special case in databases; in fact, NULL = NULL does not evaluate to true. When working with NULLs, you have to either specifically include them using the "IS NULL" phrase, or exclude the...

Good morning- This should create the filter you need: DataView1.rowFilter = String.Format("{0}{1}{2}", _ IIf("".Equals(TextBox3.Text), "", String.Format("Title Like '*{0}*'", TextBox3.Text)), _ IIf("".Equals(TextBox3.Text) Or "".Equals(TextBox4.Text), "", " Or "), _...

I haven't had this problem personally, but I was able to find the following article: http://support.microsoft.com/kb/313513 HTH --Rob