Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote View Data Duplication
Message
From
10/12/2023 07:40:01
Kato Ba
Bytex Technologies Limited
Kaduna, Nigeria
 
 
To
10/12/2023 05:01:30
Lutz Scheffler
Lutz Scheffler Software Ingenieurbüro
Dresden, Germany
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01687405
Message ID:
01687411
Views:
37
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
Map
View

Click here to load this message in the networking platform