WHERE clause inactive

RalfWestphal

I often have the problem that the link which opens the editor for the WHERE clause is inactive. Is this a known issue?

Eddie D

Hi, thank you for your forum post.

What version of SQL Data Compare are you using?

When the WHERE clause is inactive, is it grey out or in a blue colour available for use?

The data sources that you are comparing, are you comparing two live databases or a scripts folder to a database or a backup file to a database?

Many Thanks
Eddie

RalfWestphal

Hello Eddie,
thank you for your reply. I run 14.3.3.16559 Professional.
The WHERE clause is grey and can't be clicked.
I compare 2 live databases.
Today I already made a lot of comparisons and the issue did not appear. I work on the same databases, and I can't say what is different compared to yesterday when I was not able to select the WHERE clause.
Thank you!

HTC_user_123

Hi .. I have the same issue .. using SQL Data Compare, I need to cop a very large SQL table from one SQL svr to another.. but the [where clause] is greyed out?

Dar

What's Up?.....Same issue in version 14.7.8.21163 Professional. Although it seems to come and go!  Dar -DA