I'm unable to update a field in the recordset and I receive the "insufficient base table information" error. I need to be able to update the "bridges_pts_threat.threatco"
field. I'm using a client side cursor with the following sql statement. Any suggestions? Thanks.
field. I'm using a client side cursor with the following sql statement. Any suggestions? Thanks.
Code:
strSQL = "SELECT usgsdata.current_ht, usgsdata.site_id, bridges_pts.uid, bridges_pts.bank_full, bridges_pts.ref_id,"
strSQL = strSQL & " bridges_pts.margin, bridges_pts_threat.threatco FROM usgsdata.dbf INNER JOIN bridges_pts.dbf"
strSQL = strSQL & " ON usgsdata.site_id = bridges_pts.ref_id INNER JOIN bridges_pts_threat.dbf"
strSQL = strSQL & " ON bridges_pts.uid = bridges_pts_threat.uid;"
'strSQL = "SELECT * From bridges_pts_threat.dbf"
openRS rs,strSQL,oConn,adOpenStatic,adLockOptimistic,adCmdUnknown