What are the challenges you face when working across database platforms? Take the survey
Options

Tables don't appear after dbo.

EsioNEsioN Posts: 103
edited July 20, 2007 11:17AM in SQL Prompt Previous Versions
Hi.
Typing select * from dbo. the tables don't appear. I need to press ctrl+space to see the tables. Or type the two first letter of the table name, ex: select * from dbo.or -> orders

But typing select * from dbo.. (two .) they appear.

Thanks

Ésio

Comments

  • Options
    Bart ReadBart Read Posts: 997 Silver 1
    Hi Esio,


    Hmm, that's quite odd. We haven't been able to reproduce this but we'll continue to keep an eye on it. It's unlikely that any fix will make it into the 3.5 final release for reasons I outlined in my earlier post, but if we are able to reproduce it we'll get a fix into 3.6.


    Thanks,
    Bart
    Bart Read
    Principal Consultant
    bartread.com Ltd
  • Options
    Bart ReadBart Read Posts: 997 Silver 1
    Just to be absolutely clear: you mean that the popup doesn't appear after the '.' rather than that it doesn't contain the expected objects, e.g. tables, when it does appear (even if forced)?
    Thanks,
    Bart
    Bart Read
    Principal Consultant
    bartread.com Ltd
  • Options
    select * from dbo. <popup doesn't appear>
    select * from dbo.A <popup doen't apper>
    select * from dbo.AC <popup appears with my tables/views starting with AC. With the popup showed , ff I delete de AC, the popup show all objects>
    select * from dbo.. <popup appears normaly, but note I typed two ".">
    select * from dbo. <pressing ctrl+space, popup appears>

    Thanks

    Ésio
  • Options
    Bart ReadBart Read Posts: 997 Silver 1
    OK thanks Esio, we'll take a look into it. That's pretty strange and at the moment I've no idea why it might be happening.
    Cheers,
    Bart
    Bart Read
    Principal Consultant
    bartread.com Ltd
Sign In or Register to comment.