index creation & SIZE

Thread View: borland.public.vdbase.data.sql

4 messages

[T] Back to Threads [V] Tree View [G] Group Articles

4 total messages Started by kdtc Thu, 01 Apr 1999 00:00

#64

Author: kdtc
Date: Thu, 01 Apr 1999 00:00

38 lines
1375 bytes

It's been some time since I've posted here.

Anyway...

I have datafiles that have the field name "SIZE".  
I used the CREATE TABLE command as follows:-

CREATE TABLE "STOCK" {;
      STOCKNUM    CHAR(6),;
      SIZE        NUMERIC(5,2),;
      ....[and other fields...]..)

     After that command, I issue the following commands:-

CREATE INDEX STOCKNUM ON "STOCK" (STOCKNUM)
CREATE INDEX SIZE ON "STOCK" (SIZE)
[...etc..]

It then gave me an Invalid keyword usage "SIZE".

I know for sure it's complaining about the "SIZE" keyword.
Even when I tried the following:-

CREATE INDEX "STOCK"."SIZE" ON "STOCK" (SIZE)

It still won't work.  

Can someone point out why it's complaining about the SIZE field,
and how I might be able to create an index for the "SIZE" field?

Any help appreciated.

Edmund



-- 
email : kdtc@netfront.net

Re: index creation & SIZE

#65

Author: Ken Mayer [dBVIPS]
Date: Thu, 01 Apr 1999 00:00

16 lines
788 bytes

kdtc <kdtc@netfront.net> wrote:

>Can someone point out why it's complaining about the SIZE field,
>and how I might be able to create an index for the "SIZE" field?

Name it something other than size ... seriously.

Ken
---
Ken Mayer [dBVIPS]

GO HERE! NOW!

news.dbase2000.com

These newsgroups are going away fast!

Re: index creation & SIZE

#66

Author: kdtc
Date: Thu, 08 Apr 1999 00:00

29 lines
1164 bytes

Ken Mayer [dBVIPS] wrote:
> 
> kdtc <kdtc@netfront.net> wrote:
> 
> >Can someone point out why it's complaining about the SIZE field,
> >and how I might be able to create an index for the "SIZE" field?
> 
> Name it something other than size ... seriously.

Oh..  hmm..  don't think my boss'll like that.  
How come dBase III+ can do an index on the SIZE field?  

Anyway, thanks for the info!

Edmund

> 
> Ken
> ---
> Ken Mayer [dBVIPS]
> 
> GO HERE! NOW!
> 
> news.dbase2000.com
> 
> These newsgroups are going away fast!

-- 
email : kdtc@netfront.net

Re: index creation & SIZE

#69

Author: Geoff S. Wass ( dBVIPS )
Date: Fri, 09 Apr 1999 00:00

12 lines
910 bytes

Edmund,

Just a guess... try 'SIZE' instead of SIZE (it may be a keyword).

--
Geoff Wass ( dBVIPS )
Kuala Lumpur, Malaysia

=>=> More dBASE info at http://members.theglobe.com/Geoff_Wass <=<=

*>*> Visit the NEW! dBASE Inc. news groups on the news server
news://news.dbase2000.com <*<*

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads