>Hello Vladimir,
>
>Thank for your reply.
>
>I have already solved the problem of the Deletion.
>But it have created a new problem.
>As i deleted a invoice and i add a new invoice with the same invoice no. (deleted previous), an error will be occured. (Primary key is not unique). How can i fix this problem ?
What we do is we SET DELETED OFF before seeking the record using the primary key field. If found, we RECALL the record, else we do INSERTion, then SET DELETED ON again.
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."