SQL is an abbreviation for Structured Query Language – this is a language specially created to interrogate databases. As its name suggests, SQL is very structured and you must be familiar with writing an SQL statement if you want to use the Database functions in OpusScript. The ExecuteSQL function requires an SQL statement in order to create a Record Set that will be used by the other Database functions. The main elements of an SQL statements are quite straight-forward: SELECT – is used to select the fields you want to view in a Table. FROM – is used to name the Table to be used. WHERE – is used to set the search criteria i.e. which records you want to use. |