Hi Jess,

OK, now it's making a little more sense. It would be great to be able to give properties of objects typing as well and for them to pop up intellisense. I've no idea if this is implemented in VFP7 or whether it's doable using the extensible intellisense engine - I've yet to play with it, but that'd be useful IMHO.

Cheers,

Andrew

>Folks,
>
>Nope. Intellisense @ runtime is obviously useless I think. I expect intellisense to work just like in VB. I want to use a single connection in the entire form or project for that matter. General declarations in VB makes every single variable (private or public) available in the entire form or project with intellisense poping up.
>
>What I am doing in VFP is that I was forced to create an object to handle the ado object making it handy:
>
>

>init of the form:
>This.oConn = CREATEOBJECT("ADODB.CONNECTION")
>This.oConn.Open("ADODB.CONNECTION")
>This.oConn.CursorLocation = 2
>

>and somewhere in the click event of a button or somewhere else:
>

>oRS = Thisform.oConn.Execute("SELECT blah...blah")
>IF !oRS.EOF()
>   oRS.MoveFirst
>   DO WHILE !oRS.EOF()
>       blah...blah...
>   ENDDO
>ENDIF
>

>and it works fine but without intellisense available.
>Typing This.oConn. should have intellisense anywhere in the form not only ADO but other activex.
>
>That make sense to me but I expect others may disagree.
>
>>Intellisense does not work in Runtime. If you think about it, it makes sense. How many end users are writing code?
>>
>>
>>>Craig,
>>>
>>>What am I missing here??
>>>
>>>In the INIT method of the form,
>>>

>>>LOCAL oObj AS ADODB.CONNECTION
>>>oObj.OPEN("bbfsdsn","sa","")
>>>oObj.CursorLocation = 2
>>>

>>>This one does not work at runtime although intellisense popups during development time and within init only. Meaning, oObj. has no more intellisense popup in other methods.
>>>

>>>oObj = CREATEOBJECT("ADODB.CONNECTION")
>>>oObj.OPEN("bbfsdsn","sa","")
>>>oObj.CursorLocation = 2
>>>

>>>This one works, but no intellisense available in any method.
>>>
>>>Please educate me.