Reply to thread

Message: [QUOTE="Linas Petkevièius, post: 1419740"] 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 [/QUOTE]