Hi,
I am using LLBL Version 4.2 Final and working with .Net 4.0 with VS 2015 and a SQL 2008 Server.
There is a stored procedure designed that requests a String, DataTable, DataTable as input Parameters. The DataTables have been defined as User-Defined Table Types that have one column defined as Ints.
USE [EMA]
GO
/****** Object: UserDefinedTableType [dbo].[INTTable] Script Date: 7/20/2016 7:16:04 AM ******/
CREATE TYPE [dbo].[INTTable] AS TABLE(
[INTValue] [int] NOT NULL,
PRIMARY KEY CLUSTERED
(
[INTValue] ASC
)WITH (IGNORE_DUP_KEY = OFF)
)
GO
The procedure is defined as:
ALTER PROCEDURE [EMA].[LFAByPaymentTypeReport]
@ReportDate VARCHAR(10) = NULL
, @ClientList INTTable READONLY
, @TypeOfPaymentMethodsList INTTable READONLY
When I run the designer and include this stored procedure it returns the types as for the parameters as String, String, String.
I tried editing the stored procedure and setting the Type to "object (System.Object)" and then it errors indicating that I need a TypeConverter. Created a generic typeconverter and it is being loaded by LLBL successfully. I added the TypeConverter in the Settings and defined the type "Rel. model data .NET Type" to System.Object and pointed to my TypeConverter.
Okay, the TypeConverter to use is always coming up as "None". I am kind of at a loss. How can I have the designer recognize the types as Datatable inputs (or at least objects) and let me pass in the correct parameter types?
Thanks in advance for any help.