>dear all,
>i've got problem here, help me...plz...
>
>i have a table with a primary key. i use it in a form so i can make a new record and delete it. the problem is there is an error, with the primary key, if i make a new record after i delete one record in that table. anyway, i won't be able to 'PACK' the table coz i use a grid in the form to browse all data/record. i've tried using 'SET DELE ON' & 'SET FILTER TO NET DELETED()' but it doesn't work.
>what should i do?
>
>thank's before...
SET DELETED is scoped to the current datasession. That means that if you use private datasessions, you must SET DELETED ON in the form - the global setting will not be respected.
PACK should only be done ocassionally; for instance, once a month.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
