|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
Dear All,
For the last few days i have been struggling with a problem, My Problem description I have a form on which i have some control array labels on load event i am getting the captions for these labels from the database. On click of the label i am retriving the label caption on a textbox and updating the value this works properly. But when i choose the option to delete the same it deletes the record from the database but it shows the deleted value in the label.When i stop the application and restart it shows properly. regards vinai |
|
#2
|
|||
|
|||
|
OK,I have a problem to ask u:after u delete some record from the database,u Update the db or close db and reconnect it??
|
|
#3
|
||||
|
||||
|
sorry, vinai.. I don't think I understand the problem. but from what I can tell, if you set the recordset =nothing, and the requery, it should work fine. by the way, there is a method of ADO recordsets called .requery - i don't know if you can use it or not.
__________________
Fisherman "Any intelligent fool can make things bigger, more complex, and more violent. It takes a touch of genius -- and a lot of courage -- to move in the opposite direction." - A.Einstein |
|
#4
|
|||
|
|||
|
Thx for fisherman's reply..
|
|
#5
|
|||
|
|||
|
Thanks all it works now.As i said it was not refresshing i called the same functions set on form.Activate and my problems r solved.
|
![]() |
| Viewing: Dev Shed Forums > Programming Languages - More > Visual Basic Programming > Refershing the Database Connection. |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|