At 02:13 PM 8/12/2008, Patti Jakusz wrote:
I'm using the Enterprise Edition of Rbase for Windows 7.6.4.30715
I can't seem to delete any tables. When I use the Data Explorer,
I highlight a table and hit the delete command. I get an error
message saying: Syntax error (2367).
Patti,
Make sure that your database IDQUOTES settings are set to `
That is a reversed single quote underneath the tilde "~".
CONNECT dbname
SHOW CHAR
Notice that the last IDQUOTES is set to NULL.
Now change the IDQUOTES setting to `
SET IDQUOTES=`
That should take care of everything!
I tried to go to the R> prompt and type: Remove table tablename
but I get an error saying it's not supported.
Use the DROP tablename command to achieve that goal in a command
file or at the R> prompt.
Also, make sure that you are using the latest updates of R:BASE.
Very Best R:egards,
Razzak.
