How to write a extended stroed procedure of MS SQL 2K by Delphi

james_liu

Delphi Developer

Thu, 09 Sep 2004 21:12:45 GMT

How to write a extended stroed procedure of MS SQL 2K by Delphi

The source code make a dll file ,but it can transfer parameter to the
function xp_min by SQL Query Analyzer
example : exec xp_min 23 , it return -2147418113.
Where I mistake

------------------------------------------

library mdll;
uses SysUtils,
Classes , dialogs;
{$R *.RES}
function xp_min(var X : Integer): Integer; //stdcall ;//safecall
begin
xp_min := X
end;

exports
xp_min;

end.

Team

Delphi Developer

Fri, 10 Sep 2004 01:10:35 GMT

Re:How to write a extended stroed procedure of MS SQL 2K by Delphi

Quote

In article <3c9dd128_2@dnews>, James_liu wrote:
> The source code make a dll file ,but it can transfer parameter to the
> function xp_min by SQL Query Analyzer
> example : exec xp_min 23 , it return -2147418113.
> Where I mistake

Looks like a typical calling convention mismatch. You have to use either
stdcall or cdecl, probably stdcall. Oh, and drop the Var. Whether you need
it or not depends on how you have declared the function for SQL server.
Without seeing that its impossible to say.

--
Peter Below (TeamB)
Use the newsgroup archives :
http://www.mers.com/searchsite.html
http://www.tamaracka.com/search.htm
http://groups.google.com
http://www.prolix.be

Tomislav Kard

Delphi Developer

Mon, 20 Sep 2004 19:10:10 GMT

Re:How to write a extended stroed procedure of MS SQL 2K by Delphi

Hi james_liu!

On Sun, 24 Mar 2002 21:12:45 +0800, "james_liu"

Quote

<james_...@ms22.url.com.tw> wrote:
> The source code make a dll file ,but it can transfer parameter to the
>function xp_min by SQL Query Analyzer
>example : exec xp_min 23 , it return -2147418113.
>Where I mistake

>------------------------------------------

>library mdll;
>uses SysUtils,
> Classes , dialogs;
>{$R *.RES}
>function xp_min(var X : Integer): Integer; //stdcall ;//safecall
>begin
>xp_min := X
>end;

>exports
>xp_min;

>end.

You can not make extended stored procedures like that. There is a
whole "Open Data Services" interface to communicate with SQL server
from inside of delphi. The whole thing is little similar to writing C
functions to be used in old dos Clipper.

Somebody have made a wrapper for extended stored procedures, and I
hapend to download that some time ago. It was for a MSSQL 6.5, but I
expect it to work with 2000, you would have to try.

In case you are interested to get this I have sent xps.zip for you to
attachements conference...

tomi.

Marc Scheune

Delphi Developer

Mon, 20 Sep 2004 22:45:51 GMT

Re:How to write a extended stroed procedure of MS SQL 2K by Delphi

Quote

> The source code make a dll file ,but it can transfer parameter to the
>function xp_min by SQL Query Analyzer

Check out this site - it has an article, slides and sample code to
show you how to create your SQL Server extended stored procs in
Delphi:

http://berend.gameren.nl/delphi/index.html

Marc

------------------------------------------------------------------------
Marc Scheuner Software Engineer
Quest Software Canada Halifax, Nova Scotia, Canada
Email: marc.scheu...@quest.com http://www.quest.com

Other Threads

1. MS-SQL Stroed Procedure

2. Delphi DLL and MS-SQL Extended Stored Procedures

3. MS SQL 6.5 Extended Stored Procedures with Delphi

4. MS SQL Server 6.0 Extended Stored Procedures

5. MS SQL Server Extended Stored Procedures and the Open Data Services API

6. How to create extended stored procedures for MS SQL 7.0

7. How to create extended stored procedure for MS SQL 7.0

8. MS SQL Server Extended procedure

9. extended stored procedures for MS SQL 6.5

10. MS SQL 7.0 Extended Stored Procedures