I am running this against an Altiris database. At this time, both my organization, Office of Information Technology and the Office of Public Defenders are on a shared setup of servers. Often I need to filter out their products from my own. To that end, I added:
Where Name not like ‘OPD%’ which then gives me only my OIT results. This was in the text file I attached to previous email. I’ll attach again
I do not see that I can add a where statement in the diagram so this makes no sense to me. Why can’t I just save the query as I have constructed it? This was not a problem in my older TOAD 2.5 and it seems this feature has caused others the same issue.
From: Aleksey Bazhenov [mailto:bounce-AlekseyBazhenov@toadworld.com]
Sent: Tuesday, September 1, 2015 1:47 PM
Subject: RE: [Toad Data Point - Beta Discussion Forum] Problem with latest update - referential update is ruining my queries
RE: Problem with latest update - referential update is ruining my queries
Reply by Aleksey Bazhenov
The diagram and the query have to be in sync when QB file is saved.
If you changed a query then the changes have to be propagated back to the diagram and the Visualize does this. Otherwise we’ll have two different queries (one from diagram and another from editor). How could we know which one to use when we open the file? This is particular important when the file is opened on a different PC with different set of connections.
Sometimes we cannot parse all changes in the query (even when the query is correct) and we bring up a warning so you have to fix it. In the most case it happens when column list is changed. But in any case the diagram and the query have to be synchronized before saving the file.
So I suggest to edit a query through the diagram. If you’d like to make manual editing then you should use SQL Editor and save the query as a text file.
What did you changes in the query with the date format? I don’t see your attachment with the query.
Could you post a screenshot with the changes?
It looks like you have the same warning about Visualizing with TDP 3.7 but do not get these exceptions. Is it correct?
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad Data Point - Beta notifications altogether.
Toad Data Point - Beta Discussion Forum
this post as spam/abuse.