>I was thinking I had to have the entire table in order to insert a record. If I had a narrow scope view, I thought I could NOT insert a record that did not match that view.
>
>Question:
>If I have a view that returns NO records, can I still insert into the SQL table?
>
>I mean for example a view with all phone numbers that match 1234567890 and it does not find one in the sql table. Can I insert a record with phone number 987654321 ?????
Sure you can.
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison