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. The original author name has been removed]

Re: Auto Completion is not working in non-dbo schemas
Hans No. But account +fda_etma_prd+ has +select+ privileges on many tables and thats the account we use to build queries in that particular server....
[This reply is migrated from our old forums.]

Re: Auto Completion is not working in non-dbo schemas
Hi Alex, Thanks. Does the FDA_PRD_NY database contain any tables or views owned by the fda_etma_prd schema? I'm asking since you say that it works when you set the Schema drop down list (?) to dbo. The value in the Schema list limits the auto completion to only look for tables/views in the specified schema. Best Regards, Hans