Re: [DUG] How to write udf for mssql server 2005 in Delphi?

Thu, 09 Oct 2008 15:14:41 -0700

Leigh

Just write it as a std OLE Automation object and use
To create an OLE Automation object
  1. Call sp_OACreate to create the object.
  2. Use the object.
    • Call sp_OAGetProperty to get a property value.
    • Call sp_OASetProperty to set a property to a new value.
    • Call sp_OAMethod to call a method.
    • Call sp_OAGetErrorInfo to get the most recent error information.
  3. Call sp_OADestroy to destroy the object.


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: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]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
  
Good afternoon,

How to write udf for mssql server 2005 in Delphi 7?

TIA

Regards
Leigh

_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: [email protected]
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to [EMAIL PROTECTED] with Subject:
    
unsubscribe
  

    

_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: [email protected]
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to [EMAIL PROTECTED] with Subject:
unsubscribe


_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: [email protected]
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to [EMAIL PROTECTED] with Subject: unsubscribe


  

_______________________________________________
NZ Borland Developers Group - Delphi mailing list
Post: [email protected]
Admin: http://delphi.org.nz/mailman/listinfo/delphi
Unsubscribe: send an email to [EMAIL PROTECTED] with Subject: unsubscribe

Reply via email to