andrew wrote:
Barbara,
I sure don't feel preached at, just informed. Would you by any chance
know the SQL to remove leading and trailing blanks from FIELDA in
TABLEB? I'm sure it's all somewhere in there, but I can't face that
learning curve right now!
UPDATE TABLEB SET FIELDA = TRIM( FIELDA )
Because your table and column names are all upper case there is no
need for the double quote characters.
One note of caution: Base defaults to AUTO_COMMIT = TRUE in the GUI.
Therefore when an UPDATE or DELETE statement such as the one above is
executed in the SQL window the changes are immediately made permanent
in the database. There is often no easy way to say - oops, didn't mean
to do that exactly, undue please So before you begin mass data
manipulations it really is a good idea to make a backup copy of your
Base file - just in case.
Hmm. In the Execute SQL Statement dialog, I had
UPDATE "Addresses" SET ADDR = TRIM ( ADDR )
What I got was an error:
2: Unexpected token in statement [UPDATE "Addresses" SET ADDR = TRIM ( ADDR]
Note that it seems to have dropped the closing paren, and the preceding
blank - I have no idea why. Certainly I can see why that would be an
unexpected token, when the term never closed, but where did the paren I
had there go? I tried with and without a trailing blank on the command,
and various other blanks inserted/deleted. I also tried both with the
Table list visible and the Addresses table selected, and with the Query
list visible, but I got the same response each time. Suggestions? I'd
really love to learn how to use this capability, it's obviously very
powerful.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
