>hi all:
>
>when i use SQL SELECT to select records from a table, i end up retreiving the deleted records too although SET DELETED is ON. how do i overcome this problem ?
It seems to me that your form is set to Private Datasession. Issue SET DELETED ON in the load event of the form.
To make sure, why don't you include !DELETED() in the WHERE clause of the SELECT SQL?
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net
CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."