<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Leigh <br>
<br>
Just write it as a std OLE Automation object and use<br>
<b>To create an OLE Automation object</b>
<ol>
<li>Call <b>sp_OACreate</b> to create the object.</li>
<li>Use the object.
<ul>
<li>Call <b>sp_OAGetProperty</b> to get a property value.</li>
<li>Call <b>sp_OASetProperty</b> to set a property to a new
value.</li>
<li>Call <b>sp_OAMethod</b> to call a method.</li>
<li>Call <b>sp_OAGetErrorInfo</b> to get the most recent error
information.</li>
</ul>
</li>
<li>Call <b>sp_OADestroy</b> to destroy the object.</li>
</ol>
<hr><br>
<br>
<blockquote
cite="mid:NEENIGOFJDMGFNLCIIKIIEDIFBAA.leighw@softtech.co.nz"
type="cite">
<pre wrap="">Hi Neven,
Any url to how to write in Delphi do it as a com object to mssql 2005 for
user defined function?
Have a nice day
Regards
Leigh
-----Original Message-----
From: <a class="moz-txt-link-abbreviated" href="mailto:delphi-bounces@delphi.org.nz">delphi-bounces@delphi.org.nz</a>
[<a class="moz-txt-link-freetext" href="mailto:delphi-bounces@delphi.org.nz">mailto:delphi-bounces@delphi.org.nz</a>]On Behalf Of Neven MacEwan
Sent: Thursday, 9 October 2008 6:55 p.m.
To: NZ Borland Developers Group - Delphi List
Subject: Re: [DUG] How to write udf for mssql server 2005 in Delphi?
Leigh
You can either write a function in Transact SQL or if you do insist on
writing in Delphi
do it as a com object
HTH Neven
</pre>
<blockquote type="cite">
<pre wrap="">Good afternoon,
How to write udf for mssql server 2005 in Delphi 7?
TIA
Regards
Leigh
_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: <a class="moz-txt-link-abbreviated" href="mailto:delphi@delphi.org.nz">delphi@delphi.org.nz</a>
Admin: <a class="moz-txt-link-freetext" href="http://delphi.org.nz/mailman/listinfo/delphi">http://delphi.org.nz/mailman/listinfo/delphi</a>
Unsubscribe: send an email to <a class="moz-txt-link-abbreviated" href="mailto:delphi-request@delphi.org.nz">delphi-request@delphi.org.nz</a> with Subject:
</pre>
</blockquote>
<pre wrap=""><!---->unsubscribe
</pre>
<blockquote type="cite">
<pre wrap="">
</pre>
</blockquote>
<pre wrap=""><!---->
_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: <a class="moz-txt-link-abbreviated" href="mailto:delphi@delphi.org.nz">delphi@delphi.org.nz</a>
Admin: <a class="moz-txt-link-freetext" href="http://delphi.org.nz/mailman/listinfo/delphi">http://delphi.org.nz/mailman/listinfo/delphi</a>
Unsubscribe: send an email to <a class="moz-txt-link-abbreviated" href="mailto:delphi-request@delphi.org.nz">delphi-request@delphi.org.nz</a> with Subject:
unsubscribe
_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: <a class="moz-txt-link-abbreviated" href="mailto:delphi@delphi.org.nz">delphi@delphi.org.nz</a>
Admin: <a class="moz-txt-link-freetext" href="http://delphi.org.nz/mailman/listinfo/delphi">http://delphi.org.nz/mailman/listinfo/delphi</a>
Unsubscribe: send an email to <a class="moz-txt-link-abbreviated" href="mailto:delphi-request@delphi.org.nz">delphi-request@delphi.org.nz</a> with Subject: unsubscribe
</pre>
</blockquote>
<br>
</body>
</html>