Drew Jensen wrote:
John Meyer wrote:
I'm trying to do a query in Base that will update all empty values in a field with a default string but so far it's been no go. I try to enter it into the query screen and it rejects because it isn't a SELECT statement.


Use the SQL window instead.

Tools->SQL

In the window you may enter a SQL standard Update command, which from the sounds of your email you already know how to construct.

Drew



Thanks, that did the trick. It was a bit odd finding that menu item in the main Base Window but not in the particular table window.

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to