Having problems with message search?
Thanks
Eric L Hackett
Ofc: 970.882.5510
From: toadss@yahoogroups.com [mailto:toadss@yahoogroups.com] On Behalf Of Henrik Johnson
Sent: Wednesday, November 19, 2008 2:09 PM
To: toadss@yahoogroups.com
Subject: RE: [toadss] Why does intellisense stop working?
The issue that you are describing is due to a caching problem we have fixed for the GA release so it should “just work” for the actual 4.1 release.
/Mauritz
From: toadss@yahoogroups.
Sent: den 14 november 2008 12:55
To: 'toadss@yahoogroups
Subject: RE: [toadss] Why does intellisense stop working?
I also have seen this behavior where functionality will temporarily return in a new window.
In addition I have found I can get the columns to come back for a while if I go back to the schema browser window and reconnect.
I've actually gotten to where I only use 4.0 when I am going to be writing sql heavy in User defined procedure and function calls, since it has parameter completion, which sometimes work. If I'm just going to be doing more standard sql (joins etc), I usually still opt for v3.2, since the column name completion seems to be more stable in that version.
Thanks
Eric L Hackett
Ofc: 970.882.5510
From: toadss@yahoogroups.
Sent: Friday, November 14, 2008 1:45 PM
To: toadss@yahoogroups.
Subject: RE: [toadss] Why does intellisense stop working?
Hello,
I periodically have the same problem they are describing in the latest version of Toad 4.1 too. However it is not all the time. It’s very strange because I can have the problem, but if I copy and paste the code into another window it will start working again. I also noticed that Intellisense doesn’t work at all inside system function calls. For example:
As shown works fine. But if I do a SUM on Amount:
I have just gotten to the point that I figured creating the code to make Intellisense work properly is very difficult. So if at the time I am using Toad it works, I am happy. If it doesn’t I just go on…it’s still better that SSMS.
Thanks,
Kent
From: toadss@yahoogroups.
Sent: Friday, November 14, 2008 2:17 PM
To: toadss@yahoogroups.
Subject: RE: [toadss] Why does intellisense stop working?
This is in the latest 4.1 build btw (After the latest SqlServer beta).
/Mauritz
From: toadss@yahoogroups.
Sent: den 14 november 2008 12:16
To: toadss@yahoogroups.
Subject: RE: [toadss] Why does intellisense stop working?
I replaced the table names so I could test this, but it works fine for me:
This is the SQL I have (It doesn’t work, but the important thing is that the table names exist).
SELECT AM.fcinvoice AS InvoiceNumber,
AM.finvdate AS InvoiceDate,
left(AI.fsokey, 6) AS SalesNumber,
AM.fpono AS CustomerPurchaseOrd
AM.
SL.fcustno AS CustomerNumber,
AM.fccompany AS CompanyName
FROM Person.Address SL
INNER JOIN
dbo.AWBuildVersion AM
ON AM.fcustno = SL.fcustno
INNER JOIN
Purchasing.VendorAd
ON AM.fcinvoice = AI.fcinvoice
WHERE SL.ftype = 'C' AND year(AM.finvdate) > 2007
/Mauritz
From: toadss@yahoogroups.
Sent: den 14 november 2008 08:27
To: toadss@yahoogroups.
Subject: Re: [toadss] Why does intellisense stop working?
I get the same thing... plus, Intellisense doesn't seem to work at all if you're inside a PROCEDURE.
>>> "made2mentor" <david.stein@
Here's my code:
SELECT AM.fcinvoice AS InvoiceNumber,
AM.finvdate AS InvoiceDate,
left(AI.fsokey, 6) AS SalesNumber,
AM.fpono AS CustomerPurchaseOrd
SL.fcustno AS CustomerNumber,
AM.fccompany AS CompanyName
FROM dbo.slcdpm SL
INNER JOIN
dbo.armast AM
ON AM.fcustno = SL.fcustno
INNER JOIN
dbo.aritem AI
ON AM.fcinvoice = AI.fcinvoice
WHERE SL.ftype = 'C' AND year(AM.finvdate) > 2007
Keep in mind that intellisense was working a minute ago. When I try
to add in something like:
AI.fprodcl
between AM.fpono and SL.fcustno all I get as options after I
type "AI." is stuff like @@CONNECTIONS, @@CPU_BUSY etc.
Why?
Online Now 
Send Email
