[comp.databases] dBase IV Created Field Problem.

stevens@janus.trl.oz (TONY STEVENS, MGR PLANS & PROGRAMMES) (10/13/89)

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.