rosiew1956's Q&A profile

• SQL Server Reuse calculation later on in query

  How can I reuse the field CurrentBalance in my last AND statement   SELECT     rm.rmsacctnum AS [Rms Acct Num],           rf.rmstranamt10 as total_10,           rf.rmstranamt, (rf.rmstranamt - rf.rmstranamt10) AS [Current Balance] FROM RMASTER rm INNER JOIN ( SELECT RMSFILENUM, RMSTRANCDE, SUM(rmstranamt) AS rmstranamt, SUM(CASE WHEN RMSTRANCDE = '10' THEN rmstranamt ELSE 0 E ...Show All

• .NET Development Socket connection timeout

  Hello Everybody, Is it possilbe to set socket connection timeout For e.g. If I want to connect to some host with TCP connection within 3 seconds if I cant connect within 3 seconds I try some other host. I have checked socket class, apprently I cant find out some way for connection timeout Can anybody help me regarding this Regards, Tahseen.. hi, i don't know any way to change the conne ...Show All

• Visual Studio Express Editions Having trouble with real simple script

  ok i am making a webbrowser application and i want to use del.icio.us as my favorites. I am trying to make it to where when you click the Favorites button it takes you to del.icio.us. Here is my code: Private Sub Button8_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles favorites.Click http://del.icio.us/ziph End Sub That looks good to me what the heck is wrong I am a noob at VB. ...Show All

• Visual Studio Utilizing Intergated Help

  Ok... I have my CHM help files converted over to HTMLHelp2 and have MSM for them.. Now from VSIP as a plugin, How do I push context into the dynamic help How do I open a specific keyword in help on F1 How do I open a specific topic ID when the user performs an action There are several reasons why this doesn't work for you. The best place to find the answer is http://helpware.net/ , see MS Help 2 section. If you won't have luck there, t ...Show All

• Smart Device Development using in evc4?

  Hi can i use evc4 for debuging and running applications on device emulator as i cannot connect through it... regards The device emulator can act as a "real" device by connecting it through ActiveSync. I n ActiveSync, make sure that "DMA" is selected in the "Connection Settings".  Then, using the Device Emulator Manager, connect to and cradle a device emulator.  You can find the Device Emulator Ma ...Show All

• Visual Studio Express Editions Help with control binding

  Hi All I'm a bit of a newbie at vb.net and was hoping someone can help me with a problem that has me stumped. I'm sure the solution is quite simple but I can't see it. I have simple sql express database that has two small tables. Table 1 contains a foreign key from table 2. I have a form where the controls on it are bound to table 1. For the control that displays the field that contains the foreign key from table 2 I want to use a com ...Show All

• Visual C++ Pls help me out! I cannot build a very simple Hello World app.

  I have been trying to build the following simple app for these two days. #include <iostream> using namespace std; int main() {     cout << "Hello World!" << endl;     return 0; } VS2005 C++ Express complains this way; Warning    2    warning C4512: 'std::basic_ostream<_E,_Tr>::sentry' : assignment operator could not be generated    c:\program ...Show All

• .NET Development Problem with Serial communication

  Hello, I’ve to get Data from an Analyzer which is connected on my COM1 port. In the Manual of the Analyzer is the following description: Baudrate 9600 DataBits 8 Startbit 1 Stopbit 1 Parity none Handshake none The Analyzer has only one command. This command to get actual Value from the Analyzer: "IN_PV_1<CR><LF>" Here is my code: using System; using System.Collections.Generic; using System.ComponentModel; using System.Da ...Show All

• SQL Server Using the Local Service Account to run SQL Server 2005

  Are there any issues running the Database Service and the SQL Agent Service with the "Local Service" account These servers are standalone; they don't connect to any other server or use any network resources (other then clients connecting to the SQL instance). The only reason I’m question this is that the install of SQL 2005 doesn’t allow me to set the service to use “Local Service”, but once SQL is installed. The SQL 200 ...Show All

• .NET Development DataSet to new Access Database?

  I have an MSSQL stored procedure that returns multiple resultsets. I can easily turn this into a strongly typed dataset in VS.NET 2005. My boss wants me to save these data as an Access database. Is there an easy way to create a .mdb file from a DataSet I know I can save the DataSet as XML, but that is too large. I guess I don't know that an Access DB is any more efficient. Is there a more efficient way than saving the DataSet as an Access databa ...Show All

• SQL Server xp_SendMail subject error

  Hi, while sending mail through xp_sendmail the mail is sending properly. but subject getting lost while viewing the mail from outlook. can anyone help me. code: EXEC xp_sendmail @recipients = 'conmry@maersk.com', @message = 'The master database is full.', @copy_recipients = 'mah020@maersk.com', @subject = 'Master Database Status' ...Show All

• Visual Studio can't install VS2005 - "not a valid win32 application"

  I'm trying to install visual studio on desktop with an AMD64 processor (but using 32-bit XP Pro), and when I try to install Visual Studio 2005, I get a "not a valid win32 application" in a dialog box. I get the error "D:\ is not a valid win32 application" when I try to use autoplay, and "D:\setup.exe is not a valid win32 application" when I try to run setup directly from the disc. Any ideas ...Show All

• SQL Server TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host

  We are getting a problem when the below error Log Server: SQL Server 2005 and SP1. Then, All the Web Servers will drop all connections and stop the network service. Later, the network service will start up automatically but all the before service is dropped. We would like to know the error coming from Error Log ================ TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host ...Show All

• SQL Server which is the most efficient query to find out the total number of rows in a table?

  which is the most efficient query to find out the total number of rows in a table other than using - SELECT COUNT(*) ... in query Why do you not weant to use the Count(*). I guess this is the best way to count the rows in the table. If it os too slow for you and you need immediate results rather than waiting for rleased locks you can get the *approximat* value with specific WITH(NOLOCK) after the table which yo ...Show All

• Visual C++ How do I inherit from Generic type?

  I am unable to figure out the syntax to inherit from a Generic type. Can someone transalate the following c# code to C++/CLI public class MyThings : System.Collections.ObjectModel.Collection<MyThing> { } public class MyThing { public String Name { get { return m_Name; } set { m_Name = value; } } private String m_Name; } ref class MyThing { public: property Str ...Show All