>I have a table converted from an Access database. It has fields originally defined as NUMBER in the Access database. When the converted table is opened in the VFP table designer, these fields show as datatype DOUBLE, which seems to make sense. However, COPY STRUCTURE EXTENDED shows the datatype as BLOB. Is this a bug or does anyone know what's going on here? Why the inconsistency in VFP?

How did you come to such conlusion? The field type for DOUBLE is 'B' and for BLOB is 'W'.