stevens@janus.trl.oz (TONY STEVENS, MGR PLANS & PROGRAMMES) (10/31/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. Has anyone else seen this problem? Tony Stevens, Telecom Australia Research Laboratories. MAIL : tony.stevens@xwitt.trl.oz.au