AnsweredAssumed Answered

Filemaker 17 ODBC Update Repetition field?

Question asked by huntfms on Dec 11, 2018
Latest reply on Dec 11, 2018 by user19752

How do I do an ODBC update to a repetition field? Documentation seems off.

 

Trying to do this ODBC command where CustAddress is a repetition

 

Query:

UPDATE custTable SET \"CustAddress[2]\" = 'X' WHERE \"CustomerID\"='18-160'

 

Error:

ERROR [HY000] [FileMaker][FileMaker] FQL0007/(1:21): The column named "CustAddress[2]" does not exist in any table in the column reference's scope.

 

Any help would be greatly appreciated.

 

Thanks

Outcomes