| **Navigation:**  [[introduction.htm|Language Reference]] > 13 - Built-in Functions >====== SEND (send message to file driver) ====== | [[selected  return control that has received focus .htm|{{btn_prev_n.gif|Previous page}}]][[introduction.htm|{{btn_home_n.gif|Return to chapter overview}}]][[set  initiate sequential file processing .htm|{{btn_next_n.gif|Next page}}]] |
|  ||

**SEND(**//file//,//message//**)**

{{blk2blue.jpg|blk2blue.jpg}}

| **SEND** | Sends a message to the file driver. |
| //file// | The label of a FILE declaration. The FILE's DRIVER attribute identifies the file driver to receive the //message//. |
| //message// | A string constant or variable containing the information to supply to the file driver. |

The **SEND** procedure allows the program to pass any driver-specific information to a file driver during program execution. Valid //messages// are dependent upon the file driver in use. Documentation of all valid SEND //messages// for a given file driver are listed in the file driver's documentation.

**Return Data Type:     **STRING

**Example:**

**FileCheck = ****SEND****(ClarionFile,'RECOVER=120') !Arm recovery process for a Clarion data file**

You can also use the Clarion SEND procedure to send an SQL command to a backend database. This is provided for backward compatibility with early versions of Clarion. We recommend using [[prop sql 2.htm|property syntax]] to send SQL statements to the backend database.

**SEND****(SQLFile,'SELECT field1,field2 FROM table1'     |**

**       & 'WHERE field1 > (SELECT max(field1)'       |**

**       & 'FROM table2')        ! Returns a result set you **

**                               ! get one row at a time**

**                               ! using NEXT(SQLFile)**

**SEND****(SQLFile,'CALL GetRowsBetween(2,8)')            !Call stored procedure**

**SEND****(SQLFile,'CREATE INDEX ON table1(field1 DESC)') !No result set**