-
UpdateBatch with Joins
ok,
I'm using the updatebatch method, but as long as I have left outer joins (and full joins for that matter) in my querystring, the following error is generated :
[Insufficient key column information for updating or refreshing.]
In het Ado help there is mention of making use of the dynamic properties "Unique Table" and "Update Resync" to enable the updatebatch disregarding the joins in my query.
However, i'm having trouble implementing these dynamic properties and I don't seem to get rid of the error message.
Can anybody help me with this ?
thx
-
If you update with joined query, if i guess right, you can update data only to one table at time.
-
Thanks for your response oh1mie,
However, it seems that the error was not caused by the joins, but by the fact that one of the tables in my query did not have a primary key.
Found this after some digging and reading, so no need for dynamic properties anymore. My updatebatch works.
thx,
jAzz