How can we help you today? How can we help you today?

* Tab bug

Hi I just found a small bug with the select * and tab inserting all the field names.

If i have the following SQL and I want to add all the columns from the Job_Employer table if I type je.* and press tab it adds all the columns from the three tables to my select again. But if I type je.* and move to a different line and then move back to the je.* and press tab it adds only the columns from the job_employer table.

select j.JobID,
j.startdate,
j.enddate,
jc.Name,
jc.Code
From dbo.Job J
LEFT JOIN dbo.Job_Chapter jc ON j.ChapterID = jc.ChapterID
LEFT JOIN dbo.Job_Employer je ON j.EmployerID = je.EmployerID

Thanks for looking into this.

--Edited to fixed sql bug.--
unionguy
0

Comments

2 comments

Sort by
  • Dave Mellors
    Thank you for taking the trouble to let us know about this.

    The details have been passed onto our developers and I am sure you will see this fixed in a future release.
    Dave Mellors
    0
  • bill.wehnert
    One thing I have noticed -is that I am not getting the table alias included with each of the fields. It did expand only the proper table where I had prefaced with cpia.* and hit tab, but only the first column got my alias.

    I'd like to see the alias carried through the entire expand.
    bill.wehnert
    0

Add comment

Please sign in to leave a comment.