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

Click here to load this message in the networking platform