I am trying to type this code:
DECLARE @CompanyID AS VARCHAR ( 30 )
SET @CompanyID = ‘majvil’
SELECT x. *
FROM AR_LIVE.dbo.company_xref AS x
WHERE x.cmp_id = @CompanyID
I start by typing “DECLARE” and nothing shows up in a drop-down
list, it should display “DECLARE” as an option as I start to type
the word “DECLARE” and when it does, I should be able to select it
and have code complete format it as all upper case (or the format I set up
somewhere in Toad). It does highlight “declare” blue as a reserved
word so it knows the word.
Then after I type “DECLARE @CompanyID” and enter a space, code
complete should at least pop up a list to select “AS” and format it
to the case of my choice.
Then when you type a space after the “AS”, a list of field types
should pop up.
Then when I type “VARCHAR(“ I get this… This makes no sense. Why
would I want a data type for the field length of a varchar?