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

2008-10-09 Thread Leigh Wanstead
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] Behalf Of Neven MacEwan Sent: Thursday, 9 October 2008 6:55 p.m. To: NZ Borland

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

2008-10-09 Thread Myles Penlington
Of course you can write a .NET assembly, to be either a function or stored procedure - there are plenty of examples on how to do this. For SQL2005 this would be the preferred method, if not using Transact SQL. COM would be your last option. Myles. -Original Message- From: [EMAIL

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

2008-10-09 Thread Leigh Wanstead
I currently only have license to write in Delphi 7. I assume that I can not write .NET assembly in Delphi 7 Enterprise, right? Have a nice day Regards Leigh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Myles Penlington Sent: Friday, 10 October 2008

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

2008-10-09 Thread Myles Penlington
I was thinking C# and Visual studio 2005 - not Delphi in this case. Myles. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Leigh Wanstead Sent: Friday, 10 October 2008 11:00 a.m. To: NZ Borland Developers Group - Delphi List Subject: Re: [DUG] How to

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

2008-10-09 Thread Neven MacEwan
Leigh Just write it as a std OLE Automation object and use To create an OLE Automation object Call sp_OACreate to create the object. Use the object. Call sp_OAGetProperty to get a property value. Call sp_OASetProperty to set a property to a new value. Call

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

2008-10-09 Thread Leigh Wanstead
In this case, I do have a license to use Visual Studio 2008 ;-) Have a nice day Regards Leigh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Myles Penlington Sent: Friday, 10 October 2008 11:11 a.m. To: NZ Borland Developers Group - Delphi List Subject:

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

2008-10-08 Thread Leigh Wanstead
Good afternoon, How to write udf for mssql server 2005 in Delphi 7? TIA Regards Leigh ___ NZ Borland Developers Group - Delphi mailing list Post: delphi@delphi.org.nz Admin: http://delphi.org.nz/mailman/listinfo/delphi Unsubscribe: send an email to

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

2008-10-08 Thread Neven MacEwan
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