This is the error I receive when trying to submit a new record, and higlights this code
call rs.Open("SELECT @@IDENTITY As NewRecID", myCon)
nRecID = CStr(rs("NewRecID"))
call rs.Close

which is obviously the code creating new RecordID as new records are added.
I don't really have a control over creating this number it gets allocated,right?

Could somebody give me an advice as what should I be looking for,this has worked in the past and not sure when exactly it stopped working.

Thanks a lot everybody

okie, that select statement if current returning null and you are trying to convert it to a string and thus your error.

@@IDENTITY returns the last-inserted identity value. Is the record that you are inserting using an identity column?? If not that would likely return a null.

I assume this follows straight after an insert statement yes?

edit: just checked, null is returned if no identity column was used in the last insert

Yes you are correct,that is what i have realised it is null, because INSERT code before that is not executing but I can't see why, debugging the code shows, all the values as expected,have gone through all the field names, it updates correctly but not saving a newly submitted record.

pain in the a..

have you tried executing to code directly against the database??

can you explain a bit more,just like everything else my debuggin skills=VERY LIMITED

grab the sql the you are sending to the database to insert the record by doing a response.write on the line before you execute it.

copy the sql and go to the database in the query analyzer and paste the sql in. then execute the statement in the analyzer.

that way you might see what is happening.

Why didn't you say so, smart man, will do.
Ta

will let you know tomorrow how it went, have to nick out now

no worries, should at worse show the problem or rule out the sql as an issue

Thanks for your idea, the problem was that INSERT statement didn't like the order of some fields because the varchar submitted was trying to save as a field int so once i got that sorted it is cool.

I am learning so much.

Ta

excellent, glad I could help.