How to use SQL Server Table-Data type, in Delphi, using FireDAC?

Viewed 604

For example:

I have a data-table type in SQL:

CREATE TYPE dbo.typTable1 AS TABLE
(
    Field1 INT NOT NULL,
    Field2 NVARCHAR(20) NULL
)

And a stored procedure in SQL, like this:

CREATE PROCEDRE dbo.prcTest
    @XDataTable dbo.typTable1 READONLY
AS
BEGIN
    .
    .
    .

And now problem!!! : When i send a table as parameter in delphi like this:

FireDACStoredProcedure.Params.ParamByName('@XDataTable').AsDataset := 
    FireDACMemTable;

And when i run this, an error accour that say not supported.

Please guide me...thanks to you so much...

1 Answers
Related