John Toliver escribió:
> On Fri, Dec 19, 2008 at 13:16, Drew Jensen <[email protected]>wrote:
>
>> Rainer Schuetz wrote:
>>
>>> On 19.12.2008, at 17:48, John Toliver wrote:
>>>
>>> JT - I wasn't sure what other information to provide. But I'm running
>>>> Openoffice 3, Base. Using the standard HSQLDB for the backend. Using
>>>> GNU/Linux 2.6.24-21-generic.
>>>>
>>> So you might want to check online-documentation for HSQLDB (google it up,
>>> you might even try HSQLDB TRIM RTRIM)
>>>
>>> Oh give google a day off and try this:
>> http://wiki.services.openoffice.org/wiki/Built-in_functions_and_Stored_Procedures#String_Functions
>
>
> I went to the above site and have been trial and erroring with the rtrim
> command in the SQL command window. I get the following errors:
what do you mean here?
[ ] the "Tools" - "SQL" dialog
[ ] the Query in Design View
[ ] the Query in SQL View [that is: when you type the SQL command
directly]
> I enter in this: RTRIM( ' . ' ) - I'm trying to tell it to remove all
> trailing spaces in any field after the last period.
> I receive this error:
> 1: Unexpected token: RTRIM in statement [rtrim]
are you trying to run a query, or trying to remove all trailing spaces
on a table's field?
> So what do I need to do to make sure this command is executing on the right
> table/query?
Supposing that you are trying an SQL statement that returns a result
set, like
SELECT field FROM table;
did you try RTRIM( "field" )?
where "field" is the name of a filed/column in your table.
Like
SELECT RTRIM( "user_name" ) FROM "CUSTOMERS"
Regards
Ariel.
--
Ariel Constenla-Haile
La Plata, Argentina
"Aus der Kriegsschule des Lebens
- Was mich nicht umbringt,
macht mich härter."
Nietzsche Götzendämmerung, Sprüche und Pfeile, 8.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
