CODEWITHSUNDEEP
sql-serverdelphisql-server-2008user-defined-functions
UnDiUdin
UnDiUdin

Reputation: 15394

Is it possible to create a SQL Server UDF with Delphi for win32?

I store files in blobs (using SQl Server filestream).

I stored them zipping them (with Zipforge Delphi component).

I'd need to allow some users retrieveing the files with a simple query and obtaining them already unzipped.

So I would like to have a UDF called RetrieveFile with a single ID as parameter. This function returns a BLOB that is a not zipped file.

Is it possible to do this in Delphi or I must use .NET?

Upvotes: 2

Views: 630

Answers (1)

user532231
user532231

Reputation:

You need CLR stored procedure to do this and in pure Delphi is impossible to create the assembly. However you can use Delphi Prism to develop it. Check out this article written by RRUZ.

Upvotes: 3

Related Questions