Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Incorrect syntax near '.'
Message
From
04/12/2012 14:32:29
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Incorrect syntax near '.'
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01558692
Message ID:
01558692
Views:
82
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
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place
Next
Reply
Map
View

Click here to load this message in the networking platform