I tried this but it is not working.kindly assist
CREATE PROCEDURE EngineTimesSp1
-- Add the parameters for the stored procedure here
@AircraftReg nvarchar(12),
@EngineNo int,
@CumEngCycles float output,
@CumEngHrs float output
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
...
Evelyne
Last Activity: Feb 25 '11, 11:33 AM
Joined: Feb 23 '11
Location:
-
Evelyne started a topic How can I use output parameters to return some values from database usin sql server?in SQL ServerHow can I use output parameters to return some values from database usin sql server?
-
Evelyne started a topic Am running the code below to create user login form.type mismatch error occur why?in AccessAm running the code below to create user login form.type mismatch error occur why?
Private Sub cmdOK_Click()
Dim cn As New ADODB.Connectio n
Dim obj As New ADODB.Command
Dim rst As New ADODB.Recordset
On Error GoTo Err_Handler
Set cn = CurrentProject. Connection
With obj
.ActiveConnecti on = cn
.CommandText = "LogComparePass word"
.CommandType = adCmdStoredProc
End With
'validate the username and...
No activity results to display