NelG1's Q&A profile

• Microsoft ISV Community Center Forums Check diff

  I have a sub that is called from a loop. It is supposed to check if the difference between two numbers is greater than a predefined errror tolarnance. However the difference between the two numbers shall only be checked if neither of them are zero. My problem is that no differences are deterected. My code is: Dim dblLocalReturnDiff As Double If rng4.Offset(l, 0) <> 0 And rng3.Offset(l, 0) <> 0 And rng4.Offset(l, 0) <> rng3.Offset(l, 0) Then dblLocalReturnDiff = rng4.Offset(l, 0) - rng3.Offset(l, 0) If Abs(dblLocalReutrnDiff) > dblErrorMarginal Then MsgBox ("Local return skiljer sig at mellan portfoljen och benchmark!" & vbCrLf & "Kolla upp vad detta kan bero p ...Show All

• SQL Server Sum Buildin function is not considering negative numbers!

  Hi! i am using the SUM buildin function of AS2005. it is not considering the negative numbers. There are some settings am I forgetting I am just adding, under measures, a new measure with aggrergateFunction=SUM and the database field "AMOUNT". In the db the amount is negative as well.... Thx mcrisf Mcrisf, SQL Server 2000 is where I have seen this issue. The data entered the table using an Oracle ODBC driver. You can test by executing the following query (replace "value" with your column name): select value, 1*value, cast(value as VARBINARY) from table An example follows: select top 5 quantity, 'Times1' = 1 * quantity, 'Varbinary' = c ...Show All

• Visual Studio Express Editions Firstly make sure there is no problem in your stored procedure

  i try to pass the datasource to my report , but when i designed i use a store procedure with params. Now when i show the report , i have a error for missing params i need clear ,remove o ignore the params Thanks 1. Examine whether there is any rows modified. Attention: no matter the database modified, the trigger will be called, the result depends on the execution of T-SQL statement while there is no relation to the potential "where" sub statement execution. 2. You can never use the deleted rows any more, so please check the deleted tables. 3. Check the code return from T-SQL in order to catch any problems that cause the mistakes. ...Show All

• Visual Studio Team System VSCover80.dll Vista 64bit, VS .Net 2005 TS

  Hi, I have a strange problem, I installed VS .Net 2005 Team Suite edition with full install. My tests can't run code coverage becuase VSCover80.dll is missing. I reinstalled VS but same problem. Does anyone know why Is this a Vista known problem I also tried SP1 beta for 2005 but no VSCover80.dll either. So anyone know why thanx Johan / NSquared2 www.johannormen.com/blog VS 2005 TS is still waiting for an update for full compatibility with Vista. If you are still seeing this issue after that update has been released, we can revisit this issue. ...Show All

• Windows Forms DataGridView wont show new entry..until i run it again

  Guys..i'm new here...and new with VB2005..im having this problem..that my datagridview wont show the new entry(i have a reg page) until i rerun the program...can anyone please look it up..tnx very much..could really use some help.. Form1.vb: Imports System.Data.OleDb Public Class Form1 Private AccountsDataSource As New BindingSource(My.Application.DAL.dbDataService, "Accounts") Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Me.dg.DataSource = Me.AccountsDataSource End Sub Private Sub dg_CellContentClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles dg.CellContentClick End Sub Private Sub Fill_Click(ByVal s ...Show All

• SQL Server Changes to data not replicated

  I have an application that uses web-based merge replication. My publisher is SQL 2005 and my subscriber is SQL 2005 Express. I control the replication with RMO code. If I make changes to the data in both databases using SQL Server Management Studio Express, my RMO code correctly syncs the two databases. However if I make changes to the data at the subscription through my application, these changes are not picked up by the replication process, even though the changes are present if you check the tables through Management Studio. What would cause these changes to not be recognized Any ideas would be appreciated. Hi there, If you have changed the data in such a way as to stop the triggers from firi ...Show All

• Visual C# Did anyone manage to generate XmlSerializers assembly from IDE?

  Hello, We need to generated XmlSerializers assembly for some of our components. Visual Studio 2005 has a convenient way to achieve this: Project properties -> Build -> Output -> Generate serialization assembly -> (On). We tried this on several machines, but no serialization assembly is generated. However, if I run SGEN.EXE on the same assembly, then it works fine. BTW, our assemblies are signed, so we have to pass a key to SGEN command. Can this be a reason Best regards Vagif Abilov The Visual Studio 2005 IDE only seems to honor the Generate Serialization Assembly = On switch when you set this in a project that references a web service. Like the other post mentioned, this is probably due to the flag that indic ...Show All

• Visual Studio Express Editions Relative path of an exe file

  hello i need to run some .exe files from my C# program ,currently i have the files in a separate directory in resources and i just use the absolute path to open and run them. I want to know how i could specify a relative path to the directory in which the user installs my application after i distribute it ..and also will the exe files automatically be included in the distribution when i publish the solution Hello, Hope these links give you an idea on how to package and deploy your Windows Forms Application. Packaging and Deploying .NET Framework Applications This tutorial shows developers how to package and deploy .NET Framework applications and components using the .NET Framework SDK. http://msdn2.microsoft.com/en-us/aa ...Show All

• SQL Server execute sql task resultset

  hi all, in my execute sql task, i have a try catch statement to catch error code if there's an error... begin try insert into person.contact (contactid) values ('1') end try begin catch select @@error as ErrorCode end catch this ErrorCode will be mapped to a user variable. my problem is the value for ResultSet. in order to assign ErrorCode to the variable, i have to set the ResultSet value to Single row, but if this task does not fail, i need to set ResultSet value to None in order for it to run successfully. How do i go about solving this problem Please help. thanks! oh.. but if i omit the try catch statement, the @@error value can't seem to be assigned to the package variable. ...Show All

• Visual Studio Using SccPopulateList to get the list of subprojects from VSS or other source control provider

  Hello Does anyone know how you can get a recursive list of projects (subfolders) from source control provider using SccPopulateList If you use spec 1.3 of MSSCCI, it is easily done using SccPopulateDirList which is recursive. In v. 1.2 (VSS 6.0, SourceGear Vault), SccPopulateDirList is unavailable and the SccPopulateDirList only returns one folder. If you have no prior knowledge of contents of source control folder, how can you get subfolders under the given folder Thank you This is what I suspected. Do you think that VS and source control plugin UI (that clearly can display recursive lists) use either automation or some proprietary API that is not a part of MSSCCI Does Visual Studio then ...Show All

• Visual Basic Help: How to speed up the process if doing the files (one by one) deletion to recycle bin

  by using the following source code, i found that it take a lot of time to do the files deletion. Is there any setting that i could set to speed up the process please do help me. thank you  Private Type SHFILEOPTSTRUCT   hWnd As Long   wFunc As Long   pFrom As String   pTo As String   fFlags As Integer   fAnyOperationsAborted As Long   hNameMappings As Long   lpszProgressTitle As Long End Type Private Declare Function SHFileOperation Lib "Shell32.dll" _   Alias "SHFileOperationA" (lpFileOp As SHFILEOPTSTRUCT) As Long Private Const FO_DELETE = &H3 Private Const FOF_ALLOWUNDO = &H40 Public Sub DeleteFileToRecycleBin(Filename As String)   Dim fop As SHFILEOPTSTRUCT ...Show All

• SQL Server How to make a File Share Subscription running on Vista?

  I recently migrate to Vista.   I had a bunch of reports with file share subscriptions that were running fine on XP.   After installing reporting services on vista (that part only was a challenge), I re-created my subscriptions using the report manager.   As expected, when a subscription is executed, the ‘last run’ column shows the last time the report output has been delivered to the file share and the ‘status’ column shows ‘New Subscription’.   I thought that this was the signature of a successfully configured subscription.   But surprisingly, there is nothing in the file share. The directory is empty.   Anybody has an idea why   Anybody knows how I could possibly find information on my ...Show All

• Windows Forms Form that never loses focus

  I have created a form with SetTopmost set, and shown it with dlg.ShowDialog(), but I really need it to keep the focus EVEN if the user clicks on another application. Has anyone got a bit of windows magic that means that my dialog box keeps the focus whatever happens, until I dismiss it in code (with dlg.Close() or whatever). I've tried catching the 'Deactivate' event and so on, but that doesn't seem to solve the problem. Thanks for any clues or thoughts..... Hi Mark, I wasn't sure if the end goal was to simply collect keystrokes but you could use the keyboard hooks API, but it can be resource hungry. Careful when you implement it to call CallNextHookEx and to UnhookWindowsHookEx. Th ...Show All

• SQL Server Error in mining accuracy chart

  I ran a decision tree, clustering and neural network mining model across a dataset of about 200,000 records. I am trying to evaluate the accuracy of each of my models but I can't view the results. I get the following error: Failed to execute the query due to the following error: XML for Analysis parser: The XML for Analysis request timed out before it was completed. Execution of the managed stored procedure GenerateLiftTableUsingDatasource failed with the following error: Exception has been thrown by the target of an invocation.Microsoft::AnalysisServices::AdomdServer::AdomdException. Please change the timeout for the execution of the stored procedure. In BI Developer Studio, under the Tools menu, select Options, Business In ...Show All

• SQL Server can I create a VIEW on the sesult of stored procedure ?

  I have a store procedure which select/calculate fields from multiple tables, can I create a VIEW on the sesult of the stored procedure     I want create a cube fact that is base on the result of a stored procedure, but the cube cannot accept SP as a source, so I want to create a view that can be the source of cube fact ...Show All