On 12/22/2008 5:27 PM, Barbara Duprey wrote:
Corrected....
Barbara Duprey wrote:
John Toliver wrote:
See below:
On Sun, Dec 21, 2008 at 20:46, Barbara Duprey <[email protected]> wrote:
I think you need something like this in the SQL command window:
UPDATE 'your_table' SET 'your_field' = RTRIM('your_field')
JT- I created my string in two ways:
1: "UPDATE TestMedData SET TestMedData = RTRIM(Major/Common Side
Effects)"
<without the quotes at the ends of the string> and received this
response:
<snip>
OK, I tried this on a test database in 2.4.1 on VistaHP. The
double-quotes are needed for all references.
Just to clarify:
It is a requirement to use double quotes when identifier names use mixed
or lower case, when using an embedded database. The HSQLdb engine
automatically casts all non-quoted identifiers to upper case before
execution.
Drew
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
