Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL2008 Merge
Message
From
25/08/2008 07:25:09
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL2008 Merge
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Database:
MS SQL Server
Miscellaneous
Thread ID:
01341455
Message ID:
01341455
Views:
64
Has anyone tried to use the new MERGE T-SQL Command of SQL Server 2008? I think it could be worth trying to make the Cursoradapter use MERGE commands triggered by Tableupdate(.T.) instead of single record INSERT/UPDATE/DELETE commands, although it would mean to implement the overhead of first sending (parts) of the Cursoradapter Cursor to SQL as #TEMP table and afterwards make the MERGE from there.

Do you have a better idea or already tried something?
Or do you see some ill logic when it comes to conflicting updates?
Is it really woth the hassle?

Bye, Olaf.
Reply
Map
View

Click here to load this message in the networking platform