RS First Dynamics NAV Blog

...from NAV 3.60 to NAV 2013
Home Blogs | Home | Login | Contact | My Profile | RSS | About | Cerca

Executing a stored procedure from Navision

...very Simple... Define a NAV Automation Object Name   DataType   Subtype   Lengthconn   Automation   'Microsoft ActiveX Data Objects 2.8 Library'.Connection    CodeCREATE(conn);conn.Open('Provider=SQLOLEDB.1;Integrated Security=SSPI;Initial Catalog=[Servername];Data Source=[Databasename]');conn.Execute('EXEC StoreProcedureName');conn.Close;CLEAR(conn); Calling and Runnning WithADO_Conne.Execute({sp name}); NB: You can pa 
Leggi tutto il post...
martedì, 12 gen 2010 Ore. 19.02

Scrivi un commento

Non è possibile inviare commenti a questo Blog


Copyright © 2002-2007 - Blogs 2.0 | Home Page Blogs
ASP.NET 2.0 Windows 2003