and here is another reference http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconcustomcasemappingssortingrules.asp

Ok, for some unknown reason, this now works when I know before it didn't :wtf:

Well, I figured this one out. Since I was retrieving data from Views, it wasn't able to determine the P-Keys on its own. I modified the Tables after data retrieval to have the Proper Key Columns on them. Afterwards, it worked great! So I guess in a sense, it was trying to append the same Records twice, and since I had Relationships setup, it was violating the Constraints. ;P

Are you sure the table is being DROP'ed properly at the end of your SP? What is the error you are getting?

I don't trust VB nor the Garbage Collector ;P

Actually, it doesn't matter what kind of app...whatever way is the best to implement it...I don't really care about the "easy" factor of programming. ;P I'll check out the link.

Thanks for the Reply, I ended up figuring it out this morning in 15min ;P (after working on it for 10hrs yesterday)... I ended up with this: //DataRow[DataColumn[@Name='DatabaseID' and @Value='1'] and DataColumn[@Name='ID' and @Value='26']]

I guess so. You know, that's retarded...I thought everything in the CLR was exactly the same no matter what language. So why does C# have more design-time enhancements than VB? For example, why do we always have to comment every &#^%$%@ line of code instead of "/* .... */ ". Not that I am complaining...too much, because I do not like the syntax of C# / C++. I can understand and read it, but I don't think I'll ever code in it ;P

Try looking for examples related to System.Net / System.Net.Sockets Namespaces. I seem to recall that I saw an example of this on DotNetJunkies.com or c-sharpcorner.com; even though the example was in C#, it could be done fairly easily in VB.NET.

I'll second that motion! -------- There are 10 types of people in this world. Those who know binary and those who don't.

Ok, sounds good. I guess I'll need to stress-test when I get to that point. Thanks for the insight and help!

Glad you like them! That is the cByteFns class from my Data dll. Do unto others as you would have them do unto you - Jesus An eye for an eye only makes the whole world blind - Mahatma Gandhi

Well, I've tried it all and it still doesn't work! The "GetProcAddress" still returns "0" as if it's not even recognizing that there is a function called "DllRegisterServer" which is impossible because if I open the DLL using WordPad I can find that exact text in there. Here's what I've got so far: 'API Declarations Private Declare Auto Function FreeLibrary Lib "kernel32.dll" (ByVal hLibModule As IntPtr) As Integer Private Declare Ansi Function LoadLibrary Lib "kernel32.dll" Alias "LoadLibraryA" (ByVal lpLibFileName As String) As IntPtr _ Private Function GetProcAddress2(ByVal hModule As IntPtr, ByVal lpProcName As String) As IntPtr End Function Private Declare Auto Function GetProcAddress Lib "kernel32.dll" (ByVal hModule As IntPtr, ByVal lpProcName As String) As IntPtr Private Declare Ansi Function CallWindowProc Lib "user32.dll" Alias "CallWindowProcA" (ByVal PrevWndFunc As IntPtr, ByVal hWnd As Integer, ByVal Msg As Integer, ByVal wParam As Integer, ByVal lParam As Integer) As Integer Public Function Register() As Boolean Dim hResult As Integer Dim hLib, hAddress As IntPtr hLib = Me.LoadLibrary(_Path) If (hLib.Equals(IntPtr.Zero)) Then Return False 'Failed to Load the Library Try 'Get the Address of the DllRegisterServer Function hAddress = Me.GetProcAddress2(hLib, "DllRegisterServer") If (hAddress.Equals(IntPtr.Zero)) Then Exit Try 'Execute the Function hResult = CallWindowProc(hAddress, 0, 0, 0, 0) Catch Finally 'Free the Library hResult = FreeLibrary(hLib) End Try End Function Any ideas?

If you really want to do all the error checking in the regular expression for Short Time format, try this: ^(([01]?\d)|(2[0-3])):[0-5]\d$ Or more explicitly: ^(([01]?[0-9])|([2][0-3])):([0-5][0-9])$ If you don't want to allow h:mm times, take out the ?.