Page History
...
Returns the rows specified in keylist. If a single key is passed to the routine the results will be placed into the @RECORD system variable, as well as the SYSTEM RECEIVER. If multiple keys are passed to the routine, a SYSTEM RECEIVER must be implemented and the data will be returned to the RECEIVER. Data returned to the RECEIVER will contain tab-delimited field values and carriage return/line feed separated records.
See also
Lock, UnLock, Write_Row, RECEIVER property
Example Using System Monitor
...
| Code Block |
|---|
run Read_Row "CUSTOMERS", [1, 2] * This will return the contents of keys 1 and 2 from the Customers table. |
Example Using RECEIVER
| Code Block |
|---|
* Capture text results of Read_Row in the edit box EDITBOX_RESULTS.
Declare Function Get_Property
Declare Subroutine Set_Property, Read_Row
Set_Property ("SYSTEM", "RECEIVER", @window: ".EDITBOX_RESULTS")
Set_Property (@window: ".EDITBOX_RESULTS", "TEXT", "")
Read_Row("CUSTOMERS",1 : @fm : 2, "", "")
recordData = Get_Property (@window: ".EDITBOX_RESULTS", "TEXT")
swap TAB$ with @fm in recordData
swap CRLF$ with @rm in recordData
* reset the receiver property to null.
Set_Property ("SYSTEM", "RECEIVER", "") |
