Search results for query: *

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.

I have a field city_state which holds the city and state together. The state is always the last two characters, but the city is variable in length. Is there command or combination of commands I can use to parse out the state. Thanks in advance. Devin

I knew it was something simple. Thanks.

How do I keep the cursor in the current text box when the input mask limit is reached, rather than having the cursor jump to the next textbox automatically? Thanks

Rianeiro, I had tried a counter and it was not working. But after reading your post about multitasking I tried increasing the counter and it worked. Thanks.

I am using the ShellExecute command to run a self extracting executable. When the executable is finished another folder is created with the same name as the executable with a couple of text files inside. I am then trying to append these text files to a foxpro table. The problem is that when I...