Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Incorrect syntax near '.'
Message
From
04/12/2012 15:38:48
 
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2008
Miscellaneous
Thread ID:
01558692
Message ID:
01558706
Views:
44
>>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.

When I run it straight from SMS, it runs fine, it's when I call it from my VFP form that I get this error, so how would I do that?
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform