Lasso Soft Inc. > Home

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.

Lasso 9 Issues



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

Comments

02 Oct, 2013 by Tim Taplin
Looking for any update on this issue. The LassoGuide documentation still shows the -keyfield parameter being optional and discouraged in Filemaker -update inlines. However, it appears to not pass the -keyvalue thru to FM unless the -keyfield parameter is set. In most cases for an update, this means setting -keyfield = ''
28 May, 2014 by Paul Higgins
Not sure this can be done as is, without changing other datasources. Will look into it.

Workaround is to use -recID. Docs may need to be updated.
28 May, 2014 by Paul Higgins
[4215] Fixed. Other datasources need to be tested.
Please log in to your LassoSoft account to comment

LassoSoft Inc. > Home

 

 

©LassoSoft Inc 2015 | Web Development by Treefrog Inc | PrivacyLegal terms and Shipping | Contact LassoSoft