Clifton Liles wrote:
Hi All
Is there a way to search and replace in an open office Base database.
In a field I would like to find and replace a value.
There is a good search, but no replace, that I can find. Thanks
Hello Clifton,
The query designer doesn't support update/delete queries - but - if you
are working with a Base file that has an embedded database or is
connecting to a database server ( MySQL, Postgres, SQL Server, etc) then
there is a way to do this.
I'll assume that you have a Base file with an embedded database. (If you
aren't sure then you most likely do)
This means that you can use a standard SQL UPDATE command, entered in
the SQL Window.
For instance - if I had a table Table1 with a column TextColumn and I
wanted to change all records with the string 'Hello' in that column to
'GoodBye' I could do so with:
Open the SQL Window ( Tools>SQL)
Enter the update command:
UPDATE "Table1" SET "TextColumn" = 'GoodBye' WHERE "TextColumn" = 'Hello'
Click on the Execute Button.
You can find general information regarding the UPDATE command by doing
an internet search for 'SQL UPDATE' or specific information regarding
the HSQLdb database engine (used by Base) at
http://hsqldb.org/web/hsqlDocsFrame.html
Chapter 9. SQL Syntax.
or
just ask for more details here.
HTH
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
