RhinoTrac
LassoSoft Ticket Tracking System
NOTE: If you are using Lasso Server 9.3 please Log your ticket directly via the LUX admin as this will give us more information about your issue.
Ticket #7429: -KeyField Required in FM Updates..
- Reported by:
- Daniel Parker
- Date:
- 16 Jul, 2012
- Priority:
- critical
- Component:
- Lasso 9
- Version:
- 9.1.4
- Keywords:
- Platform:
Lasso 9.1.4 connecting to Filemaker Server 11.
The following code is supposed to change the value of field 'Special' from Yes to No on all found records:
Code:
[Inline: -search, -database='DBName', -table='TableName', -op=eq, 'Special'='Yes',-maxrecords='all']
[records]
[KeyField_Value]
[Inline: -update,-database='DBName', -table='TableName', 'Special'='No', -KeyValue=(KeyField_Value)]
[action_statement]<br>
[error_currenterror]<br>
[/inline]
[/records]
[/inline]
Output:
1234
-db=DBName&-lay=TableName&Special=No&-edit
No error
********** You can see from the above that the KeyValue is not passed to Filemaker **********
Adding a non extant KeyField to the update inline fixes it:
[Inline: -update,-database='DBName', -table='TableName', 'Special'='No', -Keyfield='', -KeyValue=(KeyField_Value)]
Output:
1234
-db=DBName&-lay=TableName&Special=No&-recid=1234&-edit
No error
Is this a bug? (A response would be nice :-))
Regards
Daniel Parker
Please log in to your LassoSoft account to comment
Comments
Workaround is to use -recID. Docs may need to be updated.