NOT NULL fields // index on 2 fields

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

Article #463

Back to borland.public.vdbase.data.sql Previous Next

#463

From: Jens Richter
Date: Tue, 01 Dec 1998 00:00

20 lines
1055 bytes

I have 2 further problems with local SQL in VdB:
- How can I define NOT NULL fields ?
- When I try to create an index over 2 fields,
  I get the error message "Feature not available"
  ("Merkmal nicht verfuegbar.") :
if file(      "pruef.dbf") 
  DROP   TABLE pruef
endif  
CREATE  TABLE pruef;
   ( f_kz   CHAR(6) ,;  &&  NOT NULL
     m_nr   CHAR(6) )   &&  NOT NULL 

CREATE UNIQUE INDEX i_pruef;   
   ON pruef(f_kz,m_nr)           && <--------------------------

What do I wrong ?

Thank you for any help !

Jens

Technical Details

Message-ID: <3663CD64.2DBA27E2@t-online.de>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,e5a7d30f9c0cc0d3,start
X-Google-Attributes: gidff5a1,public
From: Jens Richter <hgc-fg@t-online.de>
Subject: NOT NULL fields // index on 2 fields
Date: 1998/12/01
Message-ID: <3663CD64.2DBA27E2@t-online.de>
X-Deja-AN: 417432206
Content-Transfer-Encoding: 7bit
Organization: Another Netscape Collabra Server User
X-Priority: 3 (Normal)
Content-Type: text/plain; charset=us-ascii
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql