Click here to Skip to main content
15,886,816 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionStart another process as admin Pin
Dominick Marciano15-Apr-14 3:52
professionalDominick Marciano15-Apr-14 3:52 
AnswerRe: Start another process as admin Pin
Bernhard Hiller15-Apr-14 22:25
Bernhard Hiller15-Apr-14 22:25 
GeneralRe: Start another process as admin Pin
Dominick Marciano16-Apr-14 8:22
professionalDominick Marciano16-Apr-14 8:22 
GeneralRe: Start another process as admin Pin
Dave Kreskowiak16-Apr-14 9:41
mveDave Kreskowiak16-Apr-14 9:41 
AnswerRe: Start another process as admin Pin
helfetho17-Apr-14 0:56
helfetho17-Apr-14 0:56 
GeneralRe: Start another process as admin Pin
Dominick Marciano17-Apr-14 4:35
professionalDominick Marciano17-Apr-14 4:35 
GeneralRe: Start another process as admin Pin
helfetho17-Apr-14 5:48
helfetho17-Apr-14 5:48 
QuestionNo value given for one or more required parameters. Pin
jkirkerx14-Apr-14 12:16
professionaljkirkerx14-Apr-14 12:16 
I've been working on this for over an hour now. I get the "No value given for parameter" message on exception
If I take the WHERE statement out, it works fine. If I replace the value in the parameter with a hard coded date, I get the error as well. I added a watch to the command, and I can see the parameter attached with the value.

It's an old foxpro / clipper database, so maybe I need to make some adjustments.

Public Function load_am_Invoices( _
        ByVal p_currentDate As DateTime) As Integer

        Dim dwExitCode As Integer = 2
        Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=D:\amp\sis1; Extended Properties=dBASE IV"
        Dim queryString As String = _
        "SELECT * " & _
        "FROM ARCUS01.dbf " & _
        "WHERE FORDATE=@startDate"

        Dim connection As New System.Data.OleDb.OleDbConnection(connString)
        Dim command As New System.Data.OleDb.OleDbCommand(queryString, connection)

        Dim paramStartDate As System.Data.OleDb.OleDbParameter
        paramStartDate = New System.Data.OleDb.OleDbParameter("@startDate", OleDbType.DBDate)
        paramStartDate.Value = p_currentDate
        command.Parameters.Add(paramStartDate)

        Try

            connection.Open()
            Dim reader As System.Data.OleDb.OleDbDataReader = command.ExecuteReader()
            While reader.Read()

            End While

            reader.Close()
            connection.Close()

        Catch ex As Exception
            dwExitCode = 1

        End Try


        dwExitCode = 0

        Return dwExitCode

    End Function

Answer[SOLVED] Pin
jkirkerx14-Apr-14 12:34
professionaljkirkerx14-Apr-14 12:34 
GeneralRe: [SOLVED] Pin
Tim Carmichael15-Apr-14 2:04
Tim Carmichael15-Apr-14 2:04 
GeneralRe: [SOLVED] Pin
jkirkerx15-Apr-14 6:32
professionaljkirkerx15-Apr-14 6:32 
QuestionRe: how to import all csv files in a drive to database ? Pin
sensizbenlik14-Apr-14 10:10
sensizbenlik14-Apr-14 10:10 
GeneralRe: how to import all csv files in a drive to database ? Pin
PIEBALDconsult14-Apr-14 10:40
mvePIEBALDconsult14-Apr-14 10:40 
AnswerRe: how to import all csv files in a drive to database ? Pin
Wes Aday14-Apr-14 11:14
professionalWes Aday14-Apr-14 11:14 
GeneralRe: how to import all csv files in a drive to database ? Pin
sensizbenlik14-Apr-14 14:25
sensizbenlik14-Apr-14 14:25 
GeneralRe: how to import all csv files in a drive to database ? Pin
Wes Aday14-Apr-14 14:53
professionalWes Aday14-Apr-14 14:53 
GeneralRe: how to import all csv files in a drive to database ? Pin
sensizbenlik14-Apr-14 15:05
sensizbenlik14-Apr-14 15:05 
GeneralRe: how to import all csv files in a drive to database ? Pin
Wes Aday14-Apr-14 15:35
professionalWes Aday14-Apr-14 15:35 
QuestionTCP client example Pin
LegrandK14-Apr-14 8:56
LegrandK14-Apr-14 8:56 
AnswerRe: TCP client example Pin
Richard Andrew x6414-Apr-14 15:00
professionalRichard Andrew x6414-Apr-14 15:00 
QuestionWSDL and Web service Pin
Member 270883213-Apr-14 21:01
Member 270883213-Apr-14 21:01 
QuestionOrder Help! Pin
Member 1072866713-Apr-14 12:52
Member 1072866713-Apr-14 12:52 
AnswerRe: Order Help! Pin
Wes Aday13-Apr-14 14:18
professionalWes Aday13-Apr-14 14:18 
AnswerRe: Order Help! Pin
Peter Leow13-Apr-14 15:21
professionalPeter Leow13-Apr-14 15:21 
Question1 form, 2 text boxes, how to write code to exchange text between boxes Pin
ChaseG12-Apr-14 13:24
ChaseG12-Apr-14 13:24 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.