User Tools

Site Tools


send_send_message_to_file_driver_.htm
Navigation:  Language Reference > 13 - Built-in Functions >====== SEND (send message to file driver) ====== Previous pageReturn to chapter overviewNext page

SEND(file,message)

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 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

send_send_message_to_file_driver_.htm.txt · Last modified: 2021/04/15 15:57 (external edit)