I can select a recordset with a WHERE CLAUSE based on 2 databases
and update records. It works when i select the fields
from only 1 database Example project.* See Example

IF i make the same selection with 2 databases project.*, rela.*
I can not update anymore.

I only need the second database for display.
Does someone has a solution

Kind regards

Jan Dorresteijn


Example
lSql = "Select project.* from project,rela ;
WHERE prtype=type and prcode=rcode and ;
rela.zbedr LIKE 'BAS%' "

*** This works fine
*** If i select more fields it is going wrong
*** Project.*, rela.*
*** Project.* rela.bedr AS bedr


Recordset.open(lSql,lConnection,1,2)
Recordset.movefirst

? RecordSet.fields('Prcode').value
? RecordSet.fields('pkomschr').value
? RecordSet.fields('pzcode').value

*RecordSet.fields('pzcode').value = "TEST"
recordset.update