Repeat Signage V5 help

SQL Wizard - Data preview tab to select single record

Help home

Repeat Signage digital signage software

This screen shows you the records from the database table you selected in the last step.  If it is a large table full of data, then this may take a little while to load.

With the Text Label control we are looking with the  to display a single piece of text, you need to narrow down your records so that there is a single record/row in the grid.

A data preview and filtering example

Here's an example.  We have a Microsoft Access database and table for 'Countries' was selected in the last step and the records are now displayed in the grid below: 

Data preview and filtering example

We may want to display the Official Name for Australia in our Text Label control.  So what we need to do is to filter the grid so that only 'Australia' is displayed.  Now in the above grid, there is a Countries.Id field which has a unique number for each country.  Many database tables have a unique field, and you need find this if possible.  The unique ID for Australia is 12.  So what we need to do is to click on the little funnel symbol next to the Countries.Id column/field:

Countries example

to display the filtering box:

Filtering box

which will show you all the different values in the current column/field.  My taking the tick away from the 'All' tick box, scrolling down and selecting 12 (the ID of the record for Australia):

Clear filter box

we can then click on the 'OK' button to apply the filter which would give us just the Australian record in the grid:

Select data from database screen

We would then be ready to click the 'Next' button to move to the next tab, where we can specify the column/field to display data from.

If you don't have a key field, then you need to use another field that is unique to the record you want to display.  We could have used the 'Country' field/column and filtered on:

Repeat Signage filter box screen

and just selected 'Australia' from the list instead, to do exactly the same thing.

SQL statement

You will notice that the SQL statement that will be used to retrieve the information from your database in gradually being build up for you:

SELECT * FROM [FullCountries] WHERE ([Countries.Id] = 12) ORDER BY [Code2]

You don't need to understand SQL to use this wizard.