Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CA, SQL Server Datetime issue with Buffering
Message
De
18/08/2006 14:07:10
 
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
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01146148
Message ID:
01146816
Vues:
15
>Also I found another solution on the UT that also helped us achieve what we want. Right after we 'condition' the date fields, we run the following:
>
>WITH THIS
>    llSendUpdates = .SendUpdates
>    .SendUpdates = .F.
>    TABLEUPDATE(.T., .T., lcAlias)
>    .SendUpdates = llSendUpdates
>ENDWITH
>
>The above will 'commit' the cursor without sending updates to SQL which is also a behavior we want.
>

Hi Michael,

Note that committing the changes locally may cause TABLEUPDATE() failures later, when you try to commit changes to the data source. CursorAdapter may fail to find the record on the server.

Thanks,
Aleksey.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform