AnsweredAssumed Answered

Base Elements SQL: Insert into table using FM field values

Question asked by danjamins on Oct 10, 2017
Latest reply on Oct 11, 2017 by danjamins

Hi All,


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!

Thank you,