Re: row handle, please help!

Does H or D got autoinc field?
If so then after you post you need to refrash the data.



"Iwan" <send2iwan@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:426c6c5d@xxxxxxxxxxxxxxxxxxxxxxxxx
> i have a join query (view) like this:
> select h.*,d.Name from Users h, Employee d
> where h.EmployeeId=d.EmployeeId (i mean for lookup Employee.Name only)
> when i try to insert a record, it say "row handle refered to a deleted row
> or a row marked for deletion"
> but the record gone until requery. (the current record get posted). if i
try
> this from Sql servers enterprises manager this process sucessfull without
> any complain.
> please help.
>
> thanks for attention and reply.
> regards,
> Iwan
>
>


.