pastmaster's Q&A profile

• Visual FoxPro pulling data from one field and making a new column out of it

  Hi all!!! I have two fields, work_id and sp_id. All sp_id's are related to the work_id's ie. work_id sp_id 1 000 3 000 3 111 5 111 9 000 9 111 i need the data to be listed by the work_id, then in another colum have it state whether it is one sp_id, the other sp_id or both sp_id work_id sp_id 1 000 3 both 5 111 9 both any insight life is short, but sweet!! Mike SELECT WORK_ID,MIN(SP_ID) AS SPID,COUNT(SP_ID) AS CNT; FROM TABLE; GROUP BY WORK_ID; INTO CURSOR TEMP SELECT TEMP SELECT WORK_ID,IIF(CNT>1,'BOTH',SPID) FROM TEMP ...Show All

• Visual Studio Team System Problems with C++ compilations in VS2005 Team Developer, but not in VS2005 Professional

  When running c/c++ compilations we get errors from devenv.exe. When running the very same projects with devenv.exe in VS2005 Professional we do not get these errors. The projects are converted from VS2003. The first error does not stop the compilation, but we get the error in several projects. The projects are not under any source control at this location. 75>Could not delete temporary file. Make sure that you do not have it open and that the file is not protected.   This error seems to be related to the internal behavior of the compiler: 3>cl : Command line error D8022 : cannot open 'd:\integration\rel5_xx\man\classlib\p ...Show All

• Visual Studio Visual Basic .NET 2005 / Crystal Reports for VS 2005

  Hello, I have looked at many of the resources available (written in a pre 2005 VB), but have not found anything that works right. Below is my problem... Currently, I use VB 6.0...and its Data Reports for making a report. With that data report, you can add code to it that will connect to a database...run a custom SQL statement....etc etc. Below is an excerpt of code: ---------- Private Sub DataReport_Initialize() 'Dimming of variables used. Dim strSQL As String 'SQL String. Dim oConn As New ADODB.Connection 'New ADODB Connection. Dim oRS As New ADODB.Recordset 'New ADODB Recordset Dim BarCode As String Dim i As Integer Dim o As Integer 'Me. ...Show All

• .NET Development How to get rid of Windows Excpetion "no disk in drive"

  Hi, I have code to read the files from a dvd surrounded in a try/catch block, but for some strange reason, when I have no dvd in the dvd drive, the exception isn't caught here as I expect. Instead, my UI gets a Windows exception: "There is no disk in the drive. Please insert a disk into drive D:.", with the Cancel | Try Again | Continue buttons. If I hit Continue here, then I see the dialog that gets presented via catching the exception. Where is this extra dialog coming from The code reads (simplified): string[] matchingFiles = new string[] {}; try { matchingFiles = Directory.GetFiles(@"D:\", searchPatter ...Show All

• Visual Studio Team System Issues with Windows Sharepoint Services while Installing TFS

  Hello All, I am installing TFS. while installing TFS we are geting following errors " Error 32000.The Commandline '"C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\60\Bin\Stsadm.exe" ...' returned non-zero value: -1. " and then doing everything what MS says we get this error. " Error 32000.The Commandline '"C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\60\Bin\Stsadm.exe" ...' returned non-zero value: -2130246864 " Can somebody please tell me what is this. I am so excited about using TFS as my Development environment. And we are not able to s ...Show All

• SQL Server Formal parameter '@P83' was defined as OUTPUT but the actual parameter not declared OUTPUT.

  We are using SQR for Peoplesoft 8.47 and MS SQL Server 2000. I have a straightforward program that inserts Merit and Accomplishment data from a csv file into 4 tables. The majority of the fields that are inserted for each table are obtained by doing a select on that table. The csv file provides the updated fields to include in the insert. What I have run into is this: If the CSV file has more than 50 rows in it, it bombs with the following error: Formal parameter '@P83' was defined as OUTPUT but the actual parameter not declared OUTPUT. The insert code for '@P83' is this: Begin-sql insert into PS_JOB_JR (Columns liste ...Show All

• Windows Forms Drawing above all windows

  I have been searching for months on this: I would like to draw on a transparent window above all other windows. I do not want to disrupt any typing that the user is doing on his current window.  An example of this type of behavior are the notification balloons. They appear on top of all other windows and they don't seem to bother anyone's&nbs ...Show All

• Visual C# A strange questoin?

  hi, guys I got a very strange question, float a = 1.18F; float b = 0.01F; float m = a + b; Run this code, the result m is not 1.19, IDE shows the value is: 1.189994 Why is that hi, i have tried it and it working fine for me nothing strange the result was 1.19 namespace ConsoleApplication1 { class Program { static void Main( string [] args) { float a = 1.18F; float b = 0.01F; float m = a + b; Console .WriteLine(m.ToString()); Console .ReadLine(); } } } best regards ...Show All

• Microsoft ISV Community Center Forums Hyper link Macro

  I am new to this stuff. I want to add hyper links to a series of numbers.eg 100 101 102 103 etc There is a number folder for each hyperlink in excel. So the 100 hpyerlink will open the 100 folder and so on. I can do i Macro to do one folder. How to i get it to do hundreds without repeating myself. Thanks for you help, cheers Boots Below an example First create workbook with one sheet named "100" Run the macro and you have 101 sheets the links are in sheet "100" Suc6 Sub CreateLinks() Dim Max As Long Max = 100 Dim Idx As Long With ThisWorkbook For Idx = 1 ...Show All

• Visual Studio Express Editions Refresh the form

  Hi I wrote a application dealing with intensive data processing - lots of loops and queries running behind the scene. The problem is the user form becomes blank after minimising and maximising, it seems i need to refresh the screen or form. Any one knows what I should do to deal with this problem Thanks Yuelin hi, Please use multithreading to carry out some tasks on your form. A separate thread can perform some time consuming operations. regards, nasha. ...Show All

• Visual FoxPro Buffer Overrun Detected!

  Hi All ! I am getting an error when I try to execute some common tasks on VFP8... The error is called by Microsoft Visual C++ Runtime Library : "Buffer Overrun Detected! Program : c:\program files\visual fox pro 8\vfp8.exe A buffer overrun has been detected which has corrupted de program’s internal state. The program cannot safely continue execution an must now be terminated. " Does anybody knows what is happening to my sistem Thanks... Yes. You've encountered a buffer overrun. ;-) To get assistance with this, call the support number (you can find it in the help ...Show All

• .NET Development Passing Variables between forms.

  I'm working on a game for school, need to declare a global variable and have every other form in the project be able to grab the value of that variable and alter or display it as nessecary. This should be a walk in the park. . . . but not for me. hahaha! Can anyone help Problem Solved! Met up with a programmer friend today. Joy! lol Created a module (only had forms in the project previously) and entered the following line: Public Score As Integer *where score is the name of the variable* I set the value of 'score' in form 1, so it resets everytime the program is run. And because the module is always running, but not visible to th ...Show All

• Software Development for Windows Vista Problem Solved

  Hello, I am using Vista Beta 2 and the Beta 2 SDK to build a Windows Media Player DSP Audio Plugin. I am using Visual Studio 2005. I do the following: 1. Select New Project 2. Windows Media Player Plug-in Wizard 3. Name the plugin - testplugin 4. Select DSP Plugin. 5. Select Audio DSP Plugin 6. Do a Build - Rebuild Solution I get the following output: 1>------ Rebuild All started: Project: testplugin, Configuration: Debug Win32 ------ 1>Deleting intermediate and output files for project 'testplugin', configuration 'Debug|Win32' 1>Compiling... 1>StdAfx.cpp 1>Compiling... 1>testplugindll.cpp 1>t ...Show All

• .NET Development Windows Service - using reflection to get Service Name from exe

  I was wondering if anyone knew how to get the Service Name from a Windows Service exe, i.e. I know the exe path (for example c:\temp\wsbeep.exe) and I want to programmatically get the ServiceName from wsbeep.exe without installing the service. I presume there must be a way, probably using reflection to do this, as InstallUtil must do something similar when I use the command: 'installutil c:\temp\wsBeep.exe'. I have looked at solutions but they all seem to assume that the service name is known already, but I want to obtain the service name from the windows service exe, programmatically. Is this possible Anyone got any solutions Th ...Show All

• SQL Server CurrentMember failed with (Multiple Items) in the 'filter fields'

  hello CurrentMember failed with (Multiple Items) in the 'filter fields' because ofcourse CurrentMember can NOT be associated with a set !! Is there a simple way to make this Multiple-Item-safe (in the filter) for example this MDX-formula: sum(     generate     (         ascendants([Posting Period].currentmember),         iif(             [Posting Period].currentmember IS             [Posting Period].firstsibling,    &n ...Show All