SQL and blue underlined segments
Thread poster: Adam Łobatiuk

Adam Łobatiuk  Identity Verified
Poland
Local time: 23:30
Member (2009)
English to Polish
+ ...
Jul 6, 2012

I'm no expert at SQL and only use very simple statements in the translation table for my QA purposes. I have noticed that blue underlined segments are often included in filtered views where they shouldn't. For example, when I want to check for missing final periods/full stops like this:


source like '*.' and target_1045 not like '*.'

... blue underlined segments that end in a period/full stop are included anyway. Am I doing something wrong? Thanks in advance!


Direct link Reply with quote
 

Endre Both  Identity Verified
Germany
Local time: 23:30
Member (2002)
English to German
Accept multiple matches before doing your checks Jul 6, 2012

You're not doing anything wrong. However, blue underlined segments are "multiple matches" (if you right-click on them, you get other alternatives than the currently displayed one). Those alternatives are included in the text of the segment in the project database (which you apply your SQL filters on), so you may get unexpected results depending on the content of those alternatives. You can take a look into one of those segments in MS Access to see how that looks like if you are interested.

Endre


Direct link Reply with quote
 

Adam Łobatiuk  Identity Verified
Poland
Local time: 23:30
Member (2009)
English to Polish
+ ...
TOPIC STARTER
@ Endre Jul 6, 2012

Thank you very much! That worked.

Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:

Moderator(s) of this forum
Pavel Tsvetkov[Call to this topic]

You can also contact site staff by submitting a support request »

SQL and blue underlined segments

Advanced search






PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »
WordFinder Unlimited
For clarity and excellence

WordFinder is the leading dictionary service that gives you the words you want anywhere, anytime. Access 260+ dictionaries from the world's leading dictionary publishers in virtually any device. Find the right word anywhere, anytime - online or offline.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search