<MvQUERY>

   Also See:   MvREVEALSTRUCTURE MvCLOSEVIEW MvDBCOMMAND MvOPENVIEW  

Report a language bug  |  Report a documentation error
Runs an SQL query that does not return any results, such as an create, update, delete, or insert.
Syntax 
<MvQUERY NAME = "string: {  expression } | literal"
         QUERY = "string: {  expression } | literal"
         FIELDS = "{ expression } | variable list">
  • Empty Tag

If NAME is omitted, the query applies to the primary database. This must be an xBase3 or MySQL data source.

SQL queries that return results are handled by first opening a view with <MvOPENVIEW>. A view is a collection of database records retrieved by a particular SQL query.

Attributes

  • NAME: Optional Database alias. When a database is opened with MvOPEN, it is referenced in all other database commands by the alias. If  omitted, the primary database is assumed. The database must be open.
  • QUERY: The query string used to access the records. For field variables used in the string, the question mark (e.g. ? ) can be used as a placeholder, for FIELDS.
  • FIELDS: Optional: A comma delimited list of field variables used in the QUERY string. For each ? found a field variable will be substituted in sequence.

Examples

This query updates a records in the Products table in the Merchant database.

Example:

<MvOPEN NAME = "Merchant" DATABASE = "mydatabasefile@localhost" TYPE = "mysql"
        USERNAME = "{ l.username }" PASSWORD = "{ l.password }">

<MvQUERY NAME = "Merchant"
         QUERY = "{ 'UPDATE Products SET name = ? WHERE id = ?' }"
         FIELDS = "l.name, l.product_id">

 

+ Add a note
User Annotations: MvQUERY