>Thanks, Bonnie and Naomi.
>
>That was helpful. I'd like to figure out a way to generate the stored procedure as well.
>I'm certain that I can do it in VFP, but by the time I do that, I can probably type it.
>It's long and debugging is a nightmare if there's just one typo.
>So I'm developing incrementally - twenty or so columns at a time.
>I figured out a way to do all the bindiings automatically and that saved a lot of time.
>
>Is there a way to initialize the values of all the columns in a blank row to the equivalent of VFP's EMPTY()?
>To avoid nulls I'm doing this, column by column.
> ds.Tables["arcust"].Rows[0]["credit"] = 0;
> ds.Tables["arcust"].Rows[0]["pterms"] = " ";
>
> The tabled contains a wide variety of data types.

There are lots of SP generation tools available. A while ago I used MyGeneration which can do a lot more than generate SP only.

Take a look MyGeneration