Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums
 |
•
•
Join Date: Jun 2007
Posts: 29
Reputation: 
Rep Power: 2
Solved Threads: 0
Light Poster
Problem in updating datas in database without exiting application. I use
dim mydb as recordset
and also use
mydb.update
in certain required places like the update command button clicking. It works, by adding the new value in database. I have a list that shows the values of that db. But the main problem is i cannot see the newly added values unless i exit and reopen the application. after reopen i can see the newly added value. But i want to see the value in run time after clicking the add button which add value from a text box that i write. Sorry for the long literature, please help me.
dim mydb as recordset
and also use
mydb.update
in certain required places like the update command button clicking. It works, by adding the new value in database. I have a list that shows the values of that db. But the main problem is i cannot see the newly added values unless i exit and reopen the application. after reopen i can see the newly added value. But i want to see the value in run time after clicking the add button which add value from a text box that i write. Sorry for the long literature, please help me.
•
•
Join Date: Aug 2007
Location: Cavite,Philippines
Posts: 508
Reputation:
Rep Power: 3
Solved Threads: 68
Posting Pro
try list1.refresh after the updating part,
but sometimes this does not work.
Best way,after updating,close the connection then open it again,ok?
but sometimes this does not work.
Best way,after updating,close the connection then open it again,ok?
"death is the cure of all diseases..."
http://ryantetek.wordpress.com
http://ryantetek.wordpress.com
•
•
Join Date: Apr 2007
Posts: 78
Reputation:
Rep Power: 2
Solved Threads: 10
Junior Poster in Training
Try mydb.requery as well
•
•
Join Date: Jun 2007
Posts: 29
Reputation:
Rep Power: 2
Solved Threads: 0
Light Poster
As i am not so expert, would u please tell me what should be the code example of closing connection?
•
•
Join Date: Aug 2007
Location: Cavite,Philippines
Posts: 508
Reputation:
Rep Power: 3
Solved Threads: 68
Posting Pro
•
•
Join Date: Feb 2007
Location: Bangalore,India
Posts: 1,502
Reputation:
Rep Power: 5
Solved Threads: 91
What is the type of connection that you are using.
Share your Knowledge.
•
•
Join Date: May 2007
Location: India
Posts: 505
Reputation:
Rep Power: 3
Solved Threads: 48
Posting Pro
if u r using the DAO technique use the table recordset type at the time of opening the recordset. a sample is :-
dim db as database,rs as recordset
set db=opendatabase(app.path & "\mydb.mdb")
set rs=db.openrecordset("table1",dbopentable)
if rs.recordcount>0 then
''ur data showing code goes here
endif
otherwise u have to simultaneously unload and show up ur forms.
dim db as database,rs as recordset
set db=opendatabase(app.path & "\mydb.mdb")
set rs=db.openrecordset("table1",dbopentable)
if rs.recordcount>0 then
''ur data showing code goes here
endif
otherwise u have to simultaneously unload and show up ur forms.
Shouvik_The_Expert_Coder
Have a problem? Don't worry just give me a call and I'll fix it for you.
Have a problem? Don't worry just give me a call and I'll fix it for you.
|
Similar Threads
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- How to insert data into database? (JSP)
- Difference between Database Server and Application Server (IT Professionals' Lounge)
- Problem Updating Row in GridView (ASP.NET)
- Error connecting to database (ASP.NET)
- Problem changing contents of JTable when button is pressed... (Java)
- Re: Problem in updating project for Microsoft Project 2002 and 2003 (Windows Software)
- help pleaseee! probl with username and passwd when updating mysql database (MySQL)
- Code for Exiting a C# Application (C#)
- Addnew problem (Visual Basic 4 / 5 / 6)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: noob here! combo box
- Next Thread: visual basic six Data storage calculator
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
