uses the operator OR to combine different status. That
is, if a sentence is Exact (1) and Locked (512),
its status is 513. To calculate a combined status, use Windows
Calculator in its Scientific view (there is an OR operator)
Type +(or) Row Status will give you the basic Row Status
Populated - Using Polpulate Current Language. When populating
only one or a group of sentences using F5 does not change cells
UPDATE Pairs SET Status_#### = Status_#### 2 + 4096 WHERE
((Status_#### \ 2) MOD 2) = 1 AND ((Status_#### \ 512) MOD 2)
Where #### is your language code.
How to change row status without
SQL? Duncan Bell
This is just a tip in case you need to change row status values,
anything else global, in a project's segments, and can't do it
(in my case because I haven't learnt it :).
Simply export the project to Word/RTF in an External View, including
row status info and, (essential, this!), segment IDs.
Then, find the row status values you
want to change and search and
replace them with the required values. You can delete them by
them with "nothing" in the Replace text box (where "nothing" really
nothing at all, i.e. you don't type anything).
The safest way to do this, especially
in a document that might contain
values that match a row status value, is to select the Status
Word. When it is highlighted, the Word Search and Replace dialog
says "Search Down", and only replaces the texts selected
in that column.
Or you could replace one at a time, clicking OK when you are
If you're not sure of the value of your existing row status,
but need to
know that, to change it, change the first segment of the project
new row status, in DVX, before the export to External View. Then
will see the row status value number in the Status column cell
segment, in Word.
To find out what value to change your existing row status value
change the second segment of the project to that new row status,
before the export to External View. Then you will see the row
value number in the Status column cell for that segment, in Word.
At the end, save your document, and
reimport it into Word in the usual
way to update your project.
DVX allows you to build your TDB using different templates. It
seems that the AttrTypeID (used in the commands below) varies according
to the choosen template. To see the IDs of your TDB, open
your TDB (file extension .dvtdb) in MS-Access, then open the table
AttrTypes. In my case, this is what I have:
ID 5 is subject; ID 6 is client; IDs 8 and 9 are customized fields;