Hi there,
quick question here, just wondering if smartobject can handle Table Datatype input parameter in sql service object?
getting tired writing one by one column for input in storedprocedure here and wondering if smartobject can handle the table datatype input :)
Thx
It is not supported. Every time I've needed a DataTable input parameter for a stored procedure, I have just written a custom service object method. There is initial upfront development cost, but the performance benefits moving forward are sometimes worth it. An alternative approach is to pass in a delimited string as a varchar input parameter. Depending on what your stored procedure actually does, this might suffice and not have a negative performance hit.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.