>I'm trying to insert into a VFP table. I only need to insert 3 fields, but there are 60+ on the table. Because the fields in the table are not set to accept nulls, not a problem in VFP, it looks like I have to specify every field in the insert command. Any shortcuts or is it a case of grin and bear it?
To avoid that situation, I have been using a data dictionary and an Insert class. Thus, whenever I need to insert a record, I simply fill the fields that are required. The class would then sum the rest in order to avoid null values and put default empty values. This, by the same, resolves the restriction which may have been put at the database itself.