Drew Jensen wrote:
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]
Hi Drew
It works!!!! Thanks a bunch. It looks like I must learn another
language. :-\
Cliff
--
mailto: [email protected]
Clifton R. Liles "Software to the Stars" [email protected]
Pearland, TX 77581 [email protected] [email protected]
- Speaking for myself! Standard disclaimer applies. -
This address may *not* be used for unsolicited mailings.
Failure is not an option. It comes bundled with your Microsoft products.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
