Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.
Private Sub ButSave_Click() Dim intReturn As Integer 'Retrieve an ADO Connection for the current user Set cn = UserInfoGet.CreateADOConnection 'Set the current Database company cn.DefaultDatabase = UserInfoGet.IntercompanyID cmd.ActiveConnection = cn 'Get next note id and then insert batch record strsql = "DECLARE @I_sCompanyID smallint, @O_mNoteIndex numeric(19,5), @O_iErrorState int; " & _ "select @I_sCompanyID = CMPANYID from DYNAMICS..SY01500 where INTERID = 'TEST4'; " & _ "exec DYNAMICS.[dbo].[smGetNextNoteIndex] @I_sCompanyID, 1, @O_mNoteIndex output, " & _ "@O_iErrorState output; SELECT @O_mNoteIndex" cmd.CommandText = strsql cmd.Execute intReturn MsgBox (intReturn) End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.