Changes data in EntitySets, relationships, forms, or sets. Syntax UPDATE [ALL] [SQLsetspec] SET «field = value » [WHERE clause [EVALUATE clause] [-> clause] Parameters ALL Optional. Regardless of whether ALL is entered, all records in the set specification that meet the specified condition (if any) are updated. SQLsetspec An SQL set specification. Can contain application…
Read more
Adds a single record to EntitySets or relationships ( ISQL option only). Syntax INSERT INTO object [( field)] VALUES(expr1 | NULL) [EVALUATE clause] [clause] Parameters object The name of an EntitySet or relationship with fields to which you want to add a record. A role name can be used. field A target field in object.…
Read more
Lists selected data from the database. Syntax SELECT [ALL] [DISTINCT] values FROM SQLsetspec [-> setname] Parameters ALL An optional keyword indicating that all records of the specified type are to be listed. But, even if ALL is omitted, all records are processed by default. DISTINCT Specifies that only the records that contain unique values in…
Read more
WHERE States a condition. Syntax WHERE expression Parameters expression A logic expression using conditional and Boolean operators. Comments WHERE states the conditions that restrict processing in the main command to only certain members of the set specification, contingent on a value within each of the (related) records being considered. Of all the available (related) records…
Read more
Deletes records from EntitySets or relationships with fields. Syntax DELETE [ALL] FROM SQLsetspec [EVALUATE clause] [-> clause] Parameters ALL Optional. Whether or not you include the ALL argument, all records in SQLsetspec are deleted. SQLsetspec An SQL set specification. If omitted, records are deleted from the current set (if it exists). Comments DELETE FROM is…
Read more
Marks the end of a transaction, discarding the results. Syntax ROLLBACK WORK Comments The ROLLBACK WORK command is the SQL equivalent of the QUITTRANSACTION command. The value of the system variable $InTransaction indicates if an explicit transaction is in progress; the ROLLBACK WORK command sets $InTransaction to 0 ($False). See Also $InTransaction BEGIN WORK…
Read more
Starts an explicit transaction. Syntax BEGIN WORK Comments This command is the SQL equivalent of the TRANSACTION command. See Also $InTransaction COMMIT WORK ROLLBACK WORK TRANSACTION
Ends a transaction and writes all updates to the database. Syntax COMMIT WORK Comments This command is the SQL equivalent to the ENDTRANSACTION command. See Also $InTransaction BEGIN WORK ROLLBACK WORK TRANSACTION
English 
Portuguese