[This topic is migrated from our old forums. The original author name has been removed] [Attachment has been removed.]
Connected to a Sybase db.. Schema is a non-dbo (see attached pic)
select *
from
and hit Ctrl+Space
Nothing comes up, debug output below. Manually changing Schema to "dbo" solves the issue....
08:42:45 [DEBUG ExecutorRunner-pool-2-thread-134 N.?] DbConnection='SYBAMR_FDA_PRD_DS01 PROD (PRIMARY fda_etma_prd)' Catalog='FDA_PRD_NY' Schema='fda_etma_prd' Table='null' Type(s)='null'
08:42:45 [DEBUG pool-3-thread-234 E.?] RootConnection: SybDatabaseMetaData.getTables("FDA_PRD_NY", "fda_etma_prd", "%", null)
Product: DbVisualizer Pro 9.1.3
Build: #2091 (2013/11/22 16:43)
Java VM: Java HotSpot(TM) Client VM
Java Version: 1.6.0_51
Java Vendor: Sun Microsystems Inc.
OS Name: Windows 7
OS Arch: x86
OS Version: 6.1
Re: Auto Completion is not working in non-dbo schemas
Hi Alex,
Sorry, it seems like this has slipped between the cracks. I can't remember why I said it would happen soon back in 2013 but I will have a look at it again and see if we encountered some issues when we looked at it the last time.
Best Regards,
Hans
Hans Bergsten
said
over 9 years ago
[This reply is migrated from our old forums.]
Re: Auto Completion is not working in non-dbo schemas
Hi Alex,
In the just release 9.2.7 you can initialize Database/Schema to Connection Default, None or Most Recent:
http://confluence.dbvis.com/display/UG92/Selecting+Database+Connection%2C+Catalog+and+Schema
Use Help->Check for Update to upgrade or download manually from:
http://www.dbvis.com/download/
Best Regards,
Hans
anonymous
[Attachment has been removed.]