Query related to Filter

JAYESH

I am working on Navision 4.0.

I insert one record from the form in to table.

and i check from the back end in to table i found that record in to table.

and i again go in to form and delete that record.

i check from the back end in to table then i didnt find the record in to table.

but in that table when i filter on primary field and try to search that record it's show me that record.

and i again try to insert that record from the form but it's doesnt show me any message like record is already exits..so my question is at the filter time on primary field why it's show me the record is there..

i request you if any one knows then let me know..

thank you..

kine

i check from the back end in to table then i didnt find the record in to table.

but in that table when i filter on primary field and try to search that record it's show me that record.

What you can see on left side of the line? Asterisk and arrow or just arrow? (the first column of the table, the small one first from the left, the one you cannot select by cursor)...

JAYESH

asterik and arrow both after i do filter on primary field.

kine

8) It means, that what you see is not in the database yet and it is just created line waiting for inserting into table. It is normal, that if you filter on PK on form, if no line is found, new line is preapred and the PK is filled in with the filtered values (if the filter is simple one value per field). It means, that all is working correctly, the record is not existing in the table, you just thought that it is... :whistle:

JAYESH

Thanks for the information ...


I got it...

Thanks once again..