Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Incorrect syntax near '.'
Message
De
04/12/2012 15:38:48
 
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:
01558706
Vues:
43
>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform