Tolle's Q&A profile

• Visual Basic Compiler Problems even though code is sound.

  Hi, I'm having a strange problem with Visual Studio 2003 and I'm hoping someone can help. The problem is I'm getting compiler errors even though the code is fine. Here's an example.... This is code from a form I have... Public Class frmGasDiagram Dim udtGasDiagram As clsGasDiagram In some methods of the form I get errors saying the type udtGasDiagram cannot be used as it hasn't been defined, but it is. If I change the access modifier to public/private or whatever then the problem goes away and the program runs fine. Then after the application is closed and I'm back in the IDE the error appears again even though no ...Show All

• Visual C++ Moving child windows completely outside an MDI

  Does anyone know how to move a child window outside the bounds of the main MDI client window. Currently the default behaviour for an app wizard generated MDI application stops the cursor from moving past the edge of the MDI client window when dragging a child window. I would like the cursor to be able to continue to move past the edge of the MDI when a child is being dragged. Thanks for any help, Cheers Ron, I created a new window that was not related to the MDI in any way and this done the job - thanks for your help. Gary. ...Show All

• Visual Studio 2008 (Pre-release) Cannot use AND in the where clause

  For the code... Dim rawTables = From tables In dq.SystemObjects _ Where (Tables.Type = "U" And tables.Name <> "sysdiagrams") _ Select Name, Id ...the query I get is... exec sp_executesql N'SELECT [t0].[id], [t0].[name] FROM [sysobjects] AS [t0] WHERE ( (CASE WHEN [t0].[type] = @p0 THEN 1 ELSE 0 END)) & ( (CASE WHEN [t0].[name] <> @p1 THEN 1 ELSE 0 END)) ',N'@p0 nvarchar(1),@p1 nvarchar(11)',@p0=N'U',@p1=N'sysdiagrams' ...and the error message is... An expression of non-boolean type specified in a context where a condition is expected, near 'and'. The ...Show All

• SQL Server SQL Server 2005 Developer ed.

  I am trying to install 2005 on a new hard drive, running only Windows x64.  The processor is a AMD Athlon 64 3000+, 2.02GHz, with 1GB RAM. When I click on setup.exe, I receive the following error message: The image file c:\SQLDEV\setup.exe is valid, but for a machine type other than the current machine. I chose the developer's edition as recommended by MS when installing on 64 bit Windows.  Any idea what's wrong Yeah, the confusion for some is that the 32-bit version can run both on 32-bit machines and in the WoW for x64 machines. But the reverse is not true. The two 64-bit versions are intended o ...Show All

• SQL Server Matrix Column Trouble

  I am trying to add an ungrouped columns to the end of a matrix. in RS SP2 2000 For example how do I add the three columns in red to a matrix in a report Q1 Q2 Q3 Total Percentage Turn Over Ratio Budget Variance Sales 100.00 100.00 100.00 300.00 100% 1.23 4.22 Cost 100.00 100.00 100.00 300.00 100% 1.23 4.22 Expense 100.00 100.00 100.00 300.00 100% 1.23 4.22 I had an instance where I wanted a total and then an average of the data in a matrix, however I was not able to figure it out. I hope someone ans ...Show All

• Visual Basic Using sender as a case in Select Case Statement

  When my form loads it adds some handles (using AddHandler ) to a sub ( showStatus ). What this sub does is checks which control activated the sub (using sender.Equals ) and displays text in the status label ( status ) accordingly. For this I use an If...Then statement for each possibility. There are many possibilities and my code get cluttered. Is there a way to do the same thing with a Select...Case statement. I tried: Select Case sender Case tbOne : status.Text = "blahblahblahblahblahblah" End Select where: tbOne is a textbox, status is a StatusLabel It gives me an error though, saying " Operator '=' is ...Show All

• Visual Studio Debugger temporarily hangs before not loading the PDB for CppCodeProvider.dll

  I'm running XP Professional and VS 2005 Professional and I have a two project solution (one web project, one class library). When I hit F5 to start debugging, the IDE will intermittently "hang" with the following message in the status bar: "Loading symbols for c:\windows\assembly\......\CppCodeProvider.dll". After about 30 seconds the IDE responds and the debug session starts. Watching the Modules window (Ctrl-D, Ctrl-M) shows me that the IDE is trying to load symbols for CppCodeProvider.dll and reports "No symbols loaded" in the Symbol Status column. When the debug session finally starts the Symbol ...Show All

• SQL Server Reference variables with identical names but different scopes

  Hi, I have a script task that can "see" 2 variables with identical names. The only difference is that they are scoped differently. As far as I know my script task will use the most locally scoped variable by default. Is there any way to make it use the other one -Jamie   DarrenSQLIS wrote: Give people a chance, you only posted a few hours ago! Saying that from all we have learnt about the “precedence” behaviour of variables and scope, I certainly don’t think it can be done. Did you suggest a fully qualified syntax to access higher variables I’d quite like that, but not a big deal for me (yet). Yeah I know, sorry,&nb ...Show All

• Visual Studio Express Editions USING SQL 2000 with VB 2005 Express

  Does anyone know if you can connect and use SQL 2000 Server with VB Epress 2005 datasources tab wizard I use the datasources tab to try to connect but it keeps failing to connect. VB6 seems to connect fine using the data environment wizard. I can connect to the SQL 2000 database with code without any problems in VB Epress 2005. Hi Tommy, Express editions have design support for local data only (.mdf and .mdb files). The version/feature matrix is located here: http://lab.msdn.microsoft.com/vs2005/productinfo/productline/default.aspx hope that helps ...Show All

• Visual Studio Team System Rename VSTS Project

  I saw another thread where you could not rename a version control folder at the root level, but, have not seen anything about renaming a VSTS project that would also rename the top level directory...any cool command line utilities to do this...I don't want to rebuild my VSTS project... I'm not sure I follow. Let's say you have c:\myworkspace\TeamProject mapped to $/TeamProject. You might be able to rename c:\workspace\TeamProject on disk using Windows Explorer or some other filesystem utility, but all you'll do is confuse TFS. Our command-line tools will stop you from performing this rename. ...Show All

• Visual Basic Access2003- Multiple Parameter Search in a Form

  Hi Basically what I want to set up is a search for the user so that he can look for any information, and just has to tzpe it in the form. What I did until now: I have a form in Design view and make unbound textboxes. Then I create a query which looks inside of this text boxes to find me the specified information with look * & [] & *. My problem is that when I install more that one parameter search, the query doesnt show me every record anymore. That means I can not search for every record, and just those which are shown. I think that it has to do something with relationships but I am not sure. It would be very nice if you aswer my ...Show All

• SQL Server Two Instances (SQLEXPRESS and MSSQLSERVER)

  Hi there, I installed SQL Server Express few days ago but today I coudn't start the Management Studio. After reinstall the management studio, the problem stay. Then I uninstall SQL Server, but I still had acess to the configuration manager and I see that the instance SQLEXPRESS still runing, even with all unistalled (SQL Server, Management Studio, Framework 2.0, Visual Studio). Then I install again Sql Server, and it detected that the default Instance are already installaled. I continued the installation without type any name for the "new" instance, but then I finished with to Instances: MSSQLSERVER and SQLEXPRESS. The strange (for me) ...Show All

• Windows Search Technologies WDS and WSS

  Hello there My intranet site is Windows Sharepoint Services (WSS) which is running on MSDE (Sharepoint) not SQL Server. I have downloaded your adm file and added to group policy. In Group Policy under user config. In the search tab of Windows Desktop Search I have set the Primary intranet search location. I have set as follows: intranet, http://servername/_layouts/1033/searchresults.aspx k=$w when i actually search it finds a load of docs on network email as normal. but when i click on the new intranet tab it opens WSS in a search tab but never finds anything. What am i doing wro ...Show All

• Visual Studio Team System Migrations from 2003 to 2005

  Hi I have following scenario I have VS 2003 solution that was involved for some time already. I would like to migrate it to VS 2005 but it will surely take some time since I would like to do some code clean up and testing. But even though I don't have new features in schedule client one in a while calls me that we need to change something. Usually this changes need to be "now" and they don't take more then 3-4 hours. But due to this I am refraining from starting major migration. I just wanted to know if I can resolve this in some secure way. Secure means - that I can return to 2003 at any time with no problems and work ...Show All

• Visual C# Call Tree?

  Is there any way to display a solution's call tree in the IDE Thanks, Ray What are the latest plans for making this available with C# and VB I greatly appreciate this feature under C/C++ and I miss it while working in C#. ...Show All