Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: EagleTempest
  • Order by date
  1. EagleTempest

    Compare two installations of Server 2003

    In a custom application we have, it impersonates a user to access network shares. For some reason on one server, this impersonated user no longer appears to have Full access anymore. Is there a tool that can compare either entire server setups or just local policies? Thanks.
  2. EagleTempest

    Tableadapter Query Configuration Wizard Too Smart

    The first statement evaluates toIf RegionID = NULL THEN display all records ELSE filter by Regionthe second statement evaluates toIf RegionID = NULL OR a value THEN filter by NULL or value
  3. EagleTempest

    Tableadapter Query Configuration Wizard Too Smart

    VS 2005 SP1 I want to haveWHERE (@RegionID IS NULL OR Region = @RegionID)but instead the wizard always changes it toWHERE (@RegionID IS NULL) OR (Region = @RegionID) which is not the same thing. Does anyone have any ideas how to stop the wizard from being too smart?
  4. EagleTempest

    Nested Case Statement

    I guess not.
  5. EagleTempest

    Nested Case Statement

    Won't SUBSTRING('',1,4) return an error being it's length is zero??
  6. EagleTempest

    Nested Case Statement

    You're right. I tried nowSELECT ProjectNumber, ClientName, ProjectDesc, SubjobDesc, Region, CASE WHEN LEN(ProjectManager) >0 THEN CASE ISNUMERIC(SUBSTRING(ProjectManager, 1, 4)) =1 THEN SUBSTRING(ProjectManager, 8, LEN(ProjectManager) - 7) ELSE ProjectManager END ELSE...
  7. EagleTempest

    Nested Case Statement

    You answered for me that it is possible to nest case statements. I couldn't find a definite answer. You code led me to this which worked:SELECT ProjectNumber, ClientName, ProjectDesc, SubjobDesc, Region, CASE LEN(ProjectManager) WHEN 0 THEN CASE ISNUMERIC(SUBSTRING(ProjectManager, 1...
  8. EagleTempest

    Nested Case Statement

    SQL Server 2000 I'm not sure if it's possible to have a nested case statement or if I should use a subquery instead. I have inconsistent data to deal with. Here's my logic statement:If LEN(ProjNumber) > 0 THEN IF ISNUMBER(SUBSTRING(ProjNumber,1,4) -1 THEN SUBSTRING(ProjNumber,8...
  9. EagleTempest

    Bracket comparison

    SQL Server 2000 and .Net 2.0 Is there a difference betweenWHERE (@RegionID IS NULL OR Region = @RegionID)andWHERE (@RegionID IS NULL) OR (Region = @RegionID) The first gives me the results I want. The Query Builder in VB 2005 tries to be too smart and changes the first one to the second one...
  10. EagleTempest

    Where IF logic

    Sorry for the confusion. The Query Builder shows a different version of the SQL statement than in the TableAdapter Query Configuration. Yes your code works. The Wizard was working against me. Thanks for all your help!!!
  11. EagleTempest

    Where IF logic

    I get what you are saying but I want the opposite of NULL, therefore all records. So: If the parameter is not passed, all records are displayed. I guess I should have said that in the first place. Sorry
  12. EagleTempest

    Where IF logic

    I'm thinking I need to better explain. This is what I'm trying to achieve logically.SELECT CREATION_DATE, ClientName, Manager, PrjNumber, ProjectName, Region, SubJobName FROM vPE_NewJNRPrjs IF @RegionID IS not NULL THEN WHERE Region = @RegionID
  13. EagleTempest

    Where IF logic

    SQL Server 2000 It's probably easier to explain my logic as I could be far off base in my coding attempt. I want to have a query statement that when is a parameter is not null then the Where statement comes into effect. IF Paramater is not null THEN Parameter = @Fieldname ELSE do use...
  14. EagleTempest

    Dataqgridview select white space in row

    Oops. I was using the CellContentClick method instead of CellClick.
  15. EagleTempest

    Treeview invisible icons

    It appears to be with this particular project. I created a new form it does the same thing. However in a test project it works properly.
  16. EagleTempest

    Treeview invisible icons

    VB 2005 & .Net 2 The icons in my treeview object display when that particular form is set as the project startup form. But this form is actually called from the main form. When I do this, there is a space displayed where the icons should be displayed but are not. I Refresh the treeview after...
  17. EagleTempest

    Add a reference through code

    VB 2005 and .Net 2 Instead of adding a COM reference through the Add Reference menu option in the VB IDE, can it be done in code?
  18. EagleTempest

    Inheritance flags don't seem to do anything

    It seems changing AND to + did the trickruleF = New FileSystemAccessRule(Account, Rights, InheritanceFlags.ObjectInherit + InheritanceFlags.ContainerInherit, PropagationFlags.None, AccessControlType.Allow)
  19. EagleTempest

    Inheritance flags don't seem to do anything

    VB 2005 & .Net 2 I'm trying to add a user group with Full Control applied to "This folder, subfolders, and file" but it seems to keep getting varied results. The Full Control permission consistently works but it's always applied to "This folder only". Any ideas? Private Sub...
  20. EagleTempest

    Run application as user

    That would be nice, except the search function is currently out of order.

Part and Inventory Search

Back
Top