Repeat Signage V5 help

Repeat SQL selection

Help home

Repeat Signage digital signage software

Connecting to your database

The first thing you need to do is to set up a connection to your database.  For example, if this is a Microsoft Access .mdb file, then you start by telling Repeat Signage where it is, for example, 'c:\MyData\Information.mdb' and whether these is a password or not.  Same goes for CSV or XML files, or even Microsoft SQL databases or other database systems via ODBC.  Use the 'Add' button to do this and on the screen that appears then also look at the help these as well.

You database connections can be set up for individual presentations or you can add system ones that are accessible to all your presentations.  If you want to set them up centrally, then you can do this from main Repeat Signage screen by selecting 'Utilities' then 'Data connection manager' from the menu.

Once you have connected to your database, then you are ready to build an SQL statement.

SQL Statement and the SQL wizard

Don't panic if you don't know what an SQL statement is.  SQL is Structured Query Language and is a way of writing down which information from your database you want to display.  Advanced users, such as programmers, may just want to type some in the box.  The rest of us can use the 'SQL wizard' which will walk you through collecting information from your database.  Use the help pages on the wizard screen's tabs to get step by step help with this.

Test button

If you have written your own SQL statement rather than using the SQL wizard, then you can use this button to test your SQL statement to make sure it is returning the correct information.