|
From: Christian S. <chr...@ne...> - 2002-10-19 13:04:10
|
> It would be nice just to see tables that start with the characters they > typed prior to calling for completion. I am personally not in favor of that (which does not preclude implementing it, of course). Calling for completion is just one hit on the keyboard, and having the IDE intervening with your typing can get rather annoying. All the IDEs with code completion that I know (IDEA, NetBeans) do it the way we have it now. I'll take note of the request anyway. > Also is there any way to get > schema/catalog info (possibly with a different cmd key) completion? > > An example SQL > > select * from othercatalog.table1, myTable where ... > > Here we are joining from a table in the current catalog (myTable) to one > in a different catalog (table). Would it be possible to key in 'oth' > CtrlSpace and have the catalog names pop up? The main difficulty I see is that the parser will not be able to tell that you are typing a schema/catalog name (the generic name pattern is <catalog>.<schema>.<name>) until you have completed typing the dot. To distinguish a catalog name from a schema name, there would have to be two dots. What could be done is search through all three (catalog, schema, name) and offer matches from all three together before the first dot, from schema and tables after the first dot, and only tables after the second dot. Of course it would be nice to visually distinguish the different name elements in the completion list. Now - who will program that? >>The completion itself needs to be tested. It can also be made yet more >>intelligent. DDL statements are not supported (but what would you want >>to complete there?). > > > Possibly foreign key relationships? hmm. You mean if I write "foreign key (bla, bla) references ", I would get a list of all tables that have matching primary keys? |
