Search results for query: *

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

You need to put a loop around your "sr.ReadLine()" command. You are only calling it once, so it only reads the first line. --Rob

Is this value to be used as a primary key in another table? You might consider looking into using a column with the identity Property set to Yes. This will automatically increment for you. --Rob

The issue may be that in SQL, NULL = NULL does not evaluate as true, but NULL. If dts_lab_val_txt is the issue, for example, the SQL should read like the following to compare nulls: SELECT dts_mbr_no FROM mbr_labs WHERE dts_mbr_no = :mbr AND dts_lab_id = :lab AND...

Err...I meant String.Format ("{0:F8}", ds.somefld) --Rob

I believe the following will format 0 correctly: String.Format ("{0:F8}", 0) --Rob