SQL 2008 TVP

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
AlTu
Posts: 1
Joined: Thu 25 Feb 2010 15:33

SQL 2008 TVP

Post by AlTu » Thu 25 Feb 2010 15:45

Can you please tell me will you plan to add support for TVP in VCL?

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Mon 01 Mar 2010 12:55

As for now we have no plans to support TVP for SQL Server 2008.

Vladimir
Posts: 17
Joined: Fri 15 Aug 2008 18:09

Post by Vladimir » Wed 21 Apr 2010 13:11

TVP is very important and powerful feature of 2008 that needs support in SDAC. Not having support for this type forces me to use all sorts of workarounds like XML, and I get penalized on creation and parcing of it.

I have posted this question in the past. the answer I received then was that it will be considered in future versions and that has been when 2008 came out.

Please reconsider your stand on supporting this feature and implement it sooner than later.
Thank you.

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Fri 23 Apr 2010 13:56

We are investigating the possibility of adding this functionality. As soon as we solve this question we will let you know.

Vladimir
Posts: 17
Joined: Fri 15 Aug 2008 18:09

Post by Vladimir » Wed 09 Jun 2010 16:19

It is very encouraging to see that you have developed support for GEOMETRY, GEOGRAPHY, HIERARCHYID field types for SQL Server 2008.

Please consider raising priority to support table types, TPV.

For my company it is serious deficiency that hinders our use and success with SDAC. I have to resort to using XML for passing multi-row information, which is penalizing at both client and database, as it needs to be compiled on client and parsed in SQL.

Thank you for expediting this.

Vladimir

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Fri 11 Jun 2010 08:53

We are planning to support Table-Valued Parameters in the near several months.

Vladimir
Posts: 17
Joined: Fri 15 Aug 2008 18:09

Post by Vladimir » Tue 10 Aug 2010 21:43

Any progress on this TVP issue?
We are eagerly awaiting any news from you...

Please consider raising priority to support table types, TPV.

Thank you for expediting this.

Vladimir

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Fri 13 Aug 2010 13:32

We are investigating this functionality. We hope that it will be added in the near time.

Vladimir
Posts: 17
Joined: Fri 15 Aug 2008 18:09

Post by Vladimir » Thu 28 Oct 2010 13:20

How is your investigation going? Any concrete plans to add this feature?
Thanks for letting us know.
Vladimir

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Tue 02 Nov 2010 13:36

Unfortunately at present time we have some tasks of higher priority than supporting TVP, so we can not tell you the exact time when we provide such support.

Vladimir
Posts: 17
Joined: Fri 15 Aug 2008 18:09

Post by Vladimir » Wed 23 Feb 2011 16:41

Almost one yeart to date has passed since this request was posted. Any progress on TVP on your side?

Just a reminder that SQL Server 2008 was released and introduced this feature on August 6, 2008, 2 1/2 years ago.

Please inform those, who are eagerly waiting for this important feature, of your plans to support it.

Thank you
Vladimir

AndreyZ

Post by AndreyZ » Fri 25 Feb 2011 10:17

We have already started implementing TVP to SQL Server Data Access Components. We are planning to include this functionality into the next SDAC version.

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Wed 04 May 2011 08:13

Support for Table-Valued Parameters was added in the SDAC build version 5.10.0.6. You can find detailed information about it in the "Using Table-Valued Parameters" topic of SDAC help.

Post Reply