Rab Lucas's Q&A profile

• Visual Studio Express Editions VB 2005 Express/MS Access - row is not being added

  Has anyone had any success with adding a row to an (external) Access 2.0 database. My code is: ' *** create a new row by calling the NewRow method Dim thisRow As DataRow thisRow = dsACCIMAGE.AccImageTable.NewRow() ' *** manipulate newly added row using column name ' note: can alternatively replace column name with column index ' e.g. thisRow(3) = SelectedPathName ' Code for the 1st column goes here after auto-cou ...Show All

• Visual C# Thread Safe Access to DateTime

  Hello all ... I'm working on a class to return the current date. It is a bit more complex than the following code due to managing cultures, but below is the basic idea. My question is: how can I ensure the execution of the get property is thread-safe, without single-threading my application My understanding from the doc that is that I need to be thread safe when using DateTime. I was thinking that lock would be too restrictive and w ...Show All

• .NET Development Kill Process Remotly

  When I Wrote this code Process p=process.getAllprocessbyName(processName,machineName); p.Kill(); I Got an error could not connect to remote computer ......... although i have all Permision If you are trying to terminate a process running on a remote computer, It is not possible to do so. You can call Kill only for processes that are running on the local computer. You cannot cause processes on remote computers to exit. Y ...Show All

• SQL Server Mapping columns in custom Destination component

  I am working on a destination component where the columns in the destination are already set.  I want to give the user the option to map columns, similar to the way the Excel destination component does it.  So, the Available Input Columns could be mapped to Available Destination Columns.  The Available Input Columns would come from a connection from some other component (either a source or a transformation component), and the Avai ...Show All

• SQL Server Treat two columns as one?

  Hi all, Is there a method to treat two columns as one, in order to use count(col) E.g.: for the following table ID Col1 Col2 ------------------ 1 A B 2 A B 3 A C The solution is: Col1 Col2 Expr ----------------- A B 2 A C 1 So, how can it be expressed in sql how many records there are with the same values for col1&col2 Kind regards, Nele Huh it is that easy! ...Show All

• Visual C++ Printing Multiple Images using DrawImage

  I'm having problems printing multiple images. I have the following code: for (i=0;i<total_images;i++) { char arr[20]; string name = "Image"; name += atoi(i+1, arr, 10) name +=".jpg"; ev->Graphics->DrawImage(Image::FromFile(name.c_str()), x,y,w,h); if ((i+1) < total_images) ev->HasMorePages = true; else ev->HasMorePages = false; } total_images = 0; This snippet of code is running constant ...Show All

• Visual Studio Express Editions VB Newbie - Database Application

  I'm a beginner with VB alltogether, and I'm in need of some direction please.  I've worked the VB Data Access samples, but they don't provide me with the information I'm needing. I have a MDB with two tables.  The City Table contains the following columns: ZipCode, CityName, State, Latitude, Longitude The FCC table contains a list of FM Antennas across the United States along with the Latitude and Longitude of each. I want ...Show All

• Visual Basic Fire off VB.NET Script based on keyboard key

  How can I tie a VB.NET console appliction to the print screen key Is there any way to capture that and then run some VB.NET code if a user clicks their Print Screen button I'd just put an exe or something on their hard disk and want them to push the print screen key then my code would fire off You need to create a windows hook to be notified when a key is pressed. ...Show All

• SQL Server A Problems after the install of the Hotfix

  After installing SP1 and then the hotfix: http://support.microsoft.com/Default.aspx id=918222 We now get the following error when trying to work with date parameters in Report Builder: Query (6, 117) The '[VBA].[DateSerial]' function does not exist. ---------------------------- Semantic query execution failed. ---------------------------- Query execution failed for data set 'dataSet'. ---------------------------- An error has occurred duri ...Show All

• Visual Studio Team System Availability of 3rd party templates for "Requirements"?

  Are there any 3rd party Process templates (for Import into TFS) that address the area of project Requirements tracking (Commercially available or in-development). Surprisingly, this key area is not represented at all in the MSF Agile process. Barkingdog To be a bit clearer, I was thinking along the lines of tracking Requirement documents, in Word, as work items. Barkingdog ...Show All

• Visual Studio .NET Linker / MSBuild ?

  Hi We have a windows application built using .NET 2.0 that has a number of assemblies / third party addon tools.  I have ready about utilities to "link" all these DLLs etc into one single exe.  So instead of having a load of serpate files I have one application.exe. Has anyone used these tools can someone recommand one   ideally free I thought MS was working on something like this Thanks Woodyuk ...Show All

• Visual Studio Team System RC Error TF53010

  Any thoughts on how to debug this error It also appears that Report Services is unable to connect back to SQL Server, so I'm thinking there is an identity/permissions issue going on. Is there a walkthrough for double-checking all identity/permissions Thanks for any assistance. TF53010: An unexpected condition has occurred in a Team Foundation component. The information contained here should be made available to your site administrative staff. ...Show All

• Software Development for Windows Vista Can TargetStateName of SetState Activity be dynamically modified?

  Is it possible to modified the targetstatename of a SetState Activity after the workflow instance have been invoked Hi Mick, I publish my workflow as webservice. I add a CodeActivity between WebInputActivity and WebOutputActivity, and make the execute code as following: WorkflowRuntime runtime = WorkflowWebRequestContext.Current.WorkflowRuntime; StateMachineWorkflowInstance instance = new StateMac ...Show All

• Software Development for Windows Vista The Writer is closed or in error state.

  Hi, when WorkflowMarkupSerializer wants to serialize a workflow and somewhere finds a field with generic List type (filled wi th custom objects which are serializable), its throws a " The Writer is closed or in error state. " exception and stops serializing workflow. Is also tried to use DesignerSerializationManager to figure out what the problem was, but it didn't help. Can anyone please help Thanks in adva ...Show All

• Visual Studio Team System SQL Server SP1 and hotfixes

  VSTS requires several hotfixes to be applied (i.e. KB 912373). Since I cannot find KB912373 anywhere in the known world (certainly not in the ISO of the 180 day trial), can I simply install SQL Server SP1 instead If not, could someome please tell me, where the hell can I find KB912383. Luis Miguel Huapaya Hi Luis, Where did you see you needed that hotfix The hotfixes that are needed are on the iso in the ...Show All