Professional Web Applications Themes

A very strange problem - Microsoft SQL / MS SQL Server

If I right click on my table then go to ' Query ' and type: SELECT * FROM myTable WHERE id > 1 I'll get all the rows from table for id greather than 1 If I don't user where clause like: SELECT * FROM myTable , some of my recently added records are not queried. Can somebody explain me why this might be happening. Thank you -- Dino Buljubasic Software Developer http://rivusglobal.com...

  1. #1

    Default A very strange problem

    If I right click on my table then go to ' Query ' and type:

    SELECT *
    FROM myTable
    WHERE id > 1

    I'll get all the rows from table for id greather than 1

    If I don't user where clause like:

    SELECT *
    FROM myTable

    , some of my recently added records are not queried.

    Can somebody explain me why this might be happening.

    Thank you

    --
    Dino Buljubasic
    Software Developer
    http://rivusglobal.com



    Dino Guest

  2. #2

    Default Re: A very strange problem

    It is hard to see what is going on if there is no repro script is posted. In
    any case, this is not expected since a direct simple query with a WHERE
    clause should always give you a subset of the resultset the one without a
    WHERE clause produces. BTW, which interface are you using? Is it EM or QA?
    Or is this an Access interface which is linked to SQL Server?

    --
    - Anith
    ( Please reply to newsgroups only )


    Anith Guest

  3. #3

    Default Re: A very strange problem

    I am using EM

    "Anith Sen" <com> wrote in message
    news:e9QtS%phx.gbl... 
    In 


    Dino Guest

  4. #4

    Default Re: A very strange problem

    thanks for your help. I created a new database and it seams to be working
    fine now. I think our db was corrupted.

    I had one question regarding date settings on a computer. I'd like my
    application to work properly and understands dates correctly no matter what
    date setting is client's machine using.

    Is there any way to do that because I don't want to go to each client and
    set their machines' date settings before installing the application

    Any help will be appreciated

    --
    Dino Buljubasic
    Software Developer
    http://rivusglobal.com


    "Aaron Bertrand - MVP" <com> wrote in message
    news:phx.gbl... 
    >
    > Don't query data this way. Use Query yzer. There are some odd quirks
    > with the GUI tools in Enterprise Manager that you can neither explain nor
    > solve...
    >
    >[/ref]


    Dino Guest

  5. #5

    Default Re: A very strange problem

    Just make sure you use YYYYMMDD format...


    "Dino M. Buljubasic" <com> wrote in message
    news:uGXRa.2080$telusplanet.net... 
    what 


    Aaron Guest

  6. #6

    Default Re: A very strange problem

    $telusplanet.net... 

    I strongly recommend using

    txtYear.text & right("0" & txtMonth.txt, 2) & right("0" & txtDay.text)

    That way, no confusion when "changing settings for date" ...


    Aaron Guest

Similar Threads

  1. Strange problem on IE6
    By jrstudios in forum Macromedia Flash Player
    Replies: 1
    Last Post: September 29th, 11:07 AM
  2. [PHP] strange new problem with IE
    By Jay Blanchard in forum PHP Development
    Replies: 2
    Last Post: September 11th, 01:41 PM
  3. strange new problem with IE
    By Sam Folk-Williams in forum PHP Development
    Replies: 0
    Last Post: September 11th, 11:00 AM
  4. [PHP] Strange Problem
    By Philip Olson in forum PHP Development
    Replies: 0
    Last Post: July 14th, 03:42 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139