Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remote View Data Duplication
Message
De
10/12/2023 07:40:01
Kato Ba
Bytex Technologies Limited
Kaduna, Nigéria
 
 
À
10/12/2023 05:01:30
Lutz Scheffler (En ligne)
Lutz Scheffler Software Ingenieurbüro
Dresden, Allemagne
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01687405
Message ID:
01687411
Vues:
38
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform