Query file names

<< Click to Display Table of Contents >>

Navigation:  FastReports > Report datasets >

Query file names

File name rules

By default, report datasets are named using their source query file name therefore file names must adhere to the following rules:

 

File names must start with a letter or underscore followed by other letters, numbers or underscore characters

No spaces or special characters are allowed

The file extension must be .sql (e.g. query_filename.sql).

 

When you start FastReports, Dispatch will display an error message for each file that it encounters that is named incorrectly.

 

clip0496

 

While we could eliminate these errors from within Dispatch by removing or replacing the offending characters, we decided that might only lead to confusion when trying to provide user-friendly names for queries.

Examples

These are examples of file names that are allowed:

 

MyTicketQuery.sql

_MyTicketQuery1.sql

 

These are examples of file names that are not allowed:

 

My Ticket Query.sql

My.Ticket.Query - Copy.sql

1 - My Ticket Query.sql

1MyTicketQuery.sql