Page 1 of 1

Using Table-Valued Parameters

Posted: Mon 10 Sep 2012 18:34
by markdelphi
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.

Re: Using Table-Valued Parameters

Posted: Tue 11 Sep 2012 14:17
by AndreyZ
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.

Re: Using Table-Valued Parameters

Posted: Fri 19 Oct 2012 11:26
by AndreyZ
We have fixed this problem. This fix will be included in the next SDAC build.

Re: Using Table-Valued Parameters

Posted: Fri 27 Jun 2014 10:19
by Mahendrank
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.

Re: Using Table-Valued Parameters

Posted: Fri 27 Jun 2014 11:11
by Mahendrank
Got solution.
Setting MsConnection->Options->Provider = prNativeClient solved the problem.
Thanks to AndreyZ

Re: Using Table-Valued Parameters

Posted: Fri 27 Jun 2014 15:37
by azyk
If there is anything else I can help you with, please contact me.