Metin,
Do you create views on SQL Server or in VFP. What VFP version/Service pack are you using?
>I have a problem with ms sql 2000:
>1- my database has tables "a" and "b"
>2- in any module I merge "a" and "b" tables into view "c".
>3- in that module I create view "d" from table "b".
>4- when I delete record(s) from view "d" computer hangs up. this problem does some computers but doesn't do some. And I can't understand different those computers. I tried delete with sqlexec command ( sqlexec(xhand,"delete from ...")) instead of use "d" view and delete but this cannot solve my problem. One way which I found solve problem: don't create view "c" and delete records. but I must use view "c".
>5- ?????????????????????????????????
--sb--