Take all the rowid

[discusmania]

hi guys....
just wondering why when i try to open edit form from the list base on rowid, the program take all rowid in the list, not only the selected record.so the edit form cannot be open . the error is:

SELECT entry_id,Line_name, Date_Enter,Rej_ctgry,Rej_Desc,Cur_Dpku,Proj_Dpku,Rej_Stat,Stat_Date,Resp,Cause,corr_act,attachment,product,cur_dt,proj_dt,url,requestor,req_action,run_no,imp_bf,imp_af,date_close, rowid FROM AISTEST WHERE rowid='AAAAsPAADAABHLcAAM, AAAAsPAADAABHLeAAB, AAAAsPAADAABHLeAAC, AAAAsPAADAABHLeAAD, AAAAsPAADAABHLeAAE, AAAAsPAADAABHLfAAD, AAAAsPAADAABHLgAAF, AAAAsPAADAABHLgAAE'
EDIT ACTION ITEM

Microsoft OLE DB Provider for Oracle error '80020009'

ORA-01410: invalid ROWID

?

where there's 8 records on the viewlist criteria


thanks for the help

 

[RobV]

Try using:

WHERE rowid='AAAAsPAADAABHLcAAM'
or rowid='AAAAsPAADAABHLeAAB'
or rowid='AAAAsPAADAABHLeAAC'

etc..
Yours,

Rob.