Re: Table alias does not exist but works

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Miroo_news (miroo_at_USUNTO.poczta.fm)
Date: 05/20/04

  • Next message: Miroo_news: "How to create rule under condition?" 
    Date: Thu, 20 May 2004 10:18:23 +0200

    Uzytkownik "Hugo Kornelis" <hugo@pe_NO_rFact.in_SPAM_fo> napisal w
    wiadomosci news:4bmna05mcedtc6djok3t918ku0srbamk3g@4ax.com...
    > I checked again, but I still get the error message. Did you copy and paste
    > the query from Query Analyzer into the usenet message? Small typos can
    > cause huge differences...

    I'm pretty sure because I've copied query from message to QAnalyzer :)
    Are YOU sure?

    Maybe there are differences in SQLServer configuration?
    My config is rather default...

    > If you're sure you didn't typo when entering the query in your message,
    > you've obviously found a bug. You might want to report it to Microsoft.

    How to do it? What can I win? :)
    I've already found a serious bug once but it turned out
    that it had been fixed in SP3

    Regards,
    Miroo

  • Next message: Miroo_news: "How to create rule under condition?"

    Relevant Pages

    • Re: IS NULL not working in WHERE clause.
      ... At this point it's pretty hard to say whether it's a bug or corruption. ... And just to be certain - you said the query operators each select ... in the query plan that checks time_id for null, ... >This execution plan shows a single execution string. ...
      (microsoft.public.sqlserver.programming)
    • Re: union all
      ... It certainly seems like a bug to me if 8 million rows vanish when you ... Provide the CREATE TABLE statements for CLAIMFL, CHKREG, CLIENT, ... script below (with your query inserted) in Query Analyzer and posting ... >union all ...
      (microsoft.public.sqlserver.programming)
    • Re: A bug in MS Access
      ... I tried using exactly what you described, and received an error message that ... the delete query was invalid because it required a parameter. ... I do not believe you have a valid bug here. ... > I created a table ADDRESSDETAILS with following Columns ...
      (microsoft.public.access.modulesdaovba)
    • Re: changed queries save automatically
      ... Not exactly a "tiny" bug is it? ... A query not prompting you about saving it is one of the symptoms of this ... macro or code someone has Set Warnings to Off but forgot to Set ... Compacting and repairing closes the database and reopens it. ...
      (microsoft.public.access.queries)
    • Re: A bug in MS Access
      ... I still feel it as a bug. ... In the delete query condtion, ... > for invalid column and the if I am inputing value all columns got deleted. ... > thought this is a bug and searched for the stage to report this.Atlast, ...
      (microsoft.public.access.modulesdaovba)