Rxra's Q&A profile

• SQL Server Newbie question: adding a single value to a list in a stored procedure

  I have two tables. UserIds is a collection of users, with UserId as the primary key. Contacts simply maps pairs of users. Think of it like IM, where one user can have multiple contacts. UserIds ---------- UserId - int, primary key Username etc Contacts ------------- UserId - int, the UserId of the user who has the contact ContactUserId - int, the UserId of the contact I also have a stored procedure named GetConnectedUserIds that returns all the contacts of a given user. It takes a single parameter, @UserId, the UserId of the user whose contacts I want to get. That's pretty simple: SELECT ContactUserId FROM Contacts WHERE Us ...Show All

• SQL Server How to restore, transfer or copy a sql 2005 database to sql 2000 server

  Because I'm stupid I assumed, it would be simple to move a sql server 2005 database to sql server 2000, if I don't use special 2005 features. But restore completely not work. No option in case of restore OK - there are some hints about using export etc. in http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=166196&SiteID=1 But it seems to be not so easy. Can someone please explain, how to do this move step by step I need complete transfer for all objects, including fulltext, indexes, triggers and data. Can I use BCP :-( Many thanks for help - I run into real trubble with this... fd2000 ...Show All

• Smart Device Development VB or C#???

  I'm about to do a project using the .NET Compact Framework. I want to create an application for a PDA/Smartphone but I'm not sure which to use, VB or C#...which is better Ooh I see...yea I'm more familiar with Java so I'll go for C# then Cool thanks David ...Show All

• Visual C++ Ok I am in dire need of some help here :/

  I cant even get a hello world console app to work. I downloaded Visual C++ 2005 express beta 2, and the Platform SDK. I just chose to do a Win32 console application, chose to use the pre compiled header, and typed in the very simple code. #include "stdafx.h" int _tmain( int argc, _TCHAR* argv[]) {     cout<<"Hello World!"<<endl;     return 0; }   When I go to compile it, I get a compiler error saying: ------ Build started: Project: Hello World, Configuration: Debug Win32 ------ Compiling... Hello World.cpp c:\documents and settings\owner\desktop\hello world\hello world.cpp(4) : f ...Show All

• Visual Basic SignTool reported an error 'An internal certificate chaining error has occurred.

  I am new to code signing. After I swtich from the temperary test certificate to a real certificate from a CA, when I publish, I got two errors "Error 1 Cannot publish because a project failed to build." "Error 2 SignTool reported an error 'An internal certificate chaining error has occurred. '." and when I checked "Sign the assembly", when I build, it asks for a password, after I entered password, it says "Cannot find the certificate and private key for decryption" Help me. Thanks Wei My first guess is that your certificates don’t chain up to a trusted root. Currently in order to sign we require the certificate ...Show All

• Windows Forms Distributing required updates?

  Our company has written a WinForms application. Since not many of our customers have the .NET framework yet, we've put the download links on our homepage. We've also linked the required updates for .NET framework to make installation as convenient as possible. It seems that many of our customers still have ISDN and don't want to download ~200 MB. Are we allowed to se ...Show All

• 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

• Smart Device Development VS 2005 Express and WM 5.0 SDK

  Hi, Is it posible to develop aplications for Windows Mobile 5.0 on Express editions of Visual Studios 2005, or you have to use full Standard / Profesional Editions. I am moustly interested in C++ / C# development. Thank You. Unfortunately, the express editions "Mobile Device Support". You need VS2005 Standard or higher and there is also a stand alone SDK. For more on the features of each VS2005 flavor see this: http://lab.msdn.microsoft.com/vs2005/productinfo/productline/default.aspx Cheers Daniel ...Show All

• Visual FoxPro Starting EXE fails, asks for missing FXP

  Hey, I have an app, usually works fine, and it works at many other client sites. But at one it will occasionally hose, and starting the EXE goes to the VFP window (even in my top level form app) and brings up a find file dialog, looking for an FXP. Anyone know why this happens Cetin, I see what you mean now. I missed the point. ExecScript() looks for an external file on the disk, not built into the EXE as other VFP functions do. But I don't think that was his problem originally. Point taken.   ...Show All

• Software Development for Windows Vista IPv4 config problem

  Vista was working before 5231.  Installed 5231, not only it has lost the network config (wireless) settings...I assign static ip 10.0.0.109 with 255.255.255.0 a) it does not do any TCP networking whatsoever b) Connection Status (and ipconfig at command) says IP Address 169.254.30.222 with 255.255.0.0 How come......   What technology are you using to secure your wireless access point   WEP, WPA   What kind of access point is it, are you able to connected with Windows XP   Josh WindowsConnected ...Show All

• SQL Server Display first record occurance in textbox in RB

  Dear Anyone, I would like to display the first occurance of a record as a text box outside that of the report. I would like to do this in Report Builder. Is this possible Thanks, Joseph If you just want the dataset scope, leave out the second parameter: = First(Fields!FieldName.Value ) RB doesn't expose the RDL field names directly, so you'll have to guess that part. It's usually equal to or a predictable variant of the text in the column header. ...Show All

• Visual Studio Team System Access Scenario name programmatically?

  Hello again, I have a simple & quick question:  is there a way to access the name of the scenario in a load test from code thanks!   It is accessible from a load test plugin.  To create a load test plugin do the following: 1) Add a class library project to the test project 2) Add a reference to the Microsoft.VisualStudio.QualityTools.LoadTestFramework.dll. 3) Have a class implement the ILoadTestPlugin Interface 4) In the plugin, you can connect to a number of different events that occur during the load test.  The code below does not doing anything useful but it shows 2 ways to get the scenario name. 5) A ...Show All

• Windows Forms The v2 DatePicker doesn't support null databinding (bug?)

  The following code (which is a simple test windows form - visual studio team 2005 system beta 3 refresh) demonstrates what I believe is a bug in the DatePicker control. When a datepicker is bound to a binding source set to an object, properties of type DateTime that are null are not updated when the user (at runtime) changes the date. This is a real pain; and, frankly, makes the date picker useless to bind to database-derived datatables which could contain dbnull. Thank you in advance for your help. (also: why is it called datetime picker when it does not pick the time ) Correct. The DateTime picker does not support null ...Show All

• Visual Studio extension to make a cfg

  Hi, I would like to make an extension to visual studio that creates a control flow graph (CFG) for an arbitrary C++ program. The only problem I'm having is that I can't seem to access any code element in the body of a function such as an "if" statement or an assignment. Is there some way to see and manipulate these code elements Many thanks! Robert The code model was not designed to give statement level code elements. You will need to parse the contents of a function yourself to get to that information. Craig ...Show All

• .NET Development Creating a new ASP.NET membership provider

  Hi, I have recently installed MS SQL Server 2005 Beta and am now trying to use this to store my membership/profiles information instead of the MS SQL Express. But I can't see how I'm suppose to add the Provider.  All the documentation that I have seen has said that it can be done via the "Web Site Administration Tool" under the provider tab.  By selecting add new provider.  But it isn't there Anybody else got any ideas Thanks I have the same problem. I have generated App Service Database with the name "Butikk" (did not use the default name aspnetdb), on my server OPS01\FULLSQL. My connection st ...Show All