ORA-01403 No Data Found

[mitch77]

Hi,
Why the following error appears??
ORA-01403 No Data Found

I am develope an application, using ASP.

This is a sample code:

Set OraInsert=Database.dbCreateDynaset("Select * from Contactosclientes",cint(0))
Database.LastServerErrReset
On error Resume Next
Orainsert.AddNew
OraInsert.Fields("id&quot.value = id OraInsert.Fields("name&quot.value = name
OraInsert.Fields("age&quot.value = age OraInsert.Fields("phone&quot.value = phone
OraInsert.Update

Thanks, Mitch

 

[MikeJones]

I'm not an ASP Person but you normally get this error when you expect to retrieve data but don't for example you reteive a record to edit but none is found matching your query criteria. In you r example if you log on to the DB via sqlplus and execute your query 'Select * from Contactosclientes' do you get any rows back? the error message seems to suggest that you wouldn't.