Recordset not updated

[mthrawn]

I'm using JScript to create forms. In one of them, when I add a new record, I can't seem to get all fields in at once, when I try entering just one of the fields and using updateRecord() for the rest, the initial field (fom the addImmediate() command) goes in creating the new record, but when I input the others, only one field is entered, the rest appear to be ignored. I've tried setting all the fields then following with a updateRecord() and I've tried updating each individual field, both giving the same result. I've also tried putting all the setValue() in an onbeforeupdate() but that ignored all the update fields. AAARRRGGHH!

 

[palbano]

Dear mthrawn,

Your post is a bit vague but it sounds like you might want to use Recordset.AddNew() instead of Recordset.AddImmediate()

Hope this helps
-pete

 

[mthrawn]

Thanks palbano but I did manage to sort it out in the end using an addImmediate() coupled with an onbeforeupdate() function setting all the non-key fields then updating the recordset.