Programming Help

Web Development



What's Here?

  • Members: 136,460
  • Replies: 479,312
  • Topics: 74,679
  • Snippets: 2,567
  • Tutorials: 676
  • Total Online: 1,745
  • Members: 96
  • Guests: 1,649

Welcome to Dream.In.Code
Getting VB Help is Easy!

Join 136,460 VB Programmers for FREE! Get instant access to thousands of VB experts, tutorials, code snippets, and more! There are 1,745 people online right now. Registration is fast and FREE... Join Now!




inserting data to mysql with some condtion satisfyiing in oracle datab

 
 Reply to this topicStart new topic

inserting data to mysql with some condtion satisfyiing in oracle datab
yoganandham
30 Jul, 2008 - 03:46 AM
Post #1

New D.I.C Head
*

Joined: 30 Jul, 2008
Posts: 2
CODE

private Sub Command1_Click()
Dim rdoqry As New rdoQuery
Dim con As New rdoConnection
Dim rdors As rdoResultset
Dim migrat As ADODB.Recordset

Set migrat = adb.get_recordset("select * from book where updatestatus= 'No'")
If migrat.EOF = False Then
MsgBox "ok"
Else
MsgBox "hi"
End If

'With rdoqry
'    .SQL = in
'    .RowsetSize = 1
'    Set .ActiveConnection = con
'    Set rdors = .OpenResultset(rdOpenKeyset, rdConcurRowVer)
'End With
End Sub
User is offlineProfile CardPM
+Quote Post

PsychoCoder
RE: Inserting Data To Mysql With Some Condtion Satisfyiing In Oracle Datab
30 Jul, 2008 - 07:18 AM
Post #2

using DIC.Core;
Group Icon

Joined: 26 Jul, 2007
Posts: 8,993



Thanked: 125 times
Dream Kudos: 8625
Expert In: VB, VB.Net, C#, SQL, ASP, ASP.Net, Web Development, HTML, CSS, Win32 API, Javascript, mySQL, J#, Boo.Net

My Contributions
Are you receiving any errors? Does this code not work that way you intended it? When asking for help there are a couple items that are vital in order for someone to properly help you:

  • Post the code you're having problems with
  • Post the exact error you're receiving, if you are receiving one
  • If no error explain what the code is doing versus what you want it to do
User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic
Time is now: 12/2/08 04:16PM
Invision Power Board v2.1.7 © 2008  IPS, Inc.
Licensed to: MediaGroup1

Live VB Help!

VB Tutorials

Reference Sheets

VB Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month