Jet Reports Homepage |  Community Forum |  Downloads |  Submit A Ticket |  Jet Express Support
Feedback

SQL Views


Overview

If you are using SQL Views, it is possible to access these views as if they are standard tables in your database.

You must keep in mind, however, that views do not contain a primary key so you must treat them as such. The best way to see how to do this is to drag and drop a field from the desired view in the Jet Browser. You will notice that the Field argument populates with an array of Field names, since the table does not contain a primary key. See the example below.


When an NL Function has an array in the Field parameter, it returns a value called a Field Cache into the cell. This is a text value that identifies all the field values and their data types. If you use the NF function with the cell address containing a Field Cache as the first argument and one of the field names contained in it as the second argument, the NF function will return the value of the field. Please see the section entitled Introducing the NF Function for more details.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments