Click here to Skip to main content
15,901,122 members
Home / Discussions / Database
   

Database

 
GeneralRe: MySql - No results from query with WHERE Pin
Jörgen Andersson2-Jan-17 22:56
professionalJörgen Andersson2-Jan-17 22:56 
GeneralRe: MySql - No results from query with WHERE Pin
Mycroft Holmes3-Jan-17 10:29
professionalMycroft Holmes3-Jan-17 10:29 
AnswerRe: MySql - No results from query with WHERE Pin
Bernhard Hiller2-Jan-17 21:01
Bernhard Hiller2-Jan-17 21:01 
GeneralRe: MySql - No results from query with WHERE Pin
BobbyStrain3-Jan-17 4:30
BobbyStrain3-Jan-17 4:30 
QuestionDelete rows from a foxpro dbf file, that seems to be locked Pin
jkirkerx28-Dec-16 13:04
professionaljkirkerx28-Dec-16 13:04 
AnswerRe: Delete rows from a foxpro dbf file, that seems to be locked Pin
CHill6029-Dec-16 3:59
mveCHill6029-Dec-16 3:59 
GeneralRe: Delete rows from a foxpro dbf file, that seems to be locked Pin
jkirkerx29-Dec-16 7:04
professionaljkirkerx29-Dec-16 7:04 
AnswerI got this working partially, but can't figure out why I can't delete by Invoice Number Pin
jkirkerx29-Dec-16 8:07
professionaljkirkerx29-Dec-16 8:07 
I got this working, in which I can delete by Customer Number which is Column 2 and the index, but I can't delete by using Column 0, Invoice Number.
When I use DBF Manager and do a search by invoice number, it comes back search string not found.
Think it's because it a partial string or something?
This technology is before I got into programming, and I never really used back in 1997.
Dim connString As String = "Provider=VFPOLEDB; Data Source=" & m_path & "; DELETED = FALSE;"

        Using connection As New System.Data.OleDb.OleDbConnection(connString)
            Dim c1 As New System.Data.OleDb.OleDbCommand("SET EXCLUSIVE ON", connection)
            Dim c2 As New System.Data.OleDb.OleDbCommand("SET DELETED ON", connection)
            Dim c3 As New System.Data.OleDb.OleDbCommand("DELETE FROM ARTRS01H WHERE FCUSTNO = ? AND FINVNO = ?", connection)
            Dim c4 As New System.Data.OleDb.OleDbCommand("PACK", connection)

            Dim paramFCUSTNO As System.Data.OleDb.OleDbParameter
            paramFCUSTNO = New System.Data.OleDb.OleDbParameter("@FCUSTNO", OleDbType.VarChar)
            paramFCUSTNO.Value = pCustNo
            c3.Parameters.Add(paramFCUSTNO)

            Dim paramFINVNO As System.Data.OleDb.OleDbParameter
            paramFINVNO = New System.Data.OleDb.OleDbParameter("@FINVNO", OleDbType.VarChar)
            paramFINVNO.Value = pInvNo
            c3.Parameters.Add(paramFINVNO)

            Try
                connection.Open()
                c1.ExecuteNonQuery()
                c2.ExecuteNonQuery()
                Dim x As Integer = c3.ExecuteNonQuery()
                c4.ExecuteNonQuery()
                pValue = If(x > 0, True, False)

            Catch sqlEx As SqlClient.SqlException
                pValue = False

            Catch exdb As OleDb.OleDbException
                pValue = False

            Catch ex As Exception
                pValue = False

            Finally
                connection.Close()

            End Try

        End Using
21st Century Globalism has become Socialism on a planetary scale, in which the unequal treaties of the past have come back into play.

GeneralI got it working, not sure it will always work Pin
jkirkerx29-Dec-16 9:23
professionaljkirkerx29-Dec-16 9:23 
QuestionUpdating a FoxPro dbf file using VB.net Pin
jkirkerx22-Dec-16 11:32
professionaljkirkerx22-Dec-16 11:32 
AnswerRe: Updating a FoxPro dbf file using VB.net Pin
jkirkerx22-Dec-16 11:37
professionaljkirkerx22-Dec-16 11:37 
AnswerRe: Updating a FoxPro dbf file using VB.net Pin
jschell26-Dec-16 7:17
jschell26-Dec-16 7:17 
GeneralRe: Updating a FoxPro dbf file using VB.net Pin
jkirkerx27-Dec-16 7:09
professionaljkirkerx27-Dec-16 7:09 
QuestionDrop & Recreate the DB Pin
Kevin Marois21-Dec-16 12:48
professionalKevin Marois21-Dec-16 12:48 
AnswerRe: Drop & Recreate the DB Pin
Chris Quinn21-Dec-16 22:03
Chris Quinn21-Dec-16 22:03 
GeneralRe: Drop & Recreate the DB Pin
Kevin Marois22-Dec-16 4:37
professionalKevin Marois22-Dec-16 4:37 
QuestionRe: Drop & Recreate the DB Pin
Richard MacCutchan22-Dec-16 4:59
mveRichard MacCutchan22-Dec-16 4:59 
AnswerRe: Drop & Recreate the DB Pin
Kevin Marois22-Dec-16 4:59
professionalKevin Marois22-Dec-16 4:59 
AnswerRe: Drop & Recreate the DB Pin
Simon_Whale22-Dec-16 5:49
Simon_Whale22-Dec-16 5:49 
GeneralRe: Drop & Recreate the DB Pin
Kevin Marois22-Dec-16 5:54
professionalKevin Marois22-Dec-16 5:54 
QuestionSQL 2012 Restore Problem Pin
Kevin Marois21-Dec-16 4:46
professionalKevin Marois21-Dec-16 4:46 
AnswerRe: SQL 2012 Restore Problem Pin
Richard Deeming21-Dec-16 6:00
mveRichard Deeming21-Dec-16 6:00 
GeneralRe: SQL 2012 Restore Problem Pin
Kevin Marois21-Dec-16 6:02
professionalKevin Marois21-Dec-16 6:02 
Questionerror occurred while enabling mars for this connection Pin
Travelthrprog18-Dec-16 7:56
Travelthrprog18-Dec-16 7:56 
AnswerRe: error occurred while enabling mars for this connection Pin
Eddy Vluggen21-Dec-16 4:52
professionalEddy Vluggen21-Dec-16 4:52 

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.