Technische Foren » Déjà Vu support »
SQL and blue underlined segments
Initiator des Themas: Adam Łobatiuk
Adam Łobatiuk
Adam Łobatiuk  Identity Verified
Polen
Local time: 12:57
Mitglied (2009)
Englisch > Polnisch
+ ...
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!
 
Endre Both
Endre Both  Identity Verified
Deutschland
Local time: 12:57
Englisch > Deutsch
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.
... See more
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 ▲ Collapse
 
Adam Łobatiuk
Adam Łobatiuk  Identity Verified
Polen
Local time: 12:57
Mitglied (2009)
Englisch > Polnisch
+ ...
THEMENSTARTER
@ Endre Jul 6, 2012

Thank you very much! That worked.
 


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

Moderatoren dieses Forums
Pavel Tsvetkov[Call to this topic]

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

SQL and blue underlined segments






Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »
Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

Buy now! »