John Fly's Q&A profile

• Visual FoxPro Interactive queries in an executable

  Does anyone have an easy way to give experienced users a “MODI QUERY” type capability inside of an executable without programmatically building it from scratch We have a client that is experienced in FoxPro and knows how to create queries using MODI QUERY from the command box. They have quite a few of these and use them to select data by changing the selection criteria in the query designer. In an old FoxPro for Windows module of the application (running as an app), we made it easier for them to run these queries by letting them put them in a directory that we read and used to build a pick list. When they selected the query, we would execute the MODI QUERY command inside of the app for them with the selected query. We are now upgrad ...Show All

• Visual Studio Team System Work Space issue

  I was just brought onto a project as the Build Manager just about a month ago. I am a MCSE not a MCSD. The old Build Manager left the company and we are attempting to resolve a few issues with this server. First is the mapping of the workspace. I see the workspace that was used. I am unable to map to that space as the server still thinks it is being use. I have read a number of post talking about command line “tf” command. However on the server I am unable to get this command to work at all. Whenever I attempt use this command I receive the error saying this is not a recognizable command. How then can I determine who is linked to the required folder I have also attempted to look in the C:\Documents and Settings folder st ...Show All

• Windows Forms How to run the exe file without UI made by InstallShield?

  Hi All, There are several popular tools to make installation package such as InstallShield , InstallAnywhere and a tool provider by the VS . I'm work on a project about automatic deployment, I know there is a tool can run the msi file without UI in the window, but I cannot find a way to do that for the exe installation package (such as made by InstallShield). Is there some suggestion By the way, is there some SDK for the Windows Installer service I know there is a way you can run setup.exe in slient mode. I think in innosetup it is /silent for some messages and /verysilent for install without any messages. I think it should be /s or something like that. ...Show All

• SQL Server DATAMINING tasks

  what are the different data mining tasks........... The most common basic data mining tasks (supported by SQL Server 2005) are classification, regression, clustering, forecasting, association analysis, correlation analysis. All tasks act as blocks in solving a really large set of business problems. A few starting points: - http://www.microsoft.com/sql/technologies/dm/default.mspx -- The tutorial and the Webcast ("Introduction to Data Mining in SQL Server 2005") provide a good description of what data mining tasks are supported in SQL Server, plus details on the tools - http:// www.sqlserverdatamining.com -- lots of information, tutorials etc. ...Show All

• Visual Basic Thread problem with GUI user control by using raiseevent

  Dear All, I have a program which have a main thread to keep updating a object. When the object's properties is being updated. It raiseevent and I have several user control will handles the object's event using Invoke with Delegation . However, under some situation such as I close one form which contains the user control which is associated with the object's event. Sometimes it will make the main thread corrupts which can not update the object properties anymore. My primary suspection is whe the main thread is trying to raiseevet, the other hand the I close the form. The user control is closed so the main thread is being blocked by this action. So I try to use BeginInvoke to replace Invoke to avoid the blocking for the main thre ...Show All

• Visual Studio 2008 (Pre-release) Root directory?

  Is there a common way of telling where the hosting root directory is with a WCF service With a standard HttpRequest I can use MapPath but with WCF I could be hosted by IIS or self-hosted so I don't want to use the HttpContext method of MapPath. With WCF the documentation says to stear clear of HttpContext and use OperationContext but I don't see the equivalent of MapPath in OperationContext. I need to access a file and I don't want to hard code the path. Any ideas Kevin ah self-hosted, sorry. please have a look at this: http://blogs.msdn.com/wenlong/archive/2006/02/21/read-configuration-data-from-hosted-wcf-services.aspx hth, Allan ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How to display surface onto interface

  Hi I'm have some experience in writing programs in vb, and now i wish to try using DirectX for graphics. I thought the easier place to start is at directDraw. I have already created and drew on a DirectDraw.Surface, may anyone please tell me how to display that surface onto the interface Some folks do Find DirectDraw the place to start but these days its considered old technology and there are few reasons to use it other than you want to support very old hardware. Unless you have a very good reason you should start with Direct3D (which can do 2D just fine). There are many more tutorials for Direct3D. However not many in VB. Check out http://www.thezbuffer.com/categories/tutorials.aspx for a f ...Show All

• Visual Studio Team System Web Test using visual studio 2005

  Hi, i m using visual studio 2005 build in feature to test the website, adding the new test to the solution by going in the test menu is gud.. but when i right click on the test and say new test, i dont find any web.test in the dialog only two options, which i get are orderedtest and unit test. i m using visual studio 2005 team suite but cant find the web.test .... do i need to download this addins or whts the solution... Are you sure that you have Visual Studio Team Suite and not Visual Studio Team Dev. The Suite sku has all the test types. The dev sku does not have the web or load tests. Visual Studio Team Test also has web and load tests. ...Show All

• Windows Forms Unbound DataGridViewComboBoxColumn - strange error

  It doesn't seem like it should be this hard to do this, but for some reason it's just not working out. I have a DGV to which I am adding rows. One of these columns is a ComboBox Column (DropDownList style). The values in this combo box come from an enumeration I've defined. I am using the following code to set the items in the combo box, and to add a row: Dim combo As DataGridViewComboBoxColumn = DirectCast (DataGridView1.Columns( 0 ), DataGridViewComboBoxColumn) combo.DataSource = [Enum].GetValues( GetType (FilterType)) ... DataGridView1.Rows.Add(theFilt.FilterType, theFilt ...Show All

• Visual Studio Express Editions I don't know the correct way to make if statments with variables on fucntions.

  You will get what I'm trying to do just look at code. Public Class Form1 Sub PlayBackgroundSoundFile( ByVal sound) If sound = "a" Then My .Computer.Audio.Play( "a.wav" , AudioPlayMode.Background) End If If sound = "i" Then My .Computer.Audio.Play( "i.wav" , AudioPlayMode.Background) End If If sound = "u" Then My .Computer.Audio.Play( "u.wav" , AudioPlayMode.Background) End If If sound = "e" Then My .Computer.Audio.Play( "e.wav" , AudioPlayMode.Background) End If If sound = "o" Then My .Computer.Audio.Play( "o.wav" , AudioPlayMode.Backgrou ...Show All

• SQL Server Plug-in Algorithm in data mining using SQL Server 2005??

  Hi, actually i want to implement a c# component that can help third party data mining algorithm and i want managed plug-in algorithm (without wrapper),. is it possible to write whole application in c# as Analysis servisce is in c++ , can we implement it in c# thanks in advance ~Chinmay If you're trying the re-implement the COM interfaces in C#, it will be much harder than the managed C++ wrapper we've provided - you'll need to do your own research in that case. Testing the wrapper would be a combination of whitebox testing and a sample plug-in written using your custom wrapper methods (similar to the one we supply with our Managed Plug-in API Framework). ...Show All

• Visual C++ fopen_s returns EACCES ?!

  As part of porting a project from VS6 to VS8, all calls to fopen were replaced (by a different team member) to fopen_s. The old call is sfile = fopen(LPCTSTR(FileName), "w" ), and works fine. The new call is fopen_s(&sfile, LPCTSTR(FileName), "w" ), and it returns EACCES (permission denied) Executed on Windows XP SP2, on which the file was created and is manipulated using the same account at all times. Any clue as to what's going on here and how to solve it Thanks in advance, me. OK, the problem was one routine fopen_s'ed the file without closing it, and the next routine tried to fopen_s it again. With old-style fopen there was no problem on either VS6 or VS8. ...Show All

• Visual Studio Express Editions Disable automatic dataset generation from XSD?

  Is there any way to stop Visual C++ from automatically generating a dataset from my XSD's I've got a couple .xsd files in my project. Whenever I edit and save the .xsd files VC++ generates a .h file for that .xsd containing a class deriving from System::Data::DataSet. My project isn't even .NET, it's native C++. ...Show All

• Windows Forms DataBinding to TextBoxes

  I have been tring for weeks to figure out how to do this and am failing and about ready to give up and find another programming language.... What I am doing seams so simple. I have a winform that I want to display all the data in text boxes. the database is in Access and has at least 4 tables in it. The tables are related using an ID number in each table. The child tables also has a column that stores a text code that defines which set of text boxes the rows is storing data about. The code below is an attempt to make this work. It works in that the peogram does not come up with an error but the text boxes doesn't display the data in the different rows. All the textboxes display the same data. Can anyone help me Is there a better ...Show All

• SQL Server Problems with the SELECT ROW_NUMBER() OVER approach

  Hi guys, I am using this approach in order to be able to do server side paging on the SQL server (why Microsoft, why can't you just put the limit vlause to work ). Anyway, here is what I am using... http://davidhayden.com/blog/dave/archive/2005/12/30/2652.aspx My code is somehow structured like this: WITH LogEntries AS ( SELECT ROW_NUMBER () OVER ( ORDER BY Day , Month , Year DESC ) AS Row , * FROM reptable where $LOTS OF CLAUSES$ ) select Year , Month , Day , $ALL MY DATA$ from LogEntries where Row between ( @PageIndex - 1 ) * @PageSize + 1 and @PageIndex * @PageSize This works like a CHARM. Problem is I've placed this under a stored procedure and I need t ...Show All