Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!mailrus!cs.utexas.edu!uunet!munnari.oz.au!bruce!trlluna!janus!stevens
From: stevens@janus.trl.oz (TONY STEVENS, MGR PLANS & PROGRAMMES)
Newsgroups: comp.databases
Subject: dBase IV Created Field Problem.
Message-ID: <10821@janus.trl.oz>
Date: 13 Oct 89 11:26:59 GMT
Organization: Telecom Research Laboratories
Lines: 20

Another dBase IV Problem.

I have created a VIEW under dBase IV which joins together 3 database files,
contains a complex condition box and contains one created field.  This
field is a logical field used to test if two character fields both contain
information.

After selecting this view it is impossible to use COPY TO <filename>
(none of the forms work - WKS was the one I particularly wanted) as the
resulting file contains no information.  I tried the normal thing of GO
TOP befor hand with no effect.   The operation of COPY TO does not work
in a .PRG file, from ASSIST or from the <.> Prompt.

The only solution was to remove the created field or use
     IIF(string1>"  " .and. string2>"  ","YES","NO ")
to convert the created field to a character field.


Tony Stevens, Telecom Australia Research Laboratories.