Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!sol.ctr.columbia.edu!ira.uka.de!smurf!altger!doitcr!lwtua6!bressler
From: bressler@lwtua6.sdi.sub.org (Stefan Bressler)
Newsgroups: comp.databases
Subject: Re: What is missing in Paradox 3.5
Message-ID: <678@lwtua6.sdi.sub.org>
Date: 16 Apr 91 17:13:37 GMT
References: <DNB.91Apr10115927@meshugge.media.mit.edu> <1991Apr14.054946.24487@NCoast.ORG> <1991Apr15.041214.11383@cica.indiana.edu>
Organization: EDV-Beratung und Entwicklung
Lines: 51

In article <1991Apr15.041214.11383@cica.indiana.edu> gribble@ogre.cica.indiana.edu writes:
>-Support for Time data type
You can use the character type and create a validity check.  Calculation is
difficult but you can store time data.

>-Support for Memo fields  (i know you can use add-ons, but they are cumbersome)
They are not there but I don't miss them.  The relational data model
consists of tables and only tables.

>-Auto-Increment Keys
I have a macro for this. See addfield.sc at the end of this article.

>-Support for Referential Integrity (enforcing at Table level)
>-Support for Foreign Keys
If you use multi table forms, these things are enforced.

>-a Compiler
More than that I would like a better query optimizer.  For complicated
queries Paradox can be very slow.
Also I would like to omit the final sorting and duplicate elimination in a
query.  In SQL this is possible, too.

mfg
Stefan Bressler

; -----------------------------------------------------
; addfield.sc by Stefan Bressler (bressler@sdi.sub.org)
; put into init.sc: setkey -30 play privdir()+"addfield"
; and use addfield.sc with Alt-A while in edit-mode.

IF SYSMODE()<>"Edit" THEN
   MESSAGE "Use the Edit-Mode if you want to make changes."
   ch=GETCHAR()
ELSE
   IF FIELDTYPE()="N" OR FIELDTYPE()="S" THEN
      ? "Increment actual field by? "
      ACCEPT "N" TO tmp
      IF NOT ISBLANK(tmp) THEN
         []=[]+tmp
      ENDIF
         RELEASE VARS tmp
   ELSE
      MESSAGE "not a numeric field."
      ch=GETCHAR()
   ENDIF
ENDIF
RELEASE VARS tmp,ch

-- 
Stefan Bressler, bressler@sdi.sub.org, 089/611-67-64
Bussardstrasse 42, 8025 Unterhaching bei Muenchen, Deutschland