Bluefish444 Create3D Manual do Utilizador descarregar pdf (Página 103)

If all parameters are set correctly, click on Build to build the connection string, or type it in if you

can't get it built. If you click on Test next to the Build button, you can check if the connection is

working. If the button lights up red, the connection is OK. If you do not have a connection it may

happen that the application freezes for 10-15 seconds until a timeout is received indicating that

connection could not be established.

If you successfully built the connection to the database you can even test an SQL query. Type in

the SQL command then click on the Test button next to it. The result – if there is one – will appear

in the window marked Result.

You can mark certain elements in your SQL query with {} like this:

SELECT * FROM Table1 WHERE Bib>{10} AND Age>{20} ORDER BY Age

The {} will be removed when the query gets executed, but it is very useful if you only need to

change these elements in NemoPlay to influence the result returned from the database. This way

you do not need to type in full SQL queries in NemoPlay, you only need to change the numbers

marked with {}.

If you are satisfied with everything, you can save the connection by clicking on the “+” button.

Nemo will name the connection automatically, but if you click in the drop down list, you can

rename it to anything you like.

Connections no longer needed can be deleted by clicking on the “-” button.

Query type:

In some cases the result of the query can return another SQL string Nemo has to execute to get

the resultset you really want. In this case, choose Indirect as the type of your query.

Query interval:

It is possible that data stored will change after the Page it is part of gets animated on screen. In

this case, you can query the database at regular intervals and data will be updated accordingly

until the Page is cleared from the screen. If this value is 0, the database will be queried once,

before playback starts. For safety reasons (your connection to the database might not be that

fast), do not enter an interval time less than 0.5 seconds.

103

1 2 ... 98 99 100 101 102 103 104 105 106 107 108 ... 124 125

Sem comentários

Bluefish444 Create3D Manual do Utilizador Página 103