When you create a new script and declare a variable, the intellesense menu that appears when typing the datatype is wrong.

When I typed, "DECLARE @ProductID i" the i triggered an intellesense menu with "inner join" and "insert into" to appear instead of "int".

-A

---

Aaron Akin
Database Administrator
Insala, LLC
AIM: AaronInsala

Thanks Aaron,

We've been playing around with including intellisense for various T-SQL keywords.  In your case typing the letter "i" triggered the intellisense for "inner join" and "insert into".  This however shouldn't have prevented you from typing out "int" if that was your intention.

We could do a couple of things here, either add all the datatypes into intellisense so in this case "int" would be a third item in the intellisense list or when you're typing "i" (for example) backtrack a little bit and use some intelligence to determine whether "inner join" and/or "insert into" fit into the context of the statement you're writing.  The latter is obviously a bit trickier to achieve.

For now I'm inclined to say that we include datatypes into the intellisense but let me know if you think this is sufficient.

Regards,

---

SQLDBcontrol Support

support@sqldbcontrol.com

I think that would probably be sufficient for now, but I think it would make more sense to only show datatypes in this case.

-A

---

Aaron Akin
Database Administrator
Insala, LLC
AIM: AaronInsala

As is often the case, the trickier solution didn't turn out to be as tricky as I expected.

So whenever you press space after declaring a variable you now get a list of datatypes to select from, which overrides the "inner join" and "insert into" intellisense.

This will be available in the next build (1.4.24).

Regards,

---

SQLDBcontrol Support

support@sqldbcontrol.com