Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access_asp thread: Update Database


Message #1 by "sami" <rsumathy@e...> on Thu, 2 Aug 2001 20:17:27
 Hi 

This is my code for to update(add new or edit)record into database but 

some computer is working fine some are give me error  in 

this line oRecordSet.AddNew; the error is JScript runtime error or 

oRecordSet.AddNew line not support



could any body can help me with is.(my guss is the driver but I am not 

sure) 





strSQL = "SELECT * FROM " +sTableName+" WHERE 0=1;" oRecordSet.Open 

(strSQL, oConnection, adOpenKeyset, adLockPessimistic, adCmdText); 

oRecordSet.AddNew; 

if (NUType == "subSystem"){ 

oRecordSet(1) = Name; 

oRecordSet(2) = Description; 

oRecordSet.Update; 




  Return to Index