Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Syntax error in form
Message
From
01/11/2002 07:17:05
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Syntax error in form
Miscellaneous
Thread ID:
00717709
Message ID:
00717709
Views:
47
I already solved this situation, but I am curious about the general principle involved.

Try the following:

  • Create a new form.
  • Create a custom property.
  • Assign the following value to the custom property: (viewlevel>=gu_userlevel or viewlevel=0) and (empty(workgroup) or gu_workgroup = "todo" or ";" + alltrim(gu_workgroup) + ";" $ ";" + alltrim(workgroup) + ";")
  • Save the form, and try to open it again.

    In VFP 6, I get the error message "Syntax error", without further explanation, and can't open the form. The problem can be corrected by hacking the form, placing "=[" at the beginning, and "]" at the end of the above expression. But in the beginning, I didn't know what created the syntax error, and found it easier to recreate the entire form from scratch.

    Strangely, I didn't get any error message when placing the above value to the "Comment" property.

    Hilmar.
    Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
  • Next
    Reply
    Map
    View

    Click here to load this message in the networking platform