Urgent :why the data from the view get automatically deleted

Hello frens, The data from the Views get automatically deleted after sometime ,Earlier it was deleted after 2 or 3 hrs now the data is deleted after 5,6 days…What’s this problem .The database is created by me and there is no agent running because I have not created any agent.Can anyone tell me what’s this problem ? I really need the solution .it’s a major problem for me

Please tell me asap

Thanx

Subject: Urgent :why the data from the view get automatically deleted

Look at the design of the view. Specifically the SELECT statement.Is data being selected by any Date criteria? Is the data being modified and so leaves the view by other means?

Check the server logs & talk to your admin & developers.

Collin

Subject: RE: Urgent :why the data from the view get automatically deleted

I used the SELECT fieldname!=""Is this the right way or I shall use

SELECT FORM=“formname”;

tell me which is the rigtt way

tell me asap

thanx