Recent content by Niv3k

I have written a small program for Windows CE and Pocket PC devices, using embedded Visual Tools. I want to upgrade this app to .NET CF. What I want to know is: Can you purchase C# .NET Standard and then add in the compact framework, or is the ONLY way to develop with the compact framework by...

Awesome! I haven't typed it in yet, but it appears to be exactly what I'm looking for... Thanks, billchris! Kevin

Is there some control that corresponds to the FileDialog control, except with folder listings only? Or do I have to create my own, using say, a tree view? If that's the case, how do I get things like My Documents and My Computer and My Network Places? Kevin

Is there anyway to pause a stored procedure while waiting for user input? For example, I have a business rule that prohibits finalizing transactions that don't match the bill amount. But we have a new client company where they will accept $1 under or $500 over. Sometimes. We have to ask...

so THATS what the union operator does... Boy this would've come in handy years ago. Thanka! Kevin

I have a flat file that has several non-relational fields, such city_due_1, city_due_2, city_due_3, city_due_4. There is also garbage 1-4, sewer 1-4, and water 1-4. I would like to normalize this a little by bringing these fields into their own seperate tables, for example: bill_num int...

Use a CAST or CONVERT with the SUM, to make it an int, or a better way is to use the datediff function: SUM(DATEDIFF(minute, startdate, enddate)) This will give you the breakdown in minutes, which is good because if you use datediff with hours, it might round down .25 hours, so some employees...

I think that you may have some firewall or VPN issues. have you check all the ports that SQL server uses, and that you can actually communicate through them from office to office? Kevin

I'm sure what you want to do is possible, but I would need more information on the table layout.... Kevin

Why don't you detach the database, move the files to the new location, and then re-attach them? Kevin

I'm not sure if you can rename a column using ALTER, but couldn't you create an updatable view using an Alias? Example: SELECT F_Name AS First, L_Name AS Last FROM Names Kevin

Also, thanks, vb5prgrmr, because SetWindowText does not work under other applications edit windows, thus I have to rely on messages... Kevin

aaaaarrrgh! I always forget to do something simple, such as: WaitForInputIdle pi.hProcess, INFINITE Once I did that, I was able to get the handles with GetGUIThreadInfo! Thanks, LazyMe. Kevin

Yeah, that would work if knew the handle of the window. That's what I can't find.

Okay, here is the hack, but I'm really not happy with it written this way: Clipboard.SetText Text1 Shell "Notepad.exe", vbNormalFocus SendKeys Clipboard.GetText What I would like to do is use the SetWindowText function to put certain text directly into notepad, instead of sendkeys...