|
Home > Archive > Programming with dBASE > December 2005 > Alter Table using a reserved word
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Alter Table using a reserved word
|
|
| Paul Van House 2005-12-12, 8:23 pm |
| I am trying to drop the field "Message" from a table, then add it back
in with a longer length. (Doing the same for a second field as well)
this is for a program update so I cannot just do it in the table
designer.
However, since "Message" is a reserved word I am having quite a time
trying to figure out the Syntax.
I have Tried
Alter Table " c:\binx\storm6\Messa
ge.dbf" drop Message, Drop Appear_Ord
Alter Table " c:\binx\storm6\Messa
ge.dbf" drop "Message", Drop Appear_Ord
Alter Table " c:\binx\storm6\Messa
ge.dbf" drop 'Message', Drop Appear_Ord
Alter Table " c:\binx\storm6\Messa
ge.dbf" drop Message.'Message', Drop
Appear_Ord
Any ideas?
--
Paul Van House
remove ".removeme" for e-mail replies
Radio/TV Software and Baseball Stat Software:
http://www.binxsoftware.com
Family Home Page: http://vanhouse.binxsoftware.com
Church Home Page: http://www.ashfordumc.org
| |
| Paul Van House 2005-12-12, 8:23 pm |
| In article <MPG. 1e07aca8c908381b9896
bb@news.dbase.com>,
pvanhouse1.removeMe@houston.rr.com says...
> I am trying to drop the field "Message" from a table, then add it back
> in with a longer length. (Doing the same for a second field as well)
I love it when I answer my own question....
Alter Table " c:\binx\storm6\Messa
ge.dbf" drop "Message"."Message", Drop
Appear_Ord
--
Paul Van House
remove ".removeme" for e-mail replies
Radio/TV Software and Baseball Stat Software:
http://www.binxsoftware.com
Family Home Page: http://vanhouse.binxsoftware.com
Church Home Page: http://www.ashfordumc.org
|
|
|
|
|