Easy to Create, Easy to Change - Easy to use!


ExecDQL problem with syntax.


Started by Dave
Search
You will need to Sign In to be able to add or comment on the forum!

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.

Written by Dave 22/06/15 at 08:53:08 Dataease [{8}]FIVE

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.

Written by DataEase 22/06/15 at 09:00:48 Dataease [{8}]FIVE