Issue in creating a temporary recordset

tell_siva
01-13-2004, 01:49 PM
Hi ,
I am trying to create a tempary recordset with following fields..
Is there any error in the syntax below..
I am getting error..


Set rst_TempRecs = New adodb.Recordset

With rst_TempRecs.Fields
.Append "CAL1", adInteger
.Append "CUS1", adInteger
.Append "CMP1", adInteger
end with

rst_TempRecs.Update


pls let me know...

00100b
01-13-2004, 01:57 PM
Try removing the Update statement.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum