Bluefish444 Create3D Bedienungsanleitung PDF herunterladen (Seite 87)

● Database

If you want to change the value of a key by reading from a database, then set this option.

Then choose from the list of database connections (you set these in Tools menu →

Database setup) . Every database connection returns a resultset according to its SQL

query. However, you can filter this resultset further by entering the appropriate criteria in

the filter~sort field. The filter parameter sets the condition the elements in the resultset

must meet (like the way WHERE works in an SQL query), the sort parameter sets the

way these elements are sorted (like ORDER BY in an SQL query. The filter and sort

parameters must be separated by a '~'. If there are more than one row in the resultset

that meets your filter and sort criteria, you can set the index number of the first row and

also the number of maximum rows to read. If you display a long list in separate pages,

this is the way to do it.

You can even set up the way the data read from the database is returned. E.g. If you

need filenames as flags like c:\flags\bitmaps\HUN.tga but the value you get from the

database is HUN, you can add the 'fixed' part of the filename in the format box like this:

c:\flags\bitmaps\<4>.tga (in this example, the 4

column of the data table contains the

value we need, in this case HUN). Another good example would be temperature values

for a weather forecast. The data read from the database are only numbers, but you can

add °C as a fixed element like this:

<1>°C

You can also change any of the criteria to filter and sort the result set in the playout application. In

case of complicated filter or sort parameters, this can be quite complicated. To make it as simple

as possible, you can tag the part of the filter/sort string you want to change by putting these

inside { }.

This way, the only thing you need to input in the playout application is the number you want to

replace this number (13). You do not need to enter the whole filter/sort string which maybe more

than an operator could handle.

1 2 ... 82 83 84 85 86 87 88 89 90 91 92 ... 124 125

Keine Kommentare

Bluefish444 Create3D Bedienungsanleitung Seite 87