Create new SQL row from filemaker

[EBJ]

This one has got me flummoxed. Using the ODBC driver, I am able to view, make relationships etc with my SQL online database and Filemaker. Within a typical SQL app such as Sequel Pro, I can create a new row (record) quite easily. This involves the auto creation of a 4-digit ID. The problem is, I cannot perform the same task within Filemaker. The crucial field (Product_ID), has non modify attributes, and as such, throws up an error during a new record creation script. Is there a solution via the Execute SQL script?

 

Eric

[Lee Smith]

Automatic message

This topic has been moved from "External Data Sources" to "FQL or FileMaker Query Language".