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

Question

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

Forget your Delphi code for a moment: can you successfully invoke your prcTest from a TransactSQL script in SSMS? — MartynA
– MartynA, Commented May 13, 2017 at 12:17
Please do not post fake code like "CREATE PROCEDRE". Also is there any text missing before @XDataTable? — MartynA
– MartynA, Commented May 13, 2017 at 12:18
Hello dear MartinA...Sure...I will post entire code...thank you... — Vahid Momeny
– Vahid Momeny, Commented May 14, 2017 at 4:29

user6695319 · Accepted Answer · 2017-05-13 13:27:13Z

2

I am thinking something like that:

Set the DataType = ftObject;

Set datatypename = <your_procedureName>.<your_parameter>

With FireDACStoredProcedure.Params.ParamByName('@XDataTable') do
begin
DataType := ftObject;
DataTypeName := 'prcTest.@XDataTable';
end;

Inspired in https://delphiaball.co.uk/2016/04/29/interbase-array-fields-firedac/

answered May 13, 2017 at 13:27

user6695319

Sign up to request clarification or add additional context in comments.

1 Comment

Alec Over a year ago

@Vahid Accept answer

Collectives™ on Stack Overflow

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

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related