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
--

Bern


Try a comma after BOOLEAN

Roy Lambert

Roy Lambert wrote:

> Bern
>
>
> Try a comma after BOOLEAN
>
> Roy Lambert

Tryed, same error
Bern

--

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

--

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
>
> --
>

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

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

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
--