ROWID for LeftJoin query

[Ajay Bhosle]

I have a Query which is a Left Join with another table. There is one primary table from which all records are fecthed and the other table has the matching records. The updating table is the secondary table and hence the rowid is of the secondary table. The ROWID will be empty for the records which do not have macthing records in the primary table.

I had overridden the ApplyRecord to insert the record in the secondary table if the user tries to modify any column in the row which does not have a ROWID and return the rowid in the NEWROWID variable. I am setting the cacheupdate property to true and use the ApplyUpdates to commit the records, now when the ApplyUpdates is called it again calls the ApplyRecord procedure with the ROWID for the record as empty

My Question is why is the rowid empty when i had already provided the rowid in the ApplyRecord procedure when the user tries to modify the record which does not have a rowid

 

[Marco Kalter]

The rowid is only set when a new record is inserted into the dataset. In this case the dataset record is updated, and therefore the new rowid is not applied to the dataset record.