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:
"4: Table not found in statement [UPDATE TestMedData]"
2."UPDATE 'TestMedData' SET 'TestMedData' = RTRIM('Major/Common Side
Effects')" and received this response: "5: Unexpected token: TestMedData in
statement [UPDATE 'TestMedData']"
Now this feels like I simply am missing the proper syntax for issuing this
SQL command, but I created the test table and pasted the name from the table
into the template you wrote for the SQL string the difference between the
two was the quotes surrounding the name of the table "TestMedData".
thanks for your help, I do appreciate it.
John T.
>
> ---------------------------------------------------------------------
> 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!
