Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Insert-update-replace-update doesn't work
Message
De
27/10/2016 18:45:24
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
27/10/2016 05:07:13
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
MS SQL Server
Virtual environment:
VirtualBox
Divers
Thread ID:
01642269
Message ID:
01642416
Vues:
34
>>The changes aren't written to the SQL on newly inserted records, but are on the records which existed.
>>
>>I'll eventually catch the time to revisit this and check the error codes and whether the adapter tried to insert the same record twice or what.
>
>Table has a first buffer record level that it is flushed with a record move.
>With a go to recno() you can force this flush into the table buffer.

Back in the day we used a skip 0 for the same effect. Not sure it would change the record's status in the case of a SPT cursor with cursoradapter, but then why not. I was thinking of that but then thought I won't need it, this job is done already.

But, of course, the customer forgot to tell me they wanted yet another column they didn't provide the first time, so, well, I'll soon check the theories :).

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform