Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Microsoft's response on VFP Advanced
Message
From
19/12/2018 12:55:22
Walter Meester
HoogkarspelNetherlands
 
 
General information
Forum:
Visual FoxPro
Category:
Contracts, agreements and general business
Miscellaneous
Thread ID:
01664566
Message ID:
01664654
Views:
74
>>True, and since we remain compatible with SQL 2005 (I hope to be able to move that to SQL 2008R2 soon) I still can't use it
>>
>>SQL Server historically has been slow in adopting features that we all needed for a long time. The ability to process recursive querys came in 2005, Sequential IDs only in 2012 and the list_aggr() only in 2017 while all other popular RDBMSs' had such a feature for a long time.
>
>There's no question, we've seen a pattern for a long time:
>
>- A core feature might exist in other database engines but not in MS SQL Server
>- Developers will roll their own solutions/workarounds
>- MS SQL will, years later, implement the core feature
>
>The sequence object was one. Another one is Change Data Capture, which largely (but not completely) means you don't need to use triggers for audit trails. There are others as well.

I did look at that one, but it did not really fit my needs as we store additional information about who the user is, a session identifier and some other columns.
I confess that I did not look into it too deeply, but perhaps you can elaborate your view on this feature.

Walter,
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform