Zadoras's Q&A profile

• SQL Server Design pattern for batch processing of 1000s of search criteria

  Hi, I'm looking for a design pattern (preferably leveraging SQL Server 2005 features) to create a batch job which will process 1000s of different user-defined search criteria against a large DW. The data warehouse schema is classical star schema in a healthcare setting: Claims, BillLines, Diag Codes, Procedure Codes, Modifier Codes, Providers. The output of the batch job would be something like: Search1 ClaimKeys: 1, 2, 3 Search2 CaimKeys: 2, 3, 4,... ... SearchN ClaimKeys: 12334334, 12343235, 12323212... Search Criterias would be something like: Search1: All Claims having Diag Codes (D1, D2, D3, D4) which have (BillLines using Procedure Codes (P1, P2, P3) which do NOT use modifer codes (M2, M3)). Search2: All Claims ...Show All

• .NET Development XML socket problem? (C#)

  Hi all, I tired create a XML Socket with using c#. My problem is display Exception : System.IO.IOException: Unable to read data from the transport connection: WSACancelBlockingCall ---> System.Net.Sockets.SocketException: WSACancelBlockingCall with my receive Function. Whether because my server is java I sure i can connect server, server and client is using the same port. I guess it is because time out How to fix the problem. Below is my codeing. Please somebody help me. codeing NetworkStream ns; StreamReader sr; TcpClient clientsocket; bool connected; Thread receive; string serveraddress = "127.0.0.1"; int serverport = 4002; private void Connect() { socketConnection(); if (connected) { receive = new Thread(new ThreadStart( r ...Show All

• Microsoft ISV Community Center Forums ADO Recordset CursorType Property

  I want to create an updateable recordset, whereby the values in a particular field in the recordset once opened are changed to something else if certain conditions are met. However, I do not want these updates to change the underlying datasource, otherwise I would be in trouble! I would therefore need to set the recordset's cursor type property prior to opening the recordset, of which there are 4 constant values: adOpenForwardOnly, adOpenKeyset, adOpenDynamic and adOpenStatic. I'm guessing the last one of these is the one I need, but can anyone confirm this is the case before I start Are there any other recordset properties I need to consider as well Cheers! Keith Cheers Derek! I'll do as y ...Show All

• Visual Studio Express Editions Transparancy

  Hello all, I'm just learning how to use visual basic, but i know a small bit, and I would like to learn how i could get the area surrounding a bitmap to become transparent. (ex. set a certain color (100, 100, 100) and have the computer not draw that color) Thank in advance Dim image As Bitmap Dim color As Color image.MakeTransparent(Color) ...Show All

• Software Development for Windows Vista Run a Workflow in a Workflow and cancel it

  Hi, As many others i am quite new to this topic. I found some examples and tried some simple things. I just wanted to know if someone maybe has some finished code for my problem or has some hints how to solve it. I have a Seq-WF-App where i start WF1, constisting of: cdBegin - Code : { Log("Beginn"); } Call Workflow 2 cdEnd - Code : { Log("end"); } In Wf2 i have: cdBegin - Code { Log("Begin"), Loop(10) { wait 1 sec; } Log("end"); } cdEnd - Code { Log("End"). I wanted to know how I can call wf2 in wf1 with a timeout. So i want: Call Workflow2 ( 5 sec ). After 5 seconds i want to cancel/abort/terminate the wf2 i called. What i reached yet is: I Abort() wf2. The Wf2 is currently i ...Show All

• .NET Development Passing a value using a thread

  I'm trying to pass a variable with the Upload Procedure and I can't do it, it says method name expected!! how you are guys doing it thrUp = new Thread ( new ThreadStart (Upload(OpenFileDialog1.FileName))); thrUp.Start(); thank you void Upload( String fn) { //do things } private void uploadToolStripMenuItem1_Click( object sender, EventArgs e) { if (OpenFileDialog1.ShowDialog() == DialogResult .OK) { Thread thrUp = new Thread ( new ParameterizedThreadStart (Upload)); thrUp.Start(OpenFileDialog1.FileName); } } here is the code, do I need to declare upload somewhere other than this ...Show All

• Visual Studio Express Editions How to get another websites IP address in Visual Basic

  Hi there, I am currently working on a HOST File editor project in Visual Basic, where the user has to enter the word they want mapped to a certain IP address of a website. However, as many users won't know what an IP address is, nor how to get it, I was wondering if there is any way to retrieve the IP address of a website. I'm guessing it will involve using Domain Name servers right Any help will be much appreciated, RichardHarley I would think something like: Dim hostInfo As IPHostEntry = Dns.GetHostByName(hostString) Console.WriteLine(( "Host name : " + hostInfo.HostName)) Console.WriteLine( "IP address List : " ) Dim index As Integer F ...Show All

• Internet Explorer Development problem with IE7 - links suppose to open in the same page but it opens a new page in my website

  Hi i'm designing this website using dreamweaver 8, i used frameset method to devide the page into 3 frames top frame which contains the flash navigation menu, left frame which contains ads , right/content frame which contains the content of the website. when the user click any of the links on the menu it should be opened in the content frame , it worked fine in IE6 , but when i upgraded to IE7 things changed every link now opens in a new page! this is the flash code i'm using in each link getURL("../services_en/services_en.html" , "content"); content is the name of the frame that i wish all the links appear in. i've tried the <base target="content"> included in the head tag of the menu page but that d ...Show All

• Visual Studio RefreshReport closes my application

  I have an application with a reportviewer - the report works perfectly on my machine - when running at my clients machine - the app closes (no message, no execeptions, nothing in the event log...). I have nailed it down to the .RefreshReport method - as soon as this line is hit the app closes. The ReportViewer control is properly installed on the machine. Anyone experience this If an exception is being thrown, you should be able to see it in the debugger by unchecking the "enable just my code" option in Tools-->Options-->Debugging and by breaking on all exceptions. You won't be able to see the source code, but you should get details on the exception. ...Show All

• SQL Server Measures dependant on another measure.

  I have a fact table that has sales data for products. I have to fields in my fact table, WantDateId and InvoicedDateId which are integer representation of a date that join to the time dimension table. I also have measures for feet, pounds, sales dollars, and material cost. I have a bunch of dimensions for product type, sales rep, territory, shipped date… I my cube I want to show a picture of sales for three things broken down over the dimensions. What has been ordered What has been invoiced What is outstanding (backlog). Most important is the current month where some will be shipped and some will be backlog. The key here is that if the invoiceDateId = 0 then it has not shipp ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. DirectInput not usable yet?

  Hello, i was in need of working with mouse and keyboard inputs but I notice the DirectInput.SystemGuid class is gone (i used in DX9) and getting the Guid from the GetDevices() seems impossible too, since is "Method isn't found" yet... So, how are we able to use the DirectInput.Device(Guid, Handle) if we cannot get the Guid from anywhere Or is there another place to get the Guid from TIA This forum is about Direct3D 10. I will move it to the right one. But to make sure that someone can help you please provide some more information’s about the operating system where the problem occur. ...Show All

• SQL Server How to ZAP a table?

  Is there a way to zap a table. If not could you name a sys.sp_.... that could do it Thanks Hi, what do you want to achive Do you want to execute the query on a regular / scheduled basis Or should it be an adhoc action which is triggered by some user action HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• SQL Server Blob as text

  Hi, I have a conversion application which convertts an access database to an sql server(different versions). I'm using stored procedures. The thins is that I export the OLe Object form access to SQL varbinary. what I do is to convert the binary data from the OLE Object to string using ToBase64String. The thing is that when I execute the SQL statement I get the following error: Error:Operand type clash: text is incompatible with varbinary. Can anyone tell me what I do wrong and how can I fix this Thanks. You are trying to convert a string literal that is not in hexadecimal format to varbinary implicitly and this will not work. You need to use either text/ntext in SQL Server 2000 or varchar(max ...Show All

• .NET Development DoEvents not working?

  This code doesn't seem to be working right. What I need to do is watch for left and mouse downs, and when both are down at the same time, show a window. This class should do it, but isn't working. The processMessage variable tells the mousehook to send the message to the appropriate window or to consume it. Public Class mouseComboWatcher Private WithEvents mh As WickedOrange.MouseHook Public Event ComboPressed() Public Event ComboReleased() Sub New () Me .mh = New WickedOrange.MouseHook End Sub Private leftMouseDown As Boolean = False Private rightMouseDown As Boolean = False Private comboDown As Boolean = False Private Sub mh_Mouse ...Show All

• Visual C# Is Form Loaded

  How do I know when a windows Form is loaded.. For example.. If i wanted to run a function one the form loads.. how would I do this P.S: Sorry If Im not clear.. but If Im not please let me know. first you can click double in the Form then, you write in this formload event: { callmyfunction(); } out of this formload event you write: private void callmyfunction() { MessageBox.Show("this is my function"); } hope that it helps you ...Show All