Using Table-Valued Parameters

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
markdelphi
Posts: 16
Joined: Sat 08 Sep 2012 19:43

Using Table-Valued Parameters

Post by markdelphi » Mon 10 Sep 2012 18:34

Hello:

I'm testing the type parameters table. Use the example in the documentation, but when I run it generates an exception.
I am working with the trial version of SDAC is the 6.2.8 for Delphi 2010
The error that sent me is: "Invalid class typecast"
I followed the following steps:
1. Create DeptTableType defined type.
2. Then the table DEPT
3. The following stored procedure: SP_InsertDept
4. Then in Delphi paste the necessary components: MSConnection, MSTableData and MSStoredProc.
5. Copy and paste the code in the example.

I do not know what happens.

AndreyZ

Re: Using Table-Valued Parameters

Post by AndreyZ » Tue 11 Sep 2012 14:17

Hello,

Thank you for the information. This problem exists only in SDAC Trial Edition. We are investigating this problem. As soon as we have any results we will let you know.

AndreyZ

Re: Using Table-Valued Parameters

Post by AndreyZ » Fri 19 Oct 2012 11:26

We have fixed this problem. This fix will be included in the next SDAC build.

Mahendrank
Posts: 2
Joined: Fri 27 Jun 2014 10:07

Re: Using Table-Valued Parameters

Post by Mahendrank » Fri 27 Jun 2014 10:19

There is a similar issue in version 6.10.20 and XE2.
I am using trial version.
The statement 'MSTableData1.Open;' fails with error message is 'Table does not exists'.
I am following the steps as said.

Mahendrank
Posts: 2
Joined: Fri 27 Jun 2014 10:07

Re: Using Table-Valued Parameters

Post by Mahendrank » Fri 27 Jun 2014 11:11

Got solution.
Setting MsConnection->Options->Provider = prNativeClient solved the problem.
Thanks to AndreyZ

azyk
Devart Team
Posts: 1058
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: Using Table-Valued Parameters

Post by azyk » Fri 27 Jun 2014 15:37

If there is anything else I can help you with, please contact me.

Post Reply