Ramin's Q&A profile
SQL Server Complex Query
Hello, I am having trouble in getting the expected results. I have two tables as below. I need Idno,transdt,cd,cycdt,amt from joining two tables. The criteria is that if the transdt greater than same month of cycdt then we need get the next month cycdt and corresponding amount for that, if it is less than or equal to same months cycdt then get the same months cycdt and amt. Cd is dummy field which can be anything. I am using sqlserver 8.0 table1 idno,trandt,cd 12345,04/15/2005,cd1 12345,04/15/2005,cd2 12345,04/22/2005,cd3 12345,07/03/2005,cd4 12345,09/10/2005,cd5 3421,03/05/2005,cd6 3421,05/06/2005,cd7 3421,07/04/2005,cd8 3421,07/15/2005, ...Show All
Visual Basic Reading meta information in VBS
Hi all, I have a little script to read the source from a website. URL = "www.google.de" IE.Navigate URL Wscript.Sleep 800 Set IEDoc = IE.Document HTMLText = IEDoc.body.innerHTML msgbox HTMLText But what I want is to read the whole <head> section. I need something like IEDoc.head..... but that doesn't work. Some ideas Thanks. ...Show All
Visual Studio Team System VSTS Architect vs. VSTS Developer
With he proposed changes in MSDN subscriptions and Visual Studio licensing, I now have to make a decision between VSTS Architect and VSTS Developer. As I understand, MSDN Universal subscribers will have a choice - they can either go for VSTS Architect and VSTS Developer. I believe that I need both architecture and development tools. Which out of two should I go for The information was interesting but too high-level to be really useful or answer the questions I feel most developers have. I hope you folks will be releasing something with a bit of meat on it like a feature by feature breakdown of what is included in each edition in t ...Show All
Software Development for Windows Vista wireless network problem
I have a bit of a dilemma on my hands. I have Vista installed on my Averatec laptop, and it is running great, nice and fast and all. I originally installed it as an upgrade to XP SP2, and everything worked great except for a few problems I was already having like the computer not wanting to turn itself off after shutting down, and my laptop fan not always running like it should. Vista said that my processor driver was not loading properly. Anyway, I redid the computer with a clean install of Vista, and that solved all the problems I was having. However, my question is that when I install Vista that way, it suddenly does not recognize my Mini ...Show All
Software Development for Windows Vista How to add mapped printer for a remotely connected user
How do I add a mapped printer for a remotely connected user. User is connecting through a remote desktop connection and he is not seeing his printer. How do I add that printer. does he have a printer installed when in the office just doesn't see it when remote try adding the /console switch to mstsc. If you added the printer and are expecting him to see, that won't work becuase they are per user. josh http://windowsconnected.com ...Show All
Visual Basic Visual Basic 6.0
I have created my own object [stocklist] using class module and hav also created another class module to be able to use my object more than once [stocklist(10)]. Now the problem is, i hav a display function to display the data entered so far, but it is all one string which i hav managed to seperate into different lines using the chr(13) keyword in my [stocklist] display function. I want to be able to format the data according to how i want. In other words, i want to be able to place specific property of the object into specific place as i desire when i want to display the data to the user, how do i do that The function i am using r ...Show All
Visual C# How can I do to use Windows API?
I have used some Windows API commands but I get error. //==================================== D:\C#_Temp\SystemApp\Form1.cs(166): The type or namespace name 'HANDLE' could not be found (are you missing a using directive or an assembly reference ) //==================================== HANDLE hToken; TOKEN_PRIVILEGES tkp; // Get a token for this process. if (!OpenProcessToken(GetCurrentProcess(), TOKEN_ADJUST_PRIVILEGES | TOKEN_QUERY , &hToken)) return( FALSE ); Please tell me how can I use them. Thanks in advance ! Check this page out. Sheva ...Show All
Visual Studio Team System Tools for drawing UML diagrams
Am I correct in thinking that Microsoft Office Visio is the tool that provides the UML diagramming facility for VSTS I've done a complete install of Microsoft Office Professionsl 2003 (prerequisit for VS Team Edition) and a full install of Team Suite, but Visio does seem to be present. When I apply File | New | File from Visual Studio's menu bar there isn't a UML diagram in sight. a. What have I done wrong b. How closely is Visio integrated into Visual Studio Will What are you trying to do with UML VSTS doesn't directly give you the ability to draw diagrams that exactly match to the official UML document types. ...Show All
Visual Studio 2008 (Pre-release) Displaying windows from browser app
Is it possible to open a new window from a browser app (using medium trust) Is it possible to open non-standalone windows or am I limited to using message boxes Thanks! ...Show All
Visual Studio Express Editions Treeview question #4
Hi Back again. This question is typed boolean :) I had problems when I click on the last node of a branch in treeview. This would invariably cause an 'Object reference not set to an instance of an object.' error. To solve this, I wrapped the offending code in an 'Try...Catch exception' = No more of those errors. Question: Is doing this a 'cop out' If answer = True then why I had tried a number of other 'traps' to avoid the offending code being executed, but all those attempts were trying to use aspects of the same variable(s) etc which also caused exceptions. Having your code in a try catch block is always a good idea ...Show All
Visual C# Incomplete code snippets for c#
Is there any way to get c# versions of all the vb snippets shiped with beta 1 I was hoping this would be addressed for beta two, but so far whidbey only contains a handfull of snippets. Use the demo edition of our Instant C# VB to C# converter to obtain the C# version of these snippets: www.instantcsharp.com David Anton www.tangiblesoftwaresolutions.com Instant C#: VB.NET to C# Converter Instant VB: C# to VB.NET Converter Instant C++: C# to C++ Converter Instant J#: VB.NET to J# Converter Clear VB: Cleans up VB.NET code ...Show All
Visual Basic Recursive Error
I receive the following error when trying to run a recursive function. It happens when the recursion has reached its lowest level and is starting back up the tree. Any help would be greatly appriciated. Error: 61837 - Unable to write read-only property. Code: Public Sub RemoveUserFromUserClasses( ByRef objUserClass As Object , ByRef objUser As Object ) On Error GoTo Err_RemoveUserFromUserClasses 'Counter Dim I As Long 'Hold the current User Class Dim objCurUserClass As Object 'Did Recursive Call Succeed Dim GoodCall As Boolean ' For each UserClass remove the ...Show All
Smart Device Development Can I have a web service hosting on the mobile devices?
Hi guys, I wonder if I can have a web service hosting on the mobile devices using .Net CF Cheers, Justin Hi Justin No, the .NET Compact Framework does not support this out of the box. But there is a sample on MSDN implementing a simple Web Server. Here is the link to the article: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnnetcomp/html/NETCFMA.asp Cheers, Michael ...Show All
.NET Development Garbage collector - destroying connected objects
Suppose you have a parent object that has a child object amongst its members. To support communication between the two objects, the child object also holds a reference to its parent. My question is, can we be sure that the garbage collector is able to destroy the parent object (and the child object) when it is no longer used (all references pointing to the parent going out of scope) I am only a simple VB programmer but I know this used to be a problem in COM with VB6 as the garbage collector was using reference counting back then. The parent object could not be destroyed because the child object still held a reference to i ...Show All
Visual C++ Linker PRJ0002 error
I am now getting the following error virtually every time I link (VC++ 2003): pwbGEClient : error PRJ0002 : error result returned from 'link.exe'. There are no LNK* errors or warnings. Furthermore, there appears to be no problem with the link itself - the executable it builds runs correctly and always has my latest changes. I used the build log to assemble a call to link.exe from the command line, and captured its process exit code. It is returning 6, and this causes the PRJ0002. What does 6 mean Unfortunately I don't. Upgrading would be a nontrivial exercise in o ...Show All