WriteV statement [Revelation On-Line Wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
====== WriteV statement   ======


 
==== Description ====
 
Updates the data content of a specified column in a row in a table.
 
==== Syntax ====
 
**WriteV** //expression// on %%|%% to //filevar//, //key//, //column// then  else statements
 
==== Parameters ====
 
The WriteV statement has the following parameters.

^Parameter^Description^
|//Expression//|Evaluates to the column contents that are to be written to the table.|
|//Filevar//|Refers to a file variable that has been opened in a previous Open statement. The WriteV statement does not support file access using cursors.|
|//Key//|Specifies the key of the row to be written.|
|//Column//|The number of the column that is to be updated. The value of //column// must be greater than zero.|
|Then|The statement(s) following Then are executed if the column is written successfully.|
|Else|The statement(s) following Else are executed if the column cannot be written. The Status() function indicates the severity of the error, and the system variable @FILE_ERROR contains detail about the nature of the error.\\ ||

 
==== See Also ====
 
[[matread|MatRead]], [[matwrite|MatWrite]], [[open|Open]], [[read|Read]], [[readv|ReadV]], [[write|Write]]
 
==== Example ====
 
<code>
/* The program reads column 5 from the CUSTOMER record 100, and assigns a value to row. The new record variable is then written to column 5. */

open "CUSTOMER" To CUSTOMER_TABLE then
  @ID = 100
  readV column From CUSTOMER_TABLE, @ID, 5 then
    * make no presumptions about the case

    FIRST_CHARACTER = column[1,1]

    Convert @LOWER_CASE To @UPPER_CASE In FIRST_CHARACTER

    Convert @UPPER_CASE To @LOWER_CASE In column

    column[1,1] = FIRST_CHARACTER
    writeV column On CUSTOMER_TABLE, @ID, 5 else
      status = Set_FSError()
    end
  end
end
</code>