WHERE clause values on Update Statement

[jde1228]

I am having a Headerless Detail Form where I would like to update and add records on clicking ok. Now, I am only able to add records, update is not happening.

I did some research and checked the debug log files. The SQL statements have correct values for the SET part of Update but it has blank values for 2 fields in WHERE clause.

Can someone put light on this as to -
1) How the values are populated for the WHERE clause since the values for the SET part come from the grid ?
2) What could be the reason its messing up on 2 fields?

I am attaching the extracted log file.

Thanks,

 

[Larry_Jones]

Hello Mystery person,

Have you built and deployed a server update package containing your custom table yet?

I've seen this behavior in the past where for new (Custom) tables I can view and insert but not update from OneWorld until the server specs are updated.

Suggest you try promoting the current table definition to the server.

Regards,