ananta's Q&A profile

• SQL Server Manuel Identity system

  Hi, I have a table (TABLE_A) like this: MY_ID int unique Field1 varchar(10) I am using manuel identity system like this: INSERT INTO TABLE_A (MY_ID, Field1) SELECT MAX(MY_ID) + 1, 'Field1 Value' One row insert there is no problem, but more than one row how can I use insert statement ( TABLE_B have more than one record ) INSERT INTO TABLE_A (MY_ID, Field1) SELECT (SELECT MAX(MY_ID) + 1 FROM TABLE_A), FieldX FROM TABLE_B Hi, Why not using the identity in table_A like this: create table A ( My_ID int identity(1,1) Field1 varchar(10) ) any way you intend to insert the max id each time - here in this way every time you will make an insert the table A will get an id autom ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How to use View and Projection matrix?

  Hi. I'm trying to draw a vertex buffer (using PositionColored vertex) but I can't see anything. So, reading about it on the web, I've found that I need to set two matrix: Projection and View. I've donet it! Take a look: // Create the vertex buffer private void OnVertexBufferCreate(object sender, EventArgs e) { VertexBuffer buffer = (VertexBuffer)sender; CustomVertex.PositionColored[] verts = new CustomVertex.PositionColored[3]; verts[0] = new CustomVertex.PositionColored(0.0f, 1.0f, 1.0f, Color.Aqua.ToArgb()); verts[1] = new CustomVertex.PositionColored(-1.0f, -1.0f, 1.0f, Color.Black.ToArgb()); verts[2] = new CustomVertex.PositionColored(1.0f, -1.0f, 1.0f, Color.Purple.ToArgb()); buffer.SetD ...Show All

• Smart Device Development Conforming form like message box in C#

  I want to create a windows form like a message box. This form will act as a calculator. Can I perform this I mean, can I create a form which can move on the pocket pc's desktop This is pretty simple actually. The following lines in your InitializeComponent should do the trick Me.AutoScaleDimensions = New System.Drawing.SizeF(96.0!, 96.0!) Me.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Dpi Me.AutoScroll = True Me.ClientSize = New System.Drawing.Size(100, 100) 'The important line Me.ControlBox = False Me.FormBorderStyle = System.Windows.Forms.FormBorderStyle.None Me.TopMost = True Me.ResumeLayout(False) ...Show All

• SQL Server What's the relationship among replication, publication and subscription

  What's the relationship among replication, publication and subscription I want to create replication database, what things should I know first Hi, see: Setting Up Merge Replication(Concepts,topologies, types, agents...) It answers some questions! ...Show All

• Software Development for Windows Vista Activation Context Error in MMC snapins when using Windows Vista

  Hi, Good Day to all! I have been tasked by my team leader to convert our existing MMC snap-in project to support Windows Vista. Our snap-in is very much working in Windows XP but when I tried to run it in Windows Vista, this error occurs. First-chance exception at 0x772bfc53 in mmc.exe: 0xC015000F: The activation context being deactivated is not the most recently activated one. Unhandled exception at 0x772bfc53 in mmc.exe: 0xC015000F: The activation context being deactivated is not the most recently activated one. I took this error message in my Visual Studio 2005 or VS8.0. BTW, this is the current setup: - Visual Studio 2005 version 8.0.50727.762 w/ SP (Visual Studio 8.0 SP1 for Vista) - Microsoft Management Console 3.0 ver ...Show All

• Visual C# Sound In Form...

  Hi, I was wondering if someone could provide me with some code to simply add a continuous sound playing in the background of a form I have performed a few searches but all examples are really complicated. Isn't there an easier method I guess the easiest solution would be embedding the Windows Media Player control to your application and program against it: 1. From the menu, choose Tools | Choose Menu Items 2. Choose COM Components tab 3. Check Windows Media Player component and click OK - Windows Media Player control gets added to the toolbox 4. Drag the control to your form 5. Set the player's url property to your file location: axWindowsMediaPlayer1.URL = "c:\\mymp3file.mp3" ; An ...Show All

• SQL Server Attempted to divide by zero

  Hello. I'm having a little bit of a problem and i have no clue what's going on. May be somebody can explain me how the following expression could generate the "Attempted to divide by zero" error. I would really appreciate good advice. Briefly about report itself - one dataset, on single table with three groups this is a thid one. Grouping works just fine, but SUM/SUM in a footer of group #3 gives an error. Datatypes: JTD_Hours is decimal(18,2),  JTD_Dollars is money. None of the fields is NULL, all nulls converted to Zeros on dataset level. Dataset created as result of stored procedure. Here it is: =IIf( Sum(Fields!JTD_Hours.Value,"table1_CostCode") = 0, 0, Sum(Fields!JTD_Dollars.Value,"table1_CostCode")/Sum(Fields!JTD_Hou ...Show All

• SQL Server BI Portal 2003 connecting to SSAS 2005

  Hi, I seem to have a problem connecting to the analysis server 2005 when I create a data source in BIP 2003. When I supply the servername, it says that "the server does not exist or access denied". However, when I try to use the Advanced option and create a connection string, I encounter an error message stating the ff: Line: 465 Char: 4 Error: the object doesn't support this property or method Code: 0 URL: http://localhost:8080/_layouts/1033/Menu.htc How can I make a data source connection Help is very much appreciated. Thanks in advance, May Lanie If you would like to connect to Analysis Services using HTTP, you need to make sure you setup HTTP connectivity to Analysis Server. Here ...Show All

• .NET Development SerialPort WinIOError

  Hello, We're using the SerialPort class for RS232 communication. Sometimes, but not always, our application aborts with the following stack trace: --------------------------------------------------------------------------------- 2006-08-25 13:54:25,067 [2980] ERROR DemoComm.Utility.Logger [] - The I/O operation has been aborted because of either a thread exit or an application request. 2006-08-25 13:54:25,067 [2980] ERROR DemoComm.Utility.Logger [] - at System.IO.Ports.InternalResources.WinIOError(Int32 errorCode, String str) at System.IO.Ports.SerialStream.set_BreakState(Boolean value) at System.IO.Ports.SerialPort.set_BreakState(Boolean value) at DemoComm.PDO.Port.PinChanged(Object sender, SerialPinC ...Show All

• Visual Studio VSS automation

  Hi, I have created a small automation program to get my projects from a VSS database. the problem is when I try it in my machine everything works without problems but when I try to run it on another machine (a server with Windows 2003) I get the HRESULT code -10550 that corresponds to: Bad username syntax: "%s" can you help me please Thanks this is the code I'm using Note: the errorMessage function is used only to print the error code CLSID clsid; IClassFactory *pClf; IVSSDatabase *pVdb; BSTR bstrPath = SysAllocString(_iniFile); BSTR bstrUName = SysAllocString(_userName); BSTR bstrUPass = SysAllocString(_password); CoInitialize(0); if(S_OK == CLSIDFromProgID(L"Source ...Show All

• SQL Server How do i display a checkbox on a report?

  Hi, I've been trying to display a checkbox on a report using unicode text eg. (U+2616) (Arial Unicode MS). I get the error: BC30037: Character is not valid. I have read somewhere about using html formatting to display it, how could this be done Is there any thing else i could do Thanks, Sam. I got my solution finally. Stupid me that didn't know I can open up the expression editor to choose functions from, and didn't know I can right-click the field to open up expression editor. Thanks anyway. ...Show All

• SQL Server Selecting another field from the row with the max

  For a select statement like: select f1, max(f2), f3 from t group by f1 how do I say 'f3 from the same record that you found the max of f2' Thanks! Your question assumes that the Max(f2) occurs in only one record or that f2 and f3 are somehow linked. In any case, you need to use a sub-query to find the row with the max value: Select f1, f2, f3 From t t1 Where f2 = ( Select Top 1 f2 From t t2 Where t1.f1 = t2.f1 -- assuming this is a key field Order by f2 desc ) ...Show All

• Internet Explorer Development IE 7 opening to Run Once page with error on it.

  I downloaded updates last week. I have been using IE7 for a while with no problem. I dwnloaded the updates. Now when I open my browser the page tries to go to http://runonce.msn.com/runonce2.aspx . There is an error reported for this page and it will not open up I get a blue screen. How do I eliminate this I have my home page set in the tools section but when opening it won't go to my home page until I hit the home button on the tool bar. What error is reported for the page Is there a script error Also, could you run Internet Explorer (No Add-ons) from Start->All Programs->Accessories->System Tools and see if the runonce page opens fine ...Show All

• Visual Studio Tools for Office Office 2007 add-in problem

  I have installed VSTO 2005 and also Office 2007. However, I cant find the Microsoft.Interop dll files when I am trying to develop my own customized ribbon. After searching in the web, I get to know about the Office 2007 PIA, so I download and double click to install it. However, the things still remain the same after installation progress... So, anyone has any ideas about the solution and my problem Please guide me ... thank you. oh....thanks a lot for the fast reply... I saw the options in the COM tab... btw, may I know the difference between .Net and COM tab... I am still a beginner in using VS, so hope someone can provide me some answer.. thank you :) ...Show All

• SQL Server Autogrowth values keep changing

  Hi! We have 2 dbs on our dw-server and the autogrowth values for both the data- and logfiles on both of these dbs changes about once a month. The data autogrowth value changes from 10megs to a percentage value between 3200 and 6400 and the log-file value changes from 10 percent to a percentage value between 3200 and 6400. Resulting in huge files and filling the drive. What am I missing here BR John Yes - we've been hit by this as well. We had it set to autogrow by 250MB, until after a reboot where it changed to 32000%. Unfortunately we didn't spot this until we filled up our log file disk. The annoying thing was that SQL Server Management Studio doesn't let you change back a value that has ...Show All