Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 8 of 8 total |
Redefine Feild Name |
Thu, Apr 6 2006 7:37 AM | Permanent Link |
"Bern Rudisill" | Hello
I am trying to rename one of my fields from ScritpEmailedTo TO ScriptEmailedTo using the following SQL ALTER TABLE User_archive REDEFINE IF EXISTS ScritpEmailedTo ScriptEmailedTo BOOLEAN USER MAJOR VERSION 8 USER MINOR VERSION 0; But I keep getting this error DBISAM Engine Error # 11949 SQL error - 'End of ALTER TABLE statement expected, instead found 'ScritpEmailedTo'' I have tried it with quotes around the field names also and get the same error. What am I missing? Bern -- |
Thu, Apr 6 2006 8:09 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Bern
Try a comma after BOOLEAN Roy Lambert |
Thu, Apr 6 2006 8:17 AM | Permanent Link |
"Bern Rudisill" | Roy Lambert wrote:
> Bern > > > Try a comma after BOOLEAN > > Roy Lambert Tryed, same error Bern -- |
Thu, Apr 6 2006 8:28 AM | Permanent Link |
"Bern Rudisill" | Bern Rudisill wrote:
> Roy Lambert wrote: > > > Bern > > > > > > Try a comma after BOOLEAN > > > > Roy Lambert > > Tryed, same error > Bern BTW using DBISAM 4.22 build 6 and just got to love my spelling tryed, that's a good one. Bern -- |
Thu, Apr 6 2006 8:49 AM | Permanent Link |
"Iztok Lajovic" | Bern
I tried your SQL statement with DBSYS 4.23 build 2 and worked fine without reporting any error. Iztok Lajovic "Bern Rudisill" <bernr@no-sp.am.exitcare dot com> je napisal v sporočilo news:A0D594AF-2D0E-40D0-AAE0-5163A6BE57BC@news.elevatesoft.com ... > Bern Rudisill wrote: > >> Roy Lambert wrote: >> >> > Bern >> > >> > >> > Try a comma after BOOLEAN >> > >> > Roy Lambert >> >> Tryed, same error >> Bern > > BTW using DBISAM 4.22 build 6 > and just got to love my spelling tryed, that's a good one. > > Bern > > -- > |
Thu, Apr 6 2006 9:07 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Bern
Just tried it here (even created a 1 field table to use your names) and it works. Are there any weird characters embedded in the string - try retyping it maybe. Roy Lambert |
Thu, Apr 6 2006 4:31 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Bern,
<< I am trying to rename one of my fields from ScritpEmailedTo TO ScriptEmailedTo using the following SQL ALTER TABLE User_archive REDEFINE IF EXISTS ScritpEmailedTo ScriptEmailedTo BOOLEAN USER MAJOR VERSION 8 USER MINOR VERSION 0; But I keep getting this error DBISAM Engine Error # 11949 SQL error - 'End of ALTER TABLE statement expected, instead found 'ScritpEmailedTo'' >> It sounds like what Roy stated - there's an embedded character in there somewhere. If this is reproducible, if you can send me something that reproduces it, I'll be happy to take a look at it here. -- Tim Young Elevate Software www.elevatesoft.com |
Wed, Apr 12 2006 7:10 AM | Permanent Link |
"Bern Rudisill" | Tim Young [Elevate Software] wrote:
> Bern, > > << I am trying to rename one of my fields from ScritpEmailedTo TO > ScriptEmailedTo using the following SQL > > ALTER TABLE User_archive REDEFINE IF EXISTS ScritpEmailedTo > ScriptEmailedTo BOOLEAN USER MAJOR VERSION 8 USER MINOR VERSION 0; > > But I keep getting this error > > DBISAM Engine Error # 11949 SQL error - 'End of ALTER TABLE statement > expected, instead found 'ScritpEmailedTo'' >> > > It sounds like what Roy stated - there's an embedded character in > there somewhere. If this is reproducible, if you can send me > something that reproduces it, I'll be happy to take a look at it here. Just wanted to post back and say thanks for all the help. I reduced my statement to ALTER TABLE User_archive REDEFINE IF EXISTS ScritpEmailedTo ScriptEmailedTo and that works fine Bern -- |
This web page was last updated on Monday, May 6, 2024 at 03:23 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |