VFP to SQL via ODBC add records to table with key field

Using VFP 9 remote view connecting to SQL 2005 via ODBC.

On the SQL side I have a table with three fields, one is a primary key type
BigInt, other two are text

On the VFP side I have a remote view selected, append blank, browse, type in
number to key, then text to other two.

When I try and close the view it errors out saying the key field does not
accept null values, but in the remote view it is not null and has a value.
There is only one record added in the remote view.

What am I missing?

Ben
Wed Sep 12 14:58:41 PDT 2007

nevermind....forgot to check the old write box which appears to be cleared
by default when you have a key field.

Ooops! =)


"Ben" <nospam@thankyou.com> wrote in message
news:46e85c38$0$24260$4c368faf@roadrunner.com...
> Using VFP 9 remote view connecting to SQL 2005 via ODBC.
>
> On the SQL side I have a table with three fields, one is a primary key
> type BigInt, other two are text
>
> On the VFP side I have a remote view selected, append blank, browse, type
> in number to key, then text to other two.
>
> When I try and close the view it errors out saying the key field does not
> accept null values, but in the remote view it is not null and has a value.
> There is only one record added in the remote view.
>
> What am I missing?
>
>
>