Connie Daniel'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

• Windows Forms Textbox disabled

  Hey, How do you make it so a textbox is diabled So nobody can type in it... Thanks I think you are refering to a 'readonly' textbox That would be setting the TextBox.ReadOnly property to true. If you are refering to actually disabling the control so nothing can be done with it (not even copy/pasting values from it, use the TextBox.Enabled property. Set is to false. ...Show All

• .NET Development Backward Compatibility of .NET Framework 2.0

  I need to find out some information so that our company can determine which version of .NET Framework to install on all desktops. We have a limited number of third party applications which currently use .NET and version 1.1 If I install new machines with only v2.0, are applications backward compatible i.e. will my current applications still (with high certainty) work - I obviously will have to have a testing cycle in any case. When v2.0 is installed on a machine which already contains v1.1, it does not prompt that v1.1 is already installed and installs both versions. Is installation of both versions (1.1 and 2.0) on a machine conside ...Show All

• SQL Server Using Extended SQLCmd Commands with T-SQL

  Are the extended command always executed even if it is contained within an IF statement I created test.sql script as follows: if '$(CreateA)' = 'Y' begin :out $(myDir)testY.log print 'CreateA is yes' end else begin :out $(myDir)testN.log print 'CreateA is no' end At the command line prompt enter: sqlcmd -i test.sql -v CreateA="Y" MyDir="C:\Temp\" I expected the file C:\Temp\testY.log to be created with the line "CreateA is yes", which occurred successfully. However, C:\Temp\testN.log was created as well, but it was empty. I deleted the log files and executed the following s ...Show All

• Visual C# Access vs c# as frontend

  We are looking at a new business application. the application will deal with hr, QA, sales, payroll, inventory, etc. One sales consultant came to us and stated that using sql server 2005 as the backend and microsoft access as the frontend is a good decision. I really do not think it is a good idea. I would rather see something in c# that ties to sql server. dont get me wrong I love access but I think it has it place and for an application for the future I just feel this is a really bad idea. This application is going to be used by 40 users. I want a system that is scaleable and robust. What are other thoughts ...Show All

• Smart Device Development Installing VS2005 & Active Sync

  Is there some special order of installing the differnt programms I'd like to have VS2005 beta2  (Team Suite Edition) Active Sync 4.0 Device SDK 5.0 DMA update But I'm not able to get it working (the connection between Device Emulator & Active Sync & VS2005) I always get a "Cannot Connect Error!" Norbers One possibility is that you are using an emulator entry that is not using the DMA transport.  You can verify this by going into the "Tools" menu, options, devices, devices, and by clicking "Pproperty" of the emulator in question.  Make sure "Dma Transport" is selected, then restart the emulator.&n ...Show All

• Windows Forms Docking MDI Child not redrawing

  I got a MDI parent, 2 MDI children, the first MDI child(FormBorderStyle=None, Dock=Fill) so it should fill up the MDI parent's empty space. But when if I load the other MDI child which this does not dock, and move it to the bottom so a scrollbar will appear to the MDI parent, when I scroll the scrollbar to bottom, the first MDI child which DOCK=FILL do move up. How can I make the first MDI child keep filling up the empty space of the MDI parent and will not move even the scrollbar being scrolled I don't understand why this functionality so poor. Borland a third party developer but i think one with ...Show All

• Visual Studio Disable updates in the edit window

  Hi, I have an add-in that changes the text in the file that is currently in the edit window of VWD. How do I disable the updates to the window while I my add-in is ruinning then enable the window and refresh it when the add-in is finished Thanks, Nick You can diable UI by setting the following property DTE.SuppressUI = False /Ole ...Show All

• SQL Server Two Questions (email from SQL & download contents)

  Hello All, Thanks in advance for any help. On the SQL Server Express 2005 download page there are two large download options: SQL Server 2005 Express Edition with Advanced Services & Microsoft SQL Server 2005 Express Edition Toolkit Is one a subset of the other Or, are both unique Just by reading it appears that the 'Toolkit' is an addition to the 'Express Edition with Advanced Services' Second question is: Is the any way to send an email(just text) based upon when an item is added to a table From my reading it appears that Express does not include SQL Mail or Database Mail, so is there some other way t ...Show All

• Windows Forms Host Designer

  I'm following the article  http://www.divil.co.uk/net/articles/designers/hosting.asp Ok well it's a pretty simple question. lets say I have a control with a Child_Form property ok,  how to I select another form if only one is loaded in the host at a time. I figured out how to load another form but it shows up on it's own and I have to set the showintaskbar& ...Show All

• Visual Studio Express Editions Checking to see if a file is active on the internet?

  Hello, I'm trying to determine if a file on ther internet is active (Working) , like from a HTTP or FTP host BUT I don't want to download the entire file. I know I can do this with the WebClient class but that downloads the entire fire. I just need to know if the file works. Also, is there a way to find out the size of the file w/o having to (again) download the entire fie THanks in advance. Daticus, You could write a socket application that connects to port 80 on the HTTP server and issue a range retrieval request.  This will instruct the web server to only send back a portion of the file from the server so that you do not get the ...Show All

• Windows Forms Creating an application running within IE.

  Hello all, Could anyone point me out to some tutorial on how to create and deploy a cab file which will run a .NET app within IE Thanks, M. Using C#, VB or JScript -- look at www-sharp.com -- well worth the cost!  Does exactly what you want and more. ...Show All

• Visual C# Are Monthly Scheduled Services Possible?

  Hello, I'm fairly new to programming in .NET and in Windows Services so any help is greatly appreciated. I'm trying to schedule a service on a server that runs on the 1st of every month, but I can't find anything that would allow me to do so. I have a service that works and I've found ways to schedule it to run every X milliseconds, but there are no set number of seconds in every month. :) Is what I'm trying to do even possible or how should I approach it The only thing I can think of at this point is to schedule it to run everyday and if it is the 1st of the month it will then run the code I want. Thanks - ljstd ...Show All

• Visual Studio Express Editions Changing Tab Index

  I have a form with 4 textboxes. I use the same keyboard event handler for each textbox. I want to check the entered data after the <TAB> key is pressed before advancing to the next textbox in the Tab Order. I have to select the ACCEPTS TAB PROPERTY to TRUE in each textbox to generate a keypressed event when the <TAB> key is pressed. After the data is validated I want to advance to the next textbox in the Tab Order. In the event handler, I don't know which textbox is selected. Is this informantion in the sender part of the Sub statement If so how do I acess the information How do I get the current Tab Inde ...Show All

• Visual C# Design pattern for internal node of a generic collection

  I am currently design a complicated generic collection with .Net 2.0. Basically I have the following design: class MyCollection<T> : ICollection<T> {     private class MyNode<T>     {        // snipped     } }   When compiled, this code generates a warning saying that T is confusing because used both for MyCollection and MyNode. In practice, the T will be same in both classes. What would you suggest as the correct design pattern for such a situation Thanks in advance, Joannes Simply omit type argument f ...Show All