Recent content by dduva

Can I use a DataRelation to find out which parent records in Table A do not have a child record in Table B? Or is there some other way to do this?

In SSIS, I have an incoming flat file which I use to populate a dataset. If I run a script against the dataset, how do I connect to the exising dataset using vb.net. I'm new to SSIS and vb.net. Any help would be appreciated. Thanks.

I appreciate the help.

Newbie needs some help with case statments. In the code below I want to see if today's day is less than 26. I get an error with my case statment saying I can't implicitly convert a bool to an int. How would I accomplish this? int dateOfDay = DateTime.Now.Day; switch(dateOfDay) { case...

I want to delete a range of rows from an excel spreadsheet. I don't want to just clear the cells but actually remove the rows and have the rows below shift up. How would I do this through my C# application. Thanks.

Would a large memo field (1.4GB) cause "Not enough memory to complete this operation" error during a replace of multiple fields. The DBF itself is only 3.1MB. Thanks for you help.

That worked. Didn't know I could put distinct inside the count. Thank you.

I have a query where I am selecting fields a, b, and c. I am grouping by a. I want to get a count of b and c. The problem is there are duplicates in b. Column c has no duplicates. How can I count all of column c, only the unique records in column b and group by a. Thanks in advance. Devin

Thanks for your input, but I figured it out. It wasn't that I deleted one to many but one to few. I needed to delete another line with the broken access lsp.dll in it.

I am using XP. However I turned off the system restore before I started all this.

I know I am connected because I can log onto msn messenger but if I click on the emails, the page is loaded with "page cannot be displayed" Some background, I used Hijack this to get rid of msoffice.hta, I also used spybot search and destroy. I think through Hijack I might have...

I did try to look up this question but I couldn't seem to get any threads with my search criteria. Question for slighthaze, how do you get the future date into datetime format? Thanks

I am looking for an easy way to find out how much time, hours, minutes, seconds are left until some future date and time? Is there a simple commmand? Thanks in advance. devin

Does anyone know if the font helvetica compressed is supported by VF6? Thanks in advance.

Thanks DSummZZZ. The first way works, there were no commas. I wasn't thinking outside the box with the right() funciton. Thanks again.