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]