This whole thing comes from the fact that I couldn't quite get an ActiveX grid to do what I need, or to work at all, the MS Datagrid had two problems

1 - It gave an error message when the user didn't manually remove trailing spaces (maybe using varchar could take care of that?).

2 - I can't seem to get it to use a checkbox in anything but boolean data, as opposed to VFP where you could have a checkbox for a numeric, SQL server doesn't have a boolean data type, 7.0 has a bit data type but not 6.5, and I'm still not sure if it will work with a checkbox.

So I decided to use VFPCOM, but that has it's own set of problems, I'm giving it another shot right now.

I've looked into some 3rd party ActiveX grids but non of the ones I've tried work quite right with VFP, or the way I want it.

>Basically you can't modify identity type fields on the client side. I would recommend using the VFPCOM utility to convert from VFP cursor to ADO recordset, considering that you have an identity type field.
>
>My preference in the cases were the data comes from non-VFP sources is to work on the ADO recordset itself, IOW not doing the conversion to VFP cursor. You loose a lot of xbase and set-based functionality but you eliminate problems related to the conversion.