Just can't see how to fix this statement

SQL.Add('ALTER TABLE MEMORY "daily schedule" ' );

DBISAM does not like the multi word table name I thought I could
enclose with double quotes

Thanks

Mike

Mike Saunders wrote:
> Just can't see how to fix this statement
>
> SQL.Add('ALTER TABLE MEMORY "daily schedule" ' );

What DBISAM version? In 4.x, you have to write "MEMORY\daily schedule".

Ralf

Ralf Mimoun wrote:

> Mike Saunders wrote:
> > Just can't see how to fix this statement
> >
> > SQL.Add('ALTER TABLE MEMORY "daily schedule" ' );
>
> What DBISAM version? In 4.x, you have to write "MEMORY\daily
> schedule".
>
> Ralf

Thanks

I am still on version 3 and the above does not work I'm afraid

Mike

Mike,

<< Just can't see how to fix this statement

SQL.Add('ALTER TABLE MEMORY "daily schedule" ' );

DBISAM does not like the multi word table name I thought I could enclose
with double quotes >>

It should work just fine.  What error are you getting ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

> Mike,
>
> << Just can't see how to fix this statement
>
>  SQL.Add('ALTER TABLE MEMORY "daily schedule" ' );
>
>  DBISAM does not like the multi word table name I thought I could
> enclose with double quotes >>
>
> It should work just fine.  What error are you getting ?



Error message No 11949  :
SQL data type keyword expected instead found 'STRING' in table column

Note I am using DBISAM Version 3

The full procedure is

procedure ReStructureDailySchedule;
begin
 with DM.tbQuery do
 begin
   SQL.Clear;
   SQL.Add('ALTER TABLE MEMORY "Daily Schedule" ');
   SQL.Add('ADD MatColor STRING;');
   ExecSQL;
 end;
end;

"Mike Saunders" <mike@folleytech.co.uk> wrote on Thu, 16 Feb 2006 17:19:11 -0500

>Tim Young [Elevate Software] wrote:
>
>> Mike,
>>
>> << Just can't see how to fix this statement
>>
>> SQL.Add('ALTER TABLE MEMORY "daily schedule" ' );
>>
>> DBISAM does not like the multi word table name I thought I could
>> enclose with double quotes >>
>>
>> It should work just fine. What error are you getting ?
>
>
>
>Error message No 11949 :
>SQL data type keyword expected instead found 'STRING' in table column
>
> Note I am using DBISAM Version 3
>
>The full procedure is
>
>procedure ReStructureDailySchedule;
>begin
> with DM.tbQuery do
> begin
> SQL.Clear;
> SQL.Add('ALTER TABLE MEMORY "Daily Schedule" ');
> SQL.Add('ADD MatColor STRING;');
> ExecSQL;
> end;
>end;

Mike


I think you have to use [] or something like that - I NEVER use table or field names with spaces myself ...

SQL.Add('ALTER TABLE MEMORY [daily schedule] ' );   // This might work in v3

Cheers

Jeff
--
Jeff Cook
Aspect Systems Ltd
Phone: +64-9-424 5388
Skype: jeffcooknz
www.aspect.co.nz

Mike,

> Error message No 11949  :
> SQL data type keyword expected instead found 'STRING' in table column
<snip>
>     SQL.Add('ADD MatColor STRING;');

The error message means what it says. STRING is not a valid SQL field
type. See CHAR in the help file ...and you have to specify a fixed length.

Eryk

Mike,

<< Error message No 11949  :
SQL data type keyword expected instead found 'STRING' in table column >>

What Eryk stated is correct.  You need to use CHAR, not STRING:

procedure ReStructureDailySchedule;
begin
 with DM.tbQuery do
 begin
   SQL.Clear;
   SQL.Add('ALTER TABLE MEMORY "Daily Schedule" ');
   SQL.Add('ADD MatColor CHAR(10);');
   ExecSQL;
 end;
end;

--
Tim Young
Elevate Software
www.elevatesoft.com