Adam.Kahtava's Q&A profile

• SQL Server Third Major Flaw with Reporting Services!

  What is the way to keep multiple detail rows together on one page. There seems to be no future to keep multiple detail rows together. I'm not talking about table keep together, group page break or anything like that. I have 3 rows that need to be in one page at all times. Is there anyway that this is possible Enkh I don't really follow you on that. How do you put a "detail" rows into textboxes Do you mean actually copy the detail fields into textboxes each I'm not really sure what you mean by putting the detail rows into textboxes Copy the values Thanks for making it clearer. Enkh ...Show All

• SQL Server Stored procedure sort parameter doesnt work

  Hello, I am trying to make this. CREATE PROCEDURE [dbo] . [P_SEL_ALLPERSONAS] @nmpersona int , @sortorder varchar ( 20 ) AS BEGIN select nmpersona , dsprimernombre , dssegundonombre , dsprimerapellido , dssegundoapellido from personas order by @sortorder END But I got this error. Please help Msg 1008, Level 16, State 1, Procedure P_SEL_ALLPERSONAS, Line 13 The SELECT item identified by the ORDER BY number 1 contains a variable as part of the expression identifying a column position. Variables are only allowed when ordering by an expression referencing a column name. This works, but what if I want to sort on more than just one field For instance, ORDER BY fie ...Show All

• Visual Studio Team System Problem with filter Changed by on closed work items

  I have filter that shows all bug and tasks that I did during last week. However if someone close work item I do not see it in my queue. I use fileter "changed by"=@me. Probably it is another way to get all tasks I worked on By the way, does any command line tool that can show work items Thanks a lot for answer. However I have one more question. How to combine changed date and user who made changes. For example, I'm developer and I need to get tasks and bugs that I worked on last week. But bugs after they are resolved should be tested. So they assigned to testers. And they can change it. So I need filter that shows only bugs that only I changed last week but not testers. If I use changed date TFS ...Show All

• Windows Forms Displaying selected data in a detail form.

  Hi, really hoping someone can help me out on this. I have an application with 2 forms. The first form ( forma ) contains a datagridview which lists existing customers in my database. The datagridview is linked to a binding source etc etc and everything is displayed correctly. When I click the view customer details button it opens up another form which I want to display the details of the customer which was selected from the datagridview on the previous form. How do I go about linking the 2nd form to the selected customer I am using visual basic .net 2005 Express Edition. Any help with this would be greatly appreciated.     Private Sub ViewOrders( ByVal customerId As String ) ...Show All

• Visual Basic I keep getting an error on my main page and can't edit it until it's fixed!!!

  I keep getting this error on my main page and can't figure out what to do to fix it.... "An attempt to attach an auto-named database for file C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\Child Information Database.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share." I even removed any copies of the dataset, datatable and binding source and simply refered to the one that is left on my main user control, but I need to edit my main form and cannot. Help! check out this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=110252&SiteID=1 ...Show All

• Visual Studio MSBuild vs NAnt

  Please share your thoughts about comparison between those two     I'm having a love-hate relationship with MSBuild under TFS Team Builds. I've been trying to do what I believe is a simple task; performing a custom action (code generation) just before compilation of each solution. The problem I am seeing is that MSBuild wants to use the SolutionToBuild list as raw data and do the custom task on all of the solutions and then compile all of the solutions. So there really is no concept of "For Each Solution Do these Tasks" in the TFS Team Build without overriding the Microsoft provided targets (which I would think is a generally bad idea). I also don't want to have to update each a ...Show All

• SQL Server SMO & DMO FAQ

  I have posted common questions on my blog. Take a look at the FAQ before posting questions in this forum. I will continue to add on answers for common questions as I go. I hope this helps finding answers faster! http://blogs.msdn.com/mwories/articles/smoindex.aspx Comments, let me know! Thanks, Michiel the link is broken . . . ...Show All

• SQL Server Management Studio 2005 - Enterprise Manager Layout

  Hi, I am led to believe that there is an option to change the view of SQL 2005 Management Studio to a view simular to Enterprise Manager in SQL 2000. Does anyone know how this is done Regards, ...Show All

• SQL Server Outer join for two tables

  Hi guys, Please Help! I am using Excel's VBA in order to retrieve sql Data. I have three tables of the "my Company " DataBase (sql server 2000): Table1, Table2, Table3 I need to join: Table1 .FieldXX= Table2 .FieldYY Table1 .FieldWW= Table3 .FieldZZ In both cases, I should retrieve all data from Table1 , even if Table2 or Table3 don't have the correspondent entries. I am trying to use the code below, but getting "sql syntax error" : FROM myCompany .dbo. Table1 Table1 LEFT OUTER JOIN myCompany .dbo. Table2 Table2 ON ( Table1 .FieldXX= Table2 .FieldYY) AND LEFT OUTER JOIN myCompany .dbo. Table3 Table3 ON ( Table1 .FieldWW= Table3 .FieldZZ) I ...Show All

• SQL Server SSIS Package Execute Error

  While executing packages in a file from a procedure, I get error: Error: 2006-10-24 14:58:54.62 Code: 0xC0016016 Source: Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available. End Error Please let me know how to solve this error. Hi, The package you are trying to run was it created by some other user id apart from yours. May be in the package the person who made it while making connections with the OLEDB has set passwords for it. Try removing thos ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How to detect when secondaryBuffer finish playing a file?

  I need to play a wave file looping with a specific interval between loop. Is there any event thrown from secondaryBuffer object when it finish playing a file Have a look at IDirectSoundNotify8::SetNotificationPositions. You can use DSBPN_OFFSETSTOP to get a notification when the buffer stops playing. There is an example in the docs under the DirectSound/Programming Guide/Capturing Waveforms topic. ...Show All

• Visual Basic Adjusting the System Clock

  Hello everyone I have a question. I have a program that has 3 variables TimeTemp = TimeofDay (Date Type) Adjustment=(number of seconds different from NTP server)(integer Type) CurrentTime (Date type) = TimeTemp + Adjustment VB2005 is saying that I can not add adjustment to Timetemp. what do I need to do to adjust the system clock Hope this makes sense Kevin Here's an example using SetLocalTime() as mentioned above (VB.NET): ' In class Private Type SYSTEMTIME wYear As Integer wMonth As Integer wDayOfWeek As Integer wDay As Integer wHour As Integer wMinute As Integer wSecond As Integer wMilliseconds As Integer End Type Private Declare Fu ...Show All

• Software Development for Windows Vista More vista bugs ? How do you determine if UAC is enabled ?

  Hello, Just testing with Vista RC2 (downloading RTM as I write this) and I would like to know if anyone knows how to correctly determine in a c++ program whether UAC is currently enabled on the machine Also when UAC is turned off, and one is not logged in as an administrator, "RunAs" in ShellExecute() no longer seems to allow the execution of a task as a full admin. This seems to apply to Microsoft's own applications too. Try running the task manager (CTRL+Shift+Esc) on a none admin account, with UAC turned off, and then click on the shielded "Show processes from all users" The task manager restarts itself, and nothing else happens. If the shielded button does not work, then why is it shown A jolly poor show IMHO. Jus ...Show All

• Smart Device Development Pocket PC applications

  Hi all l recently purchased myself a pocket PC running Mobile Window 5.0 . l have Visual Studio Pro 2005 and downloaded Pocket PC SDK (174 MB) l am familiar with Visual Basic and would like to make a couple of simple applications that can run in my pocketPC . l am looking for articles and/or tutorials and/or any help which will describe STEP by STEP how one can transfer an application made in Visual Basic with VSPro 2005 to the Pocket PC and see it running . Thanks in advance Hi Manav Thanks reply . However visiting both addressed suggested l could not get anything that could help me with my question , simply because in their instructions , for instance - go to - File/... ...Show All

• Microsoft ISV Community Center Forums Removing "Trial Version" from Web Components on SharePoint web sites

  Hello, I would like to remove the "Trial Version" as stated above. I used CSS but then other part disappear as well so this is not an option. Then I tried JavaScript but wasn't working either. Question: is it somehow possible to do it with JavaScript (I have only limited scripting capabilities). Or can I directly access the template that creates the different sharepoint web sites for my purposes I would appreciate advice on this matter and thank you for your attention. Regards Christian ...Show All