VB.NET Programming Corner!

knives645 · Aug 16, 2013

Wala ang mga field na to sa SQL mo.

sRow(3) = rdr.Item("Year").ToString.Trim
sRow(4) = rdr.Item("Section").ToString.Trim
sRow(5) = rdr.Item("Adviser").ToString.Trim

Dim ssQl As String = "SELECT StudentProfile.IDNumber, StudentProfile.Lastname, StudentProfile.Firstname, StudentProfile.Year, StudentProfile.Section, StudentProfile.Adviser FROM StudentProfile INNER JOIN ClassRecords ON StudentProfile.IDNumber = ClassRecords.IDNumber"

EndUser · Aug 16, 2013

knives645 said:
Wala ang mga field na to sa SQL mo.

sRow(3) = rdr.Item("Year").ToString.Trim
sRow(4) = rdr.Item("Section").ToString.Trim
sRow(5) = rdr.Item("Adviser").ToString.Trim

bale yan po yung yung field sa classRecords.

doorbreaker · Aug 17, 2013

EndUser said:
bale yan po yung yung field sa classRecords.

kagaya ng sabi ni master knives wala yung mga field na yon kung classrecords pala yon located bakit

Code:

StudentProfile.Year, StudentProfile.Section, StudentProfile.Adviser

dapat

Code:

ClassRecords.Year, ClassRecords.Section, ClassRecords.Adviser

EndUser · Aug 17, 2013

doorbreaker said:
kagaya ng sabi ni master knives wala yung mga field na yon kung classrecords pala yon located bakit

Code:

StudentProfile.Year, StudentProfile.Section, StudentProfile.Adviser

dapat

Code:

ClassRecords.Year, ClassRecords.Section, ClassRecords.Adviser

solve na po ehehe. tnx parin

eto nman po pahelp

Friend Sub populateAttendance()
Dim sqlString As String = "SELECT [StudentProfile.IDNumber],[StudentProfile.Lastname],[StudentProfile.Fistname],[ClassRecords.IDNum],[ClassRecords.Year],[ClassRecords.Section],[AttendanceRecords.IDNumber],[AttendanceRecords.DateRecorded],[AttendanceRecords.Status],[AttendanceRecords.Subject],[AttendanceRecords.Teacher] "
sqlString = sqlString & "FROM StudentProfile INNER JOIN ClassRecords oN [StudentProfile.IDNumber]=[ClassRecords.IDNum] INNER JOIN AttendanceRecords oN [ClassRecords.IDNum]=[AttendanceRecords.IDNumber] ORDER BY StudentProfile.Lastname"

Using con As New OleDb.OleDbConnection(_gstrConnectionString)
Dim cmd As New OleDb.OleDbCommand(sqlString, con)
con.Open()
Dim reader As OleDb.OleDbDataReader = cmd.ExecuteReader

While reader.Read
Dim lvItem As New ListViewItem(reader("StudentProfile.IDNumber").ToString.Trim)
lvItem.SubItems.Add(reader("StudentProfile.Fistname") & " " & reader("StudentProfile.Lastname"))
lvItem.SubItems.Add(reader("ClassRecords.Year"))
lvItem.SubItems.Add(reader("ClassRecords.Section"))
lvItem.SubItems.Add(reader("AttendanceRecords.Subject"))
lvItem.SubItems.Add(reader("AttendanceRecords.Status"))
lvItem.SubItems.Add(reader("AttendanceRecords.DateRecorded"))
lvItem.SubItems.Add(reader("AttendanceRecords.Teacher"))

lvAttendance.Items.Add(lvItem)
End While

con.Close()
reader.Close()

End Using

End Sub

pahelp po. bakit may error na " Syntax error (missing operator) in query expression '[StudentProfile.IDNumber]=[ClassRecords.IDNum] INNER JOIN AttendanceRecords oN [ClassRecords.IDNum]=[AttendanceRecords.IDNumber]' "

EndUser · Aug 17, 2013

EndUser said:
solve na po ehehe. tnx parin

eto nman po pahelp

Friend Sub populateAttendance()
Dim sqlString As String = "SELECT [StudentProfile.IDNumber],[StudentProfile.Lastname],[StudentProfile.Fistname],[ClassRecords.IDNum],[ClassRecords.Year],[ClassRecords.Section],[AttendanceRecords.IDNumber],[AttendanceRecords.DateRecorded],[AttendanceRecords.Status],[AttendanceRecords.Subject],[AttendanceRecords.Teacher] "
sqlString = sqlString & "FROM StudentProfile INNER JOIN ClassRecords oN [StudentProfile.IDNumber]=[ClassRecords.IDNum] INNER JOIN AttendanceRecords oN [ClassRecords.IDNum]=[AttendanceRecords.IDNumber] ORDER BY StudentProfile.Lastname"

Using con As New OleDb.OleDbConnection(_gstrConnectionString)
Dim cmd As New OleDb.OleDbCommand(sqlString, con)
con.Open()
Dim reader As OleDb.OleDbDataReader = cmd.ExecuteReader

While reader.Read
Dim lvItem As New ListViewItem(reader("StudentProfile.IDNumber").ToString.Trim)
lvItem.SubItems.Add(reader("StudentProfile.Fistname") & " " & reader("StudentProfile.Lastname"))
lvItem.SubItems.Add(reader("ClassRecords.Year"))
lvItem.SubItems.Add(reader("ClassRecords.Section"))
lvItem.SubItems.Add(reader("AttendanceRecords.Subject"))
lvItem.SubItems.Add(reader("AttendanceRecords.Status"))
lvItem.SubItems.Add(reader("AttendanceRecords.DateRecorded"))
lvItem.SubItems.Add(reader("AttendanceRecords.Teacher"))

lvAttendance.Items.Add(lvItem)
End While

con.Close()
reader.Close()

End Using

End Sub

pahelp po. bakit may error na " Syntax error (missing operator) in query expression '[StudentProfile.IDNumber]=[ClassRecords.IDNum] INNER JOIN AttendanceRecords oN [ClassRecords.IDNum]=[AttendanceRecords.IDNumber]' "

Solve na po

Kailangan pala ng parenthesis if more than 1 join.hehe TY PO

Soichiro Jin · Aug 17, 2013

Guy's help nman pano mag auto generate ng ID's like DPWH-001 to DPWH-100 and so on

My simple code auto generate ID code,

Pahelp naman please :help:

Code:

    Private Sub guestID()

        Dim number As Integer

        Try
            Query = "SELECT Max(guestID) FROM tbl_guest"

            MySqlCommand = New MySqlCommand(Query, CNN)
            MySqlCommand.ExecuteNonQuery()


            If IsDBNull(MySqlCommand.ExecuteScalar) Then
                number = 1
                txtID.Text = number
            Else
                number = MySqlCommand.ExecuteScalar + 1
                txtID.Text = number
            End If

        Catch ex As Exception
            MessageBox.Show(ex.ToString, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error)
        Finally
            MySqlDataReader.Close()
        End Try

    End Sub

polens · Aug 18, 2013

Soichiro Jin said:

Guy's help nman pano mag auto generate ng ID's like DPWH-001 to DPWH-100 and so on

My simple code auto generate ID code,

Pahelp naman please :help:

Code:

    Private Sub guestID()

        Dim number As Integer

        Try
            Query = "SELECT Max(guestID) FROM tbl_guest"

            MySqlCommand = New MySqlCommand(Query, CNN)
            MySqlCommand.ExecuteNonQuery()


            If IsDBNull(MySqlCommand.ExecuteScalar) Then
                number = 1
                txtID.Text = number
            Else
                number = MySqlCommand.ExecuteScalar + 1
                txtID.Text = number
            End If

        Catch ex As Exception
            MessageBox.Show(ex.ToString, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error)
        Finally
            MySqlDataReader.Close()
        End Try

    End Sub

eto,
kapag nakuha mo na ung MAX ID(wag na executescalar)
lagay mo sa isang container
then split mo using splitfunction
after nyan makukuha mo na ung number part ng unique ID mo
then increment ka na ng 1
sample:

Code:

  Friend Function getCode(ByVal table As String, ByVal field As List(Of String), ByVal category As String) As String
        da = New DataAccess
        Dim idr As IDataReader
        Dim newID As String = String.Empty
        idr = da.getNewCode(table, field)
        Dim xMaxID As String = String.Empty
        While idr.Read
            xMaxID = idr.Item("MAXID").ToString
        End While
        If Not xMaxID = String.Empty Then
            Dim xSplit As String() = xMaxID.Split("-")
            Dim xNumID As Integer = CInt(xSplit(1)) + 1
            'newID = String.Format("{0:}-{1:0000}", xSplit(0), xNumID)
            Select Case category
                Case "I"
                    newID = String.Format("I-{0:0000}", xNumID)
                Case "M"
                    newID = String.Format("M-{0:0000}", xNumID)
                Case "MP"
                    newID = String.Format("MP-{0:0000}", xNumID)
                Case "N"

                    newID = String.Format("N-{0:0000}", xNumID)
                Case "TA"
                    newID = String.Format("TA-{0:0000}", xNumID)
                Case "In"
                    newID = String.Format("IC-{0:0000}", xNumID)
            End Select
        Else
            Select Case category
                Case "I"
                    newID = String.Format("I-{0:0000}", 1)
                Case "M"
                    newID = String.Format("M-{0:0000}", 1)
                Case "MP"
                    newID = String.Format("MP-{0:0000}", 1)
                Case "N"
                    newID = String.Format("N-{0:0000}", 1)
                Case "TA"
                    newID = String.Format("TA-{0:0000}", 1)
                Case "In"
                    newID = String.Format("IC-{0:0000}", 1)
            End Select

        End If
        Return newID
    End Function

maraming paraan use your imagination..pwedeng eto ang gawin mo
asa separate columns sila namely CODE(DPWH) and IDCODE(0001)
so kung magiincrement ka ke IDCODE lng then kung retreive concat mo lng sila sa query..

bryan1207 · Aug 18, 2013

Soichiro Jin said:

Guy's help nman pano mag auto generate ng ID's like DPWH-001 to DPWH-100 and so on

My simple code auto generate ID code,

Pahelp naman please :help:

Code:

    Private Sub guestID()

        Dim number As Integer

        Try
            Query = "SELECT Max(guestID) FROM tbl_guest"

            MySqlCommand = New MySqlCommand(Query, CNN)
            MySqlCommand.ExecuteNonQuery()


            If IsDBNull(MySqlCommand.ExecuteScalar) Then
                number = 1
                txtID.Text = number
            Else
                number = MySqlCommand.ExecuteScalar + 1
                txtID.Text = number
            End If

        Catch ex As Exception
            MessageBox.Show(ex.ToString, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error)
        Finally
            MySqlDataReader.Close()
        End Try

    End Sub

Code:

DECLARE @maxid as integer
SELECT @maxid = MAX(guestID) FROM tbl_guest
SELECT SubString('DPWH-000000', @maxid, Len('DPWH-000000') - Len(5)) + Convert(Varchar, @maxid)

Try mo yan, simpleng sql lang po. Hindi ko pa natry, naka mobile po ako.

Kunin mo nalang yung value ng query na yan. At yun yung magiging new ID mo.

Soichiro Jin · Aug 18, 2013

polens said:

eto,
kapag nakuha mo na ung MAX ID(wag na executescalar)
lagay mo sa isang container
then split mo using splitfunction
after nyan makukuha mo na ung number part ng unique ID mo
then increment ka na ng 1
sample:

Code:

  Friend Function getCode(ByVal table As String, ByVal field As List(Of String), ByVal category As String) As String
        da = New DataAccess
        Dim idr As IDataReader
        Dim newID As String = String.Empty
        idr = da.getNewCode(table, field)
        Dim xMaxID As String = String.Empty
        While idr.Read
            xMaxID = idr.Item("MAXID").ToString
        End While
        If Not xMaxID = String.Empty Then
            Dim xSplit As String() = xMaxID.Split("-")
            Dim xNumID As Integer = CInt(xSplit(1)) + 1
            'newID = String.Format("{0:}-{1:0000}", xSplit(0), xNumID)
            Select Case category
                Case "I"
                    newID = String.Format("I-{0:0000}", xNumID)
                Case "M"
                    newID = String.Format("M-{0:0000}", xNumID)
                Case "MP"
                    newID = String.Format("MP-{0:0000}", xNumID)
                Case "N"

                    newID = String.Format("N-{0:0000}", xNumID)
                Case "TA"
                    newID = String.Format("TA-{0:0000}", xNumID)
                Case "In"
                    newID = String.Format("IC-{0:0000}", xNumID)
            End Select
        Else
            Select Case category
                Case "I"
                    newID = String.Format("I-{0:0000}", 1)
                Case "M"
                    newID = String.Format("M-{0:0000}", 1)
                Case "MP"
                    newID = String.Format("MP-{0:0000}", 1)
                Case "N"
                    newID = String.Format("N-{0:0000}", 1)
                Case "TA"
                    newID = String.Format("TA-{0:0000}", 1)
                Case "In"
                    newID = String.Format("IC-{0:0000}", 1)
            End Select

        End If
        Return newID
    End Function

maraming paraan use your imagination..pwedeng eto ang gawin mo
asa separate columns sila namely CODE(DPWH) and IDCODE(0001)
so kung magiincrement ka ke IDCODE lng then kung retreive concat mo lng sila sa query..

Thanks master , may mas simple code pa po nyan? Saka thanks sa mga ideas :thanks:

bryan1207 said:
Code:

DECLARE @maxid as integer SELECT @maxid = MAX(guestID) FROM tbl_guest SELECT SubString('DPWH-000000', @maxid, Len('DPWH-000000') - Len(5)) + Convert(Varchar, @maxid)

Try mo yan, simpleng sql lang po. Hindi ko pa natry, naka mobile po ako.

Kunin mo nalang yung value ng query na yan. At yun yung magiging new ID mo.

Nice, pero di ko magets yung sa select substring, pano ba gawin, my sample code ka po dyan master? Hintay ko code mo master :praise:

polens · Aug 19, 2013

Soichiro Jin said:
Thanks master , may mas simple code pa po nyan? Saka thanks sa mga ideas

Nice, pero di ko magets yung sa select substring, pano ba gawin, my sample code ka po dyan master? Hintay ko code mo master

habang inaantay mo ang code bakit hindi mo muna subukan..
sabi ko maraming paraan
2 ideas na ang bnigay sayo try mo muna..
simple na nga eto eh read and understand the logic lng..
kinuha ko ang MAX ng field
Split ko ung result
kinuha ko ung integer part
nagincrement by 1
concat ko ngayn
tapos..

Code:

Dim xMaxID As String = String.Empty
        While idr.Read
            xMaxID = idr.Item("MAXID").ToString
        End While
        If Not xMaxID = String.Empty Then
            Dim xSplit As String() = xMaxID.Split("-")
            Dim xNumID As Integer = CInt(xSplit(1)) + 1
end if

junbugtong · Aug 19, 2013

Good day mga sir.. hinge lang po sana ng konting tulong..

I'm using vb.net 2010(FrontEnd) and Microsoft SQL Server Database File(ung built-in po sa Visual Studio(BackEnd))..

About po sa RDLC reports..

sa pagcreate ko ng dataset.. Nagaask po si vb.net na kailangan ko daw icopy ung database sa loob ng project ko.. (Please see attachments nalang po para mas malinawan kayo. Thank you.)

YES po ung gnagawa ko dun.. then successful ung pagcreate.. napapalabas ko na din po ung mga records sa report viewer..

The problem is kapag nag aupdate ako ng database.. ung nasa bin/debug folder ng project ko.. Hindi po nagaupdate ung na-copy na database(nung nagcreate akong dataset).

eto po ung connection ko sa pagaccess ng database.

myConStr = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\dbPayrollSystem.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"

- Ano po kaya ung maaring naging problem?
- Kailangan ko po bang magupdate ng dataset para maupdate din ung database na isa(ung database nung nagcreate akong dataset)?

TYIA. Badly needed. hehe

View attachment 131582

therealbeernordo · Aug 19, 2013

good morning!
paHELP! po para sa case study namin na POS(Point of Sales)

thanks... please email me "[email protected]" & "[email protected]"

maskio · Aug 19, 2013

Soichiro Jin said:

Guy's help nman pano mag auto generate ng ID's like DPWH-001 to DPWH-100 and so on

My simple code auto generate ID code,

Pahelp naman please :help:

Code:

    Private Sub guestID()

        Dim number As Integer

        Try
            Query = "SELECT Max(guestID) FROM tbl_guest"

            MySqlCommand = New MySqlCommand(Query, CNN)
            MySqlCommand.ExecuteNonQuery()


            If IsDBNull(MySqlCommand.ExecuteScalar) Then
                number = 1
                txtID.Text = number
            Else
                number = MySqlCommand.ExecuteScalar + 1
                txtID.Text = number
            End If

        Catch ex As Exception
            MessageBox.Show(ex.ToString, "Message", MessageBoxButtons.OK, MessageBoxIcon.Error)
        Finally
            MySqlDataReader.Close()
        End Try

    End Sub

ok, if this number is a primary key or this number is a unique number, dont use ++. kasi may posibility na ma duplicate ang number, trust me i've tried this, my work around is to have a spoiler table, walang ibang laman ang table na yun kundi auto-incremented id.

insert into spoiler(id) values(NULL);
select last_insert_id() into new_id; <--- this is your auto generated Id.
set @maxId = concat('DPWH-',new_id);
select @maxId;

e zero fill mo lang ang number, probably you would declare it as int(10).

** ang posibility kasi ng pag select mo ng maxId is mag duduplicate kapag may sabay na mag save. kasi pareho nila makukuha ang the same last number. pag add ng 1. boom your doomed. **

maskio · Aug 19, 2013

junbugtong said:
Good day mga sir.. hinge lang po sana ng konting tulong..

I'm using vb.net 2010(FrontEnd) and Microsoft SQL Server Database File(ung built-in po sa Visual Studio(BackEnd))..

About po sa RDLC reports..

sa pagcreate ko ng dataset.. Nagaask po si vb.net na kailangan ko daw icopy ung database sa loob ng project ko.. (Please see attachments nalang po para mas malinawan kayo. Thank you.)

YES po ung gnagawa ko dun.. then successful ung pagcreate.. napapalabas ko na din po ung mga records sa report viewer..

The problem is kapag nag aupdate ako ng database.. ung nasa bin/debug folder ng project ko.. Hindi po nagaupdate ung na-copy na database(nung nagcreate akong dataset).

eto po ung connection ko sa pagaccess ng database.

myConStr = "Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\dbPayrollSystem.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"

- Ano po kaya ung maaring naging problem?
- Kailangan ko po bang magupdate ng dataset para maupdate din ung database na isa(ung database nung nagcreate akong dataset)?

TYIA. Badly needed. hehe

View attachment 776398

dont select microsoft access database file. instead, select Microsoft SQL Server, then select server name, logon to server and test connection.

rhon6260 · Aug 19, 2013

Sir Maskio
Interesting Post

Nalito ako dito

insert into spoiler(id) values(NULL);
select last_insert_id() into new_id; <--- this is your auto generated Id.
set @maxId = concat('DPWH-',new_id);
select @maxId;

1. INSERT Null Value in Spoilertable
2. SELECT CONCAT('DPWH-',ID) AS newID FROM Spoiler ORDER BY ID DESC LIMIT 1

PS:

Naka encourter na po ba kayo na magkakaduplecate yung Row sa pag insert ? yan kase yung problem ko ngayun..

jomajoy · Aug 19, 2013

sobrang helpfull ng thread nato. maraming salamat dito :dance:

junbugtong · Aug 19, 2013

maskio said:
dont select microsoft access database file. instead, select Microsoft SQL Server, then select server name, logon to server and test connection.

Sir. yes sir. Microsoft SQL Server Database File po ung selected ko.. and di na po need ng mga server name sa database na ginagamit ko. d po namen nagawa sa SQL Server Management sa built-in lang pong database namen nagawa which is the Microsoft SQL Server Database File.. un sir. salamat sa response.. try ko nalang po ulet.. thanks.. :salute:

maskio · Aug 20, 2013

rhon6260 said:
Sir Maskio
Interesting Post
Nalito ako dito

insert into spoiler(id) values(NULL);
select last_insert_id() into new_id; <--- this is your auto generated Id.
set @maxId = concat('DPWH-',new_id);
select @maxId;

1. INSERT Null Value in Spoilertable
2. SELECT CONCAT('DPWH-',ID) AS newID FROM Spoiler ORDER BY ID DESC LIMIT 1

PS:

Naka encourter na po ba kayo na magkakaduplecate yung Row sa pag insert ? yan kase yung problem ko ngayun..

yah. naka encounter na ako ng duplicate row. pag sabay kasi mag save. kinukuha ng code yung maxId, pag increment mo ng 1. pareho sila ng id.

1. gawa ka ng table na naka auto increment.

CREATE TABLE `test`.`table_spoiler`( `spoiler_id` INT(10) ZEROFILL NOT NULL AUTO_INCREMENT, PRIMARY KEY (`spoiler_id`) );

yung insert into table_spoiler(spoiler_id) values(NULL); <---- this would add a new row with auto incremented value.

2. select last_insert_id(); <---- you will get the last inserted row on your table.

ex.

table_spoiler
| spoiler_id |
| 0000000001 |
| 0000000002 |
| ???????????? | <--- the query on #1 would add 0000000003

select last insert id, you would also get 0000000003;

this is to avoid duplicate since ang mysql na ang mag hahandle ng pag add ng number. int(10) is almost 10 Billion rows. kahit trigger happy ang user mo. di nya ma uubos ang 10B rows. (pag napuno na) alter table into bigint(20)

*** EDIT ***
i forgot, either you place this in a stored proc or you implement start transaction sa vb.

rhon6260 · Aug 20, 2013

maskio said:
yah. naka encounter na ako ng duplicate row. pag sabay kasi mag save. kinukuha ng code yung maxId, pag increment mo ng 1. pareho sila ng id.

1. gawa ka ng table na naka auto increment.

CREATE TABLE `test`.`table_spoiler`( `spoiler_id` INT(10) ZEROFILL NOT NULL AUTO_INCREMENT, PRIMARY KEY (`spoiler_id`) );

yung insert into table_spoiler(spoiler_id) values(NULL); <---- this would add a new row with auto incremented value.

2. select last_insert_id(); <---- you will get the last inserted row on your table.

ex.

table_spoiler
| spoiler_id |
| 0000000001 |
| 0000000002 |
| ???????????? | <--- the query on #1 would add 0000000003

select last insert id, you would also get 0000000003;

this is to avoid duplicate since ang mysql na ang mag hahandle ng pag add ng number. int(10) is almost 10 Billion rows. kahit trigger happy ang user mo. di nya ma uubos ang 10B rows. (pag napuno na) alter table into bigint(20)

*** EDIT ***
i forgot, either you place this in a stored proc or you implement start transaction sa vb.

Ah get ko na

function pala yan hehehe :lmao:

How about this senario sir :pray:

merong 1000 Branches, tapus every branch mag Auto Generate ng ID
like
1. BranchBatanes0000001 until BranchBatanes9999999
2. BranchBicol0000001 until BranchBicol9999999
3. BranchBohol0000001 until BranchBohol9999999
.
.
.
1000

does it mean na gagawa ako ng 1000 tables para wlang magkakaduplicate entry sa bawat branches? :noidea:

another Senario sir
may application ako na magIInsert sa DataBase "MySql" gamit ang BulkInsert ang app ay ginagamit lang sa isang User "Admin" may possibility po ba na mag double entry yung mga na bNulkInsert ko?
:noidea:

Salamat pala sa mga Tips

maskio · Aug 20, 2013

rhon6260 said:
Ah get ko na function pala yan hehehe

How about this senario sir
merong 1000 Branches, tapus every branch mag Auto Generate ng ID
like
1. BranchBatanes0000001 until BranchBatanes9999999
2. BranchBicol0000001 until BranchBicol9999999
3. BranchBohol0000001 until BranchBohol9999999
.
.
.
1000

does it mean na gagawa ako ng 1000 tables para wlang magkakaduplicate entry sa bawat branches?

another Senario sir
may application ako na magIInsert sa DataBase "MySql" gamit ang BulkInsert ang app ay ginagamit lang sa isang User "Admin" may possibility po ba na mag double entry yung mga na bNulkInsert ko?

Salamat pala sa mga Tips

no. that is a different scenario. a different approach would be applied.

one possible solution i could recommend is the maxId but you add ON DUPLICATE KEY sa dulo. and you need to counter check if its the right value before passing the select statement.

INSERT INTO table(id) (SELECT maxId FROM table) ON DUPLICATE KEY UPDATE id = id;

in case may existing na id, e seset nya lang ang id into that ID but you need to have another unique identifier para ma cross check mo if tama ang na insert. other than that, you would not know if it was inserted or there was an existing id.

for question 2, that would depend on your table structures. i cant say without seeing the actual structure. but in anycase na may id ka na ginamit na hindi naka unique or naka primary key, my answer would be yes; may possibility na mag duplicate.

*** EdiT ***
(SELECT (maxId + 1) FROM table)

VB.NET Programming Corner!

The Saint

Apprentice

The Martyr

Apprentice

Apprentice

Proficient

The Patriot

Proficient

Proficient

The Patriot

Novice

Attachments

Recruit

The Devotee

The Devotee

Proficient

Amateur

Novice

The Devotee

Proficient

The Devotee

Similar threads