
ExecDQL problem with syntax.
ExecDQL("modify records in contract with (selected = yes), selected = blank.","","","","","")+SetLabelText("Status","All Selected set to Blank!.")?
Should that work? just trying not to do a dql, but can.
Re:ExecDQL problem with syntax.
No. This should not work as the syntax is wrong.
This is the synxtax for a direct Modify Records without a for.
modify records [in TABLENAME|RELATIONSHIP] [named "UNIQUE RELATIONSHIP NAME" ]] [with ( selection criteria) ] FIELDNAME := MODIFIED VALUE ; FIELDNAME2 := MODIFIED VALUE .
You have a , after your with statement. You also have no space between blank and . which also might cause problems.
You also use = instead of := when you are allocating the new value for Select... So far from success here...he,he.
ExecDQL("modify records in contract with selected = yes selected := blank .","","","","","")+SetLabelText("Status","All Selected set to Blank!.")?
?
This is the correct derivation.