Using Table-Valued Parameters

[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.

[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.

[AndreyZ]

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

[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.

[Mahendrank]

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

[azyk]

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