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

Odd behavior when modifying select statement

fraussfrauss Posts: 2
edited October 22, 2007 10:14PM in SQL Prompt Previous Versions
When attempting to add a WHERE clause to the following statement:

SELECT * FROM delta_companies ORDER BY organization_id;

autocompletion works well in terms of suggested columns till I get to this point:

SELECT * FROM delta_companies WHERE submission_id_new = 222 AND ORDER BY organization_id;

When I start typing in the 2nd column for the AND the suggestions I get are not columns in the delta_companies table but instead are table/view names.

Any idea why this would be?

Fred Strauss


  • Options
    Thanks for your post.

    SQL Prompt will always try and get you to type fully qualified column names in a query. This is why the top suggestions are likely to be tables/views. If you select the table then you should next get prompted for the column name. Alternatively you could skip past the default suggested candidates list and go straight to the columns list by selecting the columns tab on the pop-up (ctrl+right-right).

    I hope this is helpful.
Sign In or Register to comment.