Path: utzoo!utgpu!utstat!jarvis.csri.toronto.edu!mailrus!uwm.edu!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 Problem with created fields.
Message-ID: <10987@janus.trl.oz>
Date: 31 Oct 89 11:32:11 GMT
Organization: Telecom Research Laboratories
Lines: 23


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.

Has anyone else seen this problem?

Tony Stevens, Telecom Australia Research Laboratories.
MAIL : tony.stevens@xwitt.trl.oz.au