Thank you JohnH I will look into the DOS error handling. I am not sure if people that create the batch files will know what needs to be done. The other alternative would be to find a way to submit the batch commands individually. I played with this idea in the beginning but I think I had similar...
Very good catch, You are right as I look back through the output I see the error messages are mixed with the standard output. I guess it confused me because the commands are listed in the proper order. How do I make it wait for the first command to finish before submitting the next? This will be...
I know this has been discussed a million times and I have a working program. I am allowing users to execute .bat file from a GUI. My application is simple it has a form with a split container with a list of bat file on one side and a textbox on the other. When the user clicks on a batch file the...
Sorry, Dont know why that didn't work but this time I am attempting to attach a sample zip with the database, Tech Guide, and sample data. You have my code above. Thanks Again
Thank you that would be great. I am only concerned about the notification file on pages 26-28 at this time. Whatever I come up with it has to be easy to maintain because they change the layout every few years and I have to be able to identify the fields and make the proper modifications. I have...
...daSnglSrc.Connection = New OleDb.OleDbConnection(conString)
Dim ds As New ImportACS300DataSet
'***********************************************
'**** Create Work Tables ***
'***********************************************...
...Dim totalread As Integer
Dim da As New OleDb.OleDbDataAdapter
Dim ds As New DataSet
Dim dt As New DataTable
' ***********************************************
' **** Create Work Tables ***
'...
Ok, Some progress, This code successfuly executes a batch file sending the output and Error messages to a strings.
Sub Execute_Batch_file(ByVal Batch_file As String)
On Error GoTo HandleErrors
Dim batchSuccessful As Integer
Dim ExitCd As Integer
Dim BatExec As...
...Dim StartPath As String = "\\MyServer\122nd_PA_PGM\Exstream_Submit\"
Dim ExstreamPath As String = "\\MyServer\ExstreamGMS\Bat\v8\"
'**********************************
' Set the watch Directory here
'**********************************
Dim DIR_NAME As String = StartPath &...
The error message was
Looking at the error message I see that I was mistaken on my first assessment the program returned the error message. I wonder if I could pipe this into a txt file then read it and determine if there was an error or at least put it in the email. Unless someone else can...
...for your help.
Imports System
Imports System.IO
Imports System.Timers
Imports System.Diagnostics
Imports System.Net.Mail
Module Module1
'**********************************
' Set the watch Directory here
'**********************************
Dim DIR_NAME As String =...
cjard thank you for your reply, Actually I found the anwser in the next lesson.
Dim authorQuery As ObjectQuery(Of Author) = publishContext.Author.Where("it.FirstName <> 'Mark'") only returns Aurthor's.
Dim authorQuery As ObjectQuery(Of Author) = publishContext.Author.Where("it.FirstName <>...
I am working through a tutorial I found on this fourm posted by mendhak in 2008. I am working on the second lesson and for some reason the code to return the number of Article's is always 0. I ran a query and the first two authors should have 2 articles each. is there some reason this does not...
I have a program that cycle’s every 15 minutes to check for .bat files that need to be run. After it executes the all the .bat files it finds it moves them to an archive directory. If the user made a mistake and needs to modify and resubmit a bat file, I need to run it and then replace the file...
...SELECT statement
dt = ds.Tables(0)
For Each dr In dt.Rows
CompCount = CompCount + 1
' **************************************************************
' * Update Records into the MS Access Fulfillment Database...
Is this a dumb question? I have not used the VB Development program a lot. I saw you can connect to a database while creating a console app but have never seen it done and cannot find anything conclusive on the internet.
Can some one look at this please.
I have created a console application that reads a file and updates a Access database. The Open works but i keep getting "Syntax error in INSERT INTO statment" when I try to insert a record. When I list the INSERT statment I get this
INSERT INTO...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.