>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
Run SQL Server Profiler and see what is executed on SQL Server.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.