>can this be done?
>
> I have in mind being able to write something like:
>
>create table 'mytable' with fields 'Mydate':D, 'MyRef':C:15,'MyNum':N:10.2 indexed on MyDate, MyNum
>
>we cant use Sql because in the kind of context I am thinking of, the field name might often be extracted from the data - for instance Sales Reps names...
>
>eg
>
>create table 'mytable' with fields 'Commission':N:10.2, Rep1:C:20,Rep2:C:20,Rep3:C:20 etc...
>
>or, for example creating edi forms to suit a supplier using template details provided by them but stored in your data...
>
>eg
>
>create table 'mytable' with fields theirfield1:theirtype1,theirfield2:theirtype2, theirfield3,theirtype3 etc
>
>did I see a thread somewhen on this?
>
>or did I dream it?
>
>Harry


Try using the CREATE TABLE in VFP

Bernard