I thought this was straightforward but it seems not

I have DBISAM3 and need to know if all my table names need to be
restricted to a single word if I use the following construct (I hope
not)

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

Its been a while haven't touched version 3 however I recall making a change
in Version 4 to use ansiquoted (double quotes)
versus single quotes in Version 3 ..

So try single quotes for the identifier .. ie quotedstr('Daily Schedule')
Another option I believe is the square bracket [Daily Schedule]

hth.
Donat.


"Mike Saunders" <mike@folleytech.co.uk> wrote in message
news:543DCC9B-5B93-49B1-9AA6-391A2E024B45@news.elevatesoft.com...
>I thought this was straightforward but it seems not
>
> I have DBISAM3 and need to know if all my table names need to be
> restricted to a single word if I use the following construct (I hope
> not)
>
> 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

> SQL.Add('ALTER TABLE MEMORY "daily schedule" ' );
>
> DBISAM does not like the multi word table name I thought I could
> enclose with double quotes

Are you sure this is the problem.  I tried the following in DBSYS v 3.30 and
it worked fine.

CREATE TABLE MEMORY "daily schedule"
(test CHAR(10));
ALTER TABLE MEMORY "daily schedule"
ADD test1 CHAR(10);

John

John Hay wrote:

> Mike
>
> > SQL.Add('ALTER TABLE MEMORY "daily schedule" ' );
> >
> > DBISAM does not like the multi word table name I thought I could
> > enclose with double quotes
>
> Are you sure this is the problem.  I tried the following in DBSYS v
> 3.30 and it worked fine.
>
> CREATE TABLE MEMORY "daily schedule"
> (test CHAR(10));
> ALTER TABLE MEMORY "daily schedule"
> ADD test1 CHAR(10);
>
> John

Thanks I made the age old mistake of assuming the problem was where it
wasn't and ignoring the real source of the error

Mike