How to change company in Baan script from one company to another

I need to check record in other company , if not found must insert a record into it

I need to check record in other company , if not found must insert a record into it

Hello,

long switch.to.company( long new_compnr )

Regards

if u need to check if a record is present in a table in some other comp and if not present use following logic :

select <table_name>.field1
from <table_name>
where <table_name>._index1 = {Condition}
and <table_name>._compnr = :your_comp_var
selectdo
selectempty
<table_name>.field1 = value
<table_name>._compnr = your_comp_var
db.insert(t<table_name>,db.retry)
endselect
commit.transaction()