>When I call this stored procedure
>
>
>ALTER PROCEDURE [dbo].[GetNextMaster]
> @MasterID int
>
>AS
>BEGIN
> SET NOCOUNT ON;
>
> Select XPID, Category, DiffLet,alc,Keyword, Keyword2, CorrectResp, Script, stem,
> Cast(RespA as nVarchar(200)) as RespA, Cast(RespB as nVarchar(200)) as RespB, Cast(RespC as nVarchar(200)) as RespC,
> CAST(RespD as nVarchar(200)) as RespD, ScriptTime, EnterNotes, IncSave, EnteredBy, EnteredDate,
> Completd, DelFlag, DelReason from ExpMaster where XPID = @MasterID
>
>END
>
>
>from the form, I'm getting "Incorrect syntax near '.'" If I execute it from SMS it runs just fine.
>
>The command is
>
>ms1 = SqlExec(Thisform.r_conn, msql1 + m.params1, "EditRec")
>
>where msql1 = "Execute TestingExpECL..GetNextMaster ")
>and m.params1 = "0"
>
>I'm not seeing a '.' anywhere in there - what am I not seeing?
>
>thanks
>
>D
Is TestingExpECL the name of the database? Are you running this SP from another DB? If not, how about
execute dbo.GetNextMaster 0 (BTW, why did you name this SP GetNextMaster)?\
Also, you seem to be missing a space after procedure call and parameter.
If it's not broken, fix it until it is.
My Blog