I'm trying to figure out how to use the BE plugin to execute an SQL insert query which will insert FMP data. Not seeing anything regarding this in the documentation. I know with ExecuteSQL I can pass data from FMP fields into the query using the ? operator. Is there anything similar with the BE plugin's SQL function?
Here's the ultimate goal:
I have table A located in an fmp database called DB1
I also have table B in an fmp database called DB2
I want to insert a record from table A in DB1 to table B in DB2
I want to capture the values from all fields in the table (it's a syncserver audit log table so not too many fields)
Any help is appreciated!