Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Incorrect syntax near '.'
Message
De
04/12/2012 14:32:29
 
 
À
Tous
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Titre:
Incorrect syntax near '.'
Versions des environnements
SQL Server:
SQL Server 2008
Divers
Thread ID:
01558692
Message ID:
01558692
Vues:
81
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform