>IS it true when using insert into that you have to account for all the fields even thought you want to leave some of them blank? I have a dbf with 30 fields and want to insert a new record and I only care about say 5 fields, I have to provide a value for each 30?
No it's not true. You could provide just one if you want. But if you won't provide all values or you would provide values in a different order than its structure you have to specify fieldnames in the order you're providing values :
insert into myTable (myField3, myField7) values ('FieldValue',{^2000/1/1})
First parentheses part (parentheses required) is a list of fields in the order you provide values.
Second parentheses (after values-again parentheses required) lists values that would go to fields in corresponding order in first.
Note: Fields that have a default value defined get that defined value unless overridden by providing a value for them.
You could also do this :
scatter memvar blank
m.MyField8 = 'Somevalue' && Only populate field named MyField8
insert into myTable from Memvar
Cetin