i have two seperate queries:
1) i want to delete a record from a table existing in different company having same table definition.
If the table definition are same across companies means companies are attached to same package combination. In this case, you can simply delete the record across comapnies by using <tablename>._compnr in your select query , e.g., As given by kbabu1 in earlier thread :
db.retry.point()
select tcibd001.*
from tcibd001 for update
where tcibd001._index1={i.item}
and tcibd001._compnr=100
selectdo
...
if dal.destroy()/dal.update() = 0 then
commit.transaction()
else
abort.transaction()
endif
...
endselect
2) i want to delete a record from a table existing in different company having different table definition.
If table definition are different for different companies means the companies are attached to different package combinations. In this case you can still delete the records in the table using the above code provided the fields which you have specified in the select query should be present in all the table definitions, or if u r using index to select the record, then index field shuld be same in all companies..