On Mon, Dec 22, 2008 at 18:11, Barbara Duprey <[email protected]> wrote: > Drew Jensen wrote: > >> 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. > > JT- I changed the single quotes to double quotes and the response was "command completed successfully. I set up my test this way: I went into one of the records in the column "Major/Common Side Effects" and I hit "Enter" a dozen or more times which should be the Carriage Return correct? I then saved the record so that it now looked like the text at the bottom of the email ( I placed it here so the conversation wouldn't be overly messy (btw would it be better to use pastebin for this type of thing?).
When I went back to check the record after running the command, it still had all the CR's at the end even though HSQLDB says "command completed successfully". It Didn't do what I expected it to do. I went back to the original reference page but I don't see another command that matches what I'm trying to do. [Contents of a field in the record "Major/Common Side Effects" before and after running the command we've discussed] "CNS: confusion, sedation, dysphoria, euphoria, floating feeling, hallucinations, headache, unusual dreams, EENT: blurred vision, diplopia, miosis, Resp: respiratory depression, CV: hypotension, bradycardia, GI: constipation, nausea, vomiting, GU: urinary retention, Derm: sweating, Misc: physical dependence, psychological dependence, tolerance, CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR CR" > >> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > -- I've discovered the key to success is to never give up. You either learn the right way, or you run out of ways to do it wrong. A win/win situation!
