?
=?windows-1257?Q?Linas_Petkevi=E8ius?=
Hallo,
For example i have a user defined function:
ALTER FUNCTION RectangleArea (@Width int, @Height int ) RETURNS int AS BEGIN RETURN ( @Width * @Height ) END
I tried to use this function in this example, but it does not works
___________________________________
Dim cn As New ADODB.Connection
Dim cmd As New ADODB.Command
Dim rs As New ADODB.Recordset
cn.Open CurrentProject.Connection
Set cmd.ActiveConnection = cn
cmd.CommandText = "select rectangleArea(10, 20)"
Set rs = cmd.Execute
msgbox rs.Fields(0)
__________________________________
But if i put getdate() or other system function, everything is ok. ;(( How can i solve this ?
Linas
For example i have a user defined function:
ALTER FUNCTION RectangleArea (@Width int, @Height int ) RETURNS int AS BEGIN RETURN ( @Width * @Height ) END
I tried to use this function in this example, but it does not works
___________________________________
Dim cn As New ADODB.Connection
Dim cmd As New ADODB.Command
Dim rs As New ADODB.Recordset
cn.Open CurrentProject.Connection
Set cmd.ActiveConnection = cn
cmd.CommandText = "select rectangleArea(10, 20)"
Set rs = cmd.Execute
msgbox rs.Fields(0)
__________________________________
But if i put getdate() or other system function, everything is ok. ;(( How can i solve this ?
Linas