update data in oracle database extracted txt.file every 3 hours , delete if similar data same transdate found. transdate date of data being updated database (today's date). when run code doesn't store transdate. solution in vb.
private sub readposition() dim rowvalue string dim cellvalue(20) string dim streamreader io.streamreader = new io.streamreader("d:\position.txt") 'reading csv file content while streamreader.peek() <> -1 rowvalue = streamreader.readline() cellvalue = rowvalue.split("|") 'check ur separator connectoracle() mysqlcmd.connection = myconn if sql.length > 0 sql.replace(sql.tostring, "") end if sql.append("insert market_one (code, name,location, startdate, enddate,transdate) ") sql.append(" values ('" & cellvalue(0) & "' ,'" & cellvalue(1) & "','" & cellvalue(2) & "','" & cellvalue(3) & "','" & cellvalue(4) & "',trunc(sysdate) ") try mysqlcmd.commandtext = sql.tostring mysqlcmd.executenonquery() catch ex exception messagebox.show("error " & ex.message.tostring) end try end while end sub private sub deleteposition() dim regdate date = date.today() connectoracle() mysqlcmd.connection = myconn if sql.length > 0 sql.replace(sql.tostring, "") end if sql.append("delete market_one ") sql.append("where transdate = '" & date.today & "' ") try mysqlcmd.commandtext = sql.tostring mysqlcmd.executenonquery() catch ex exception messagebox.show("error " & ex.message.tostring) end try end sub
