>Hi all,
>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?
>~M

One way would be to specify default values for all fields. However this is only supported for DBC tables.

The problem with any other approach is, if the table receives one extra field that is not nullable, you need to update all inserts. Not a problem if you have one central application and a class as Michel suggests, but if you have other services/API's doing inserts on that table it becomes a real problem.