Pascal,
As Ed Pikman said, you need to set "Set Deleted ON". Don't forget that this command is linked to the data session, so if your are using a private datasession you will need to add this command to the form load method.
HTH
Barbara
>I have a big problem with a grid that i cant quite solve. In an application, I want to use a grid control that will show the user a list of choices. These choices come from a table. If I run the application from within VFP, everything works fine, but when I create an EXE file and run it, the grid shows even the records with the "deleted" mark, and of course I dont want that to happen.
>
> So i tried to open the table exclusively so that I could pack the database each time the user chose a record, but when the application loads, it tells me that the file is in use.
>
>I also tried to set the grid's record source property to alias, and then open the table shared, but I can't get the grid to show anything ( I also tried many other things such as setting the column's control source property to the fields of the table, but nothing worked)
>
>Does anyone know how I could get the EXE file not to show the deleted records (or maybe another way i could get the grid to show the right things)