General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi,
For all I know, there is an SQL Update strategy named "Delete and Insert".
Do the old records get deleted?
If no, is something stopping them to bet deleted, like a Trigger or whatever can block server side?
I have not used Views for ages - and I recommend CursorAdapter instead of View - but at least the CA has something like UpdateStrategy. And since the CA somehow is mirrored in the DBSetProp, check this.
Lutz
Hi Lutz,
I tried the SQL Update strategy named "Delete and Insert" and the old records don't get deleted. I also don't have any sort of trigger on the table. I am not able to wrap my head around what is happening.
I have never used a CursorAdapter before. What do you think could be blocking the old records from being deleted?
Alex
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only