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

Problem with qualifiers on joins

IanCIanC Posts: 6 New member
edited September 10, 2015 6:21AM in SQL Prompt
I'm experiencing the following issue with SQL Prompt failing to insert object qualifiers on joins - it was happening in v6 & is continuing to happen in 7:

The auto-complete drop-down for a join will show the suggested join conditions with qualifiers - e.g. 'A.Field1 = B.Field1'. However selecting the suggestion will copy it in to the query window without the qualifiers - e.g. 'Field1 = Field1'. Undoing then repeating the operation will result in the qualifiers being successfully copied, as will typing part of the qualifier before selecting the auto-complete.

Any ideas what's going on or if a fix can be issued?



Sign In or Register to comment.