fadyg
asked on
Delphi UDFs DLL using MsSql 2000
Hello,
I have been using Interbase 6.0 with Delphi 6.0. I used to build DLLs out of my functions to be used in Interbase SQL commands. Those UDFs are basically string functions. Recently I migrated to MsSql server (client request). All those UDFs are returning strange integer results instead of strings. I have tried replacing the string type definitions by PChars, but I still get the same result. Any opinion ?
I have been using Interbase 6.0 with Delphi 6.0. I used to build DLLs out of my functions to be used in Interbase SQL commands. Those UDFs are basically string functions. Recently I migrated to MsSql server (client request). All those UDFs are returning strange integer results instead of strings. I have tried replacing the string type definitions by PChars, but I still get the same result. Any opinion ?
Last Comment
hmm,
udf are as my point of knowledge a properitary addon for interbase,
for mssql you would this udfs recode into database Functions/procedures
meikl ;-)
udf are as my point of knowledge a properitary addon for interbase,
for mssql you would this udfs recode into database Functions/procedures
meikl ;-)
ASKER
You can register DLLs in MSSql server. And those function become available to use in SQL statements. The only weird thing is that returned values are erratic.
hmm,
i don't have mssql, but i would guess a change from cdecl to ... (not in mind yet)
could maybe then solve this
meikl ;-)
i don't have mssql, but i would guess a change from cdecl to ... (not in mind yet)
could maybe then solve this
meikl ;-)
ASKER
Already tried both: with and without cdecl. Both give same wrong result.
What is this other command (instead of cdecl) that you're talking about ?
Fady
What is this other command (instead of cdecl) that you're talking about ?
Fady
well, recherched a bit
Cdecl/stdcall/safecall
are the calling conventions, where is defined how the values are tranfered (in and out)
try stdcall
meikl ;-)
Cdecl/stdcall/safecall
are the calling conventions, where is defined how the values are tranfered (in and out)
try stdcall
meikl ;-)
ASKER
Sorry for being late answering this,
I tried the three of them... no luck.
However I came across the following tutorial:
Writing MS SQL Server Extended Stored Procedures with Delphi http://www.berenddeboer.net/article/1293/1293.html
I've tried it and preliminary tests show that it is working fine .
thanks
Fady
I tried the three of them... no luck.
However I came across the following tutorial:
Writing MS SQL Server Extended Stored Procedures with Delphi http://www.berenddeboer.net/article/1293/1293.html
I've tried it and preliminary tests show that it is working fine .
thanks
Fady
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Delphi
Delphi is the most powerful Object Pascal IDE and component library for cross-platform Native App Development with flexible Cloud services and broad IoT connectivity. It provides powerful VCL controls for Windows 10 and enables FMX development for Windows, Mac and Mobile. Delphi is your choice for ultrafast Enterprise Strong Development™. Look for increased memory for large projects, extended multi-monitor support, improved Object Inspector and much more. Delphi is 5x faster for development and deployment across multiple desktop, mobile, cloud and database platforms including 32-bit and 64-bit Windows 10.
60K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
- using Delphi 6 and MSSQL 2000