RafaelCaballe

ODBC Transaction

Discussion created by RafaelCaballe on Mar 12, 2015
Latest reply on Mar 15, 2015 by RafaelCaballe

Hello,

 

I am experiencing some issues related to an OBDC connection which writes on a FileMaker table. The arrangement I have is a Detection table with following fields:

 

    • id = auto-enter, unique, Get ( UUID )
    • id_Line
    • id_Job = auto-enter calculation replaces existing value: Let ( ~trigger = id_Line; Detection_Line_JOB_active::id)
    • creationTimeStamp = auto-enter

 

The physical production line has a sensor that counts product passing through. When sensor detects a product, the script (external to FM) creates a record in the Detection table (OBDC client). Afterwards the same script sets the Detection::id:Line. We have several lines, each one having its own detector. Each line has a PC were we run the script that creates the record. Each script has hardcoded the id of its line.

 

Records are well created, id_Line is correctly stablished, creationTimeStamp too, but... the id_Job field gets nothing...It seems like if were no data in the id_Line, since is unable to resolve the calculation which would populate the id_Job field.

 

In fact I have not coded the external script that populates records in the FM table. Some other guys did it, but I feel that there is something missing in this script. Could be anything related to how the records is committed?

 

Am I missing something that prevents form getting data on the id_Job field?

 

Thanks,

~Rafael

Outcomes