Forum Discussion

Former_Member's avatar
Former_Member
Accelerator III
9 years ago

AML Incorrect syntax near

Hi ! This AML got ERROR "Incorrect syntax near 'Mold' ". www.dropbox.com/.../2017-08-14_11h47_44.png   <Item isNew="1" isTemp="1" type="iq Mold Acceptance" action="edit" where="iq Mold Acceptance....
AML
Zahar_Chernov's avatar
Zahar_Chernov
Creator II
9 years ago
Jerry, I have 2 options for you to make your code to work:
  1. If you know the ID for the item you can use id attribute and not where attribute, so your code will look like:
    <Item isNew="1"  type="iq Mold Acceptance" action="edit" id='2A4871E1511241E19E300EF92DD5B0C1'>
  2. If you want to use where attribute, you need to change the way you write it, so the name of the item will be between square brackets and spaces replaced with underline:
    <Item isNew="1"  type="iq Mold Acceptance" action="edit" where="[iq_Mold_Acceptance].id='2A4871E1511241E19E300EF92DD5B0C1'">