Search results for query: *

  1. W

    Question Displaying DOS command erroroutput in a textbox

    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...
  2. W

    Question Displaying DOS command erroroutput in a textbox

    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...
  3. W

    Question Displaying DOS command erroroutput in a textbox

    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...
  4. W

    Question Update requires a valid Insert Command

    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
  5. W

    Question Update requires a valid Insert Command

    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...
  7. W

    Question Update requires a valid Insert Command

    ...daSnglSrc.Connection = New OleDb.OleDbConnection(conString) Dim ds As New ImportACS300DataSet '*********************************************** '**** Create Work Tables *** '***********************************************...
  8. W

    Question Update requires a valid Insert Command

    ...Dim totalread As Integer Dim da As New OleDb.OleDbDataAdapter Dim ds As New DataSet Dim dt As New DataTable ' *********************************************** ' **** Create Work Tables *** '...
  9. W

    Question Running DOS commands and checking responces

    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...
  10. W

    Question Running DOS commands and checking responces

    ...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 &...
  11. W

    Question Error checking shell comands in console applacations

    Thank you Herman I will try that
  13. W

    Question Error checking shell comands in console applacations

    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...
  14. W

    Question Error checking shell comands in console applacations

    ...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 =...
  15. W

    Data Entity Model question

    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 <>...
  16. W

    Data Entity Model question

    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...
  17. W

    Simple question about moving files

    That worked, Thanks
  19. W

    Simple question about moving files

    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...
  20. W

    Question Not getting the MyBuilder.getupdateCommand thing

    ...SELECT statement dt = ds.Tables(0) For Each dr In dt.Rows CompCount = CompCount + 1 ' ************************************************************** ' * Update Records into the MS Access Fulfillment Database...
  21. W

    Getting a syntax error on my INSERT statment

    As it turns out I used Count as a field name on my Table. Count being a reserved word the Insert failed. But thanks for the advice
  22. W

    Using Database explorer to connect to a Access 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.
  23. W

    Getting a syntax error on my INSERT statment

    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...
Back
Top