nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

SQL Expression to Populate String Field

ScottFraser3

Can’t remember what the syntax is when using Field Calculator with SQL to populate a string field. I’m just trying to populate a field with the word “Yes” but enclosing that word within single or double quotes throws an error.

I remember the solution was simple when I last did this a couple of years ago, just not simple enough for me to recall.

Najděte více příspěvků označených jako

Accepted answers

DavidPike

You don't need to select the field, that's only if you want to reference the current field or other fields in your code block.

from your screenshot it looks like you have directional single quotes (unsure if this is just the case of the ipad post-formatting them). I recon it doesn't understand this unicode character. Try to find the straight single quote on your keypad 'Yes' or:

This article seems to have the fix How to Type Straight Quotes on iPad (osxdaily.com)

All comments

DavidPike

Should be as you described. You sure your field type is Text/String? 'Yes' single quotes should be doing the trick.

ScottFraser3

I thought so, but getting an error. Maybe because I’m trying to do this from home on an iPad. I’ll try again tomorrow from a real computer.

ScottFraser3

It might simply be that I need to select the field from the left column, and not all the fields are showing on my iPad without an ability to scroll down.

DavidPike

You don't need to select the field, that's only if you want to reference the current field or other fields in your code block.

This article seems to have the fix How to Type Straight Quotes on iPad (osxdaily.com)

Připojte se ke konverzaci

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.