?
Solved

Unexpected blank rows in dbgrid when bound with a RDC !

Posted on 1998-09-30
13
Medium Priority
?
259 Views
Last Modified: 2013-12-26
This problem occur  when I display data in dbgrid which bound  to a remote data control(RDC) that link to a table in database. It takes sometime(very slow :-( ) to refresh the dbgrid including the blank rows each time I refresh the RDC and sometime duplicate row appeared (head ache and blur blur).
Is there anybody face the same problem? please help me if you know what's the cause and help to solve this problem.
Sample code will be appreciated.

If you don't know how to solve it or haven't face this problem before, YOU STILL CAN HELP ME :-) by spreed this question to you friend whoever like to solve the VB control problem. Is it challenging man..? Thanks in advance.

you can contach me by
jiada@hotmail.com

rgd
Chen Jiada
011098  
0
Comment
Question by:jiada
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
13 Comments
 
LVL 3

Expert Comment

by:vmano
ID: 1487240
Refresh the RDC twice.

Private Sub Command1_Click()
  MSRDC1.SQL = "SELECT * FROM Authors"
  MSRDC1.Refresh    
  MSRDC1.Refresh  
End Sub

vmano
0
 

Author Comment

by:jiada
ID: 1487241
I tried to refresh the rdc not just twice but more..but the problem still there(still got unwanted blank rows and I can even see the dbgrid refresh coloum by coloum..unexpected slow refreshing). Anyway thanks for your effort for helping me to solve this problem although it didn't bring any help. It would be appreciated.

Please help me on this problem or my project is going to be delayed.
0
 

Author Comment

by:jiada
ID: 1487242
Adjusted points to 100
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 3

Expert Comment

by:TheAnswerMan
ID: 1487243
are you opening it as a OpenKeyset and read only?
Are you connecting to Access or SQL Server?
0
 

Author Comment

by:jiada
ID: 1487244
I open as a OpenKeyset (read and write) and connecting to SQL server.
I use many dbgrids in ONE form and they all bound to the same RDC.
I only enable 1 dbgrid for data entry at one time, so I have to refresh it frequenly for other entry.
0
 
LVL 2

Expert Comment

by:majed100598
ID: 1487245
I USE TH RDC AND I FACE THE SAME PROBLEMS YOU HAVE, I THINK THAT
AN ERROR IN THIS VERSIN OF RDC CONTROL,
I ADVICE YOU TO USE OTHER VERSION OF RDC CONTROL WHICH HAVE NO PROBLEMS.
I ADVICE YOU TO USE THE DATA CONTROL COMING WHITH VISUAL BASIC BECAUSE I USE IT WELL AND I THINK IT VERY WELL .
0
 
LVL 3

Expert Comment

by:TheAnswerMan
ID: 1487246
I had received an error with the grids and RDO
I recommend getting the Service Pack
VB5 how is SP3...
but the problem went away with SP2.
let me know if you need any help getting it..
i can email it to you if you cant fint it at Microsoft.
0
 
LVL 3

Expert Comment

by:TheAnswerMan
ID: 1487247
The other think you might try is setting the Datacontrol's bookmark to NULL.. then doing a refresh.
0
 

Author Comment

by:jiada
ID: 1487248
Well, what the other version of rdc Majed refer to. There is no point for us try to solve this rdc problem if there is an error on rdc control as majed think. Does anyone can prove to me it is true? or any former documents regarding this problem?(I need to prepare a report to my boss).

Please send me the code/demo project for how to use data control to retrieve data from a SQL server to a dbgrid which bound to the data control by using ODBC(I need the infomation for each main property setting of the data control and dbgrid) if you think it can be work by using the data control instead of RDC.

Thanks Majed for the effort to answer my question. Actually I didn't reject your proposed answer wholely as I need more infomation to solve my problem. I would like to award you some points but I don't know the way. Is there anybody can tell me how to award points to a somebody if the person's propose answer has been rejected?  

0
 

Author Comment

by:jiada
ID: 1487249
comment as above.
0
 
LVL 3

Accepted Solution

by:
TheAnswerMan earned 300 total points
ID: 1487250
You have him Submit again as an answer.  
0
 
LVL 3

Expert Comment

by:TheAnswerMan
ID: 1487251
1 I dont have any documentation on the error.
2 But we did have the error.
3 We Called Apex about the error in our TrueGrids
4 They said it was an error in Microsofts RDO..
5 We got the Next Service Pack for VB.
6 The Problem went away.
0
 

Author Comment

by:jiada
ID: 1487252
I try to download the VB5 SP2/SP3 but it seems that the related pages has been updated to the VB6 SP1 and I can't find where I can download the SP(s) for VB5 .
Please mail to me the url(s) where I can get them.

I satisfy with your answer and at the time you see this comment, you had been awarded the points.

Thanks for your answer.
0

Featured Post

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…
If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question