Set Serial Direct Insert
Specifies how to insert data directly into the database when data is received. If you give an empty filename parameter, the direct insert is canceled.
Set Serial Direct Insert [ Select ; Result (error) ; Port name ; File name ; Table name; Field name ; Match string ; Get last match ]
|Select entire contents||replaces the entire contents of a field with the result. If not checked the result replaces the currently selected portion of the field|
|Result (error)||an error code|
|Port name||the name of the serial port to be coupled to this direct insert setting|
|File name||the name of the file where the data needs to be inserted into|
|Table name||the name of the table occurrence where the data needs to be inserted into|
|Field name||the name of the field where the data needs to be inserted into|
|Match string||(optional) wait for a match string before inserting the data|
|Get last match||if checked the last string of text that matches the match string will be inserted|
Data type returned
The returned result is an error code. An error always starts with 2 dollars, followed by the error code. You should always check for errors. Returned error codes can be:
|0||no error||DirectInsert was set|
|$$-50||paramErr||there was an error with the parameters|
Other errors may be returned.
Troi Serial Plug-in 5.5
FileMaker Pro 16 to FileMaker Pro 2023
If the filename parameter is empty, the plug-in will no longer insert data directly into the database.
Set Serial Direct Insert [ Select ; $ErrorCode ; "port1" ; Get ( FileName ) ; "IncomingData" ; "dataField" ; "OK" ]
This will set the Direct Insert for port1. Incoming data will be inserted into field “dataField” of table “IncomingData” of the current file. The data will not be inserted before the string “OK” is found.
Set Serial Direct Insert [ Select ; $ErrorCode ; "COM2" ; Get ( FileName ) ; "IncomingData" ; "dataField" ; "¶" ]
This will set the DirectInsert for the COM2 port. Data will be directly inserted into field “dataField” of table “IncomingData” of the current file when a return is found in the incoming data.
Set Serial Direct Insert [ Select ; $ErrorCode ; "COM2" ; "" ) ]
This will reset the DirectInsert. Although the incoming data is still buffered, no action is taken when data is received. You can still get the data out by calling the Serial_Receive( ) function.
Related script step
|Set Serial Trigger Script|