Start a new topic

Auto Completion is not working in non-dbo schemas

[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

[This reply is migrated from our old forums.]

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
[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