Visual Basic Programming
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsProgrammingVisual Basic Programming

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old January 1st, 2005, 11:29 PM
chinopk chinopk is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Jan 2005
Posts: 1 chinopk User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Question Problem in Data Reports through dataenvironment

Can anyone plz guide me, I am retrieving data through dataenvironemnt in visual basic, the problem is when I view the said report first time it gives me correct results, afterwards every time it appears with the same first time given results, unless I quit my application. I am using Parent and child command to get data and there are 2 parameters (1). date and (2) is ID... Plz Help.

Reply With Quote
  #2  
Old January 3rd, 2005, 02:50 AM
hithere's Avatar
hithere hithere is offline
Learner
ASP Free Newbie (0 - 499 posts)
 
Join Date: Nov 2004
Location: India
Posts: 450 hithere User rank is Sergeant (500 - 2000 Reputation Level)hithere User rank is Sergeant (500 - 2000 Reputation Level)hithere User rank is Sergeant (500 - 2000 Reputation Level)hithere User rank is Sergeant (500 - 2000 Reputation Level)hithere User rank is Sergeant (500 - 2000 Reputation Level) 
Time spent in forums: 5 Days 12 h 13 m 21 sec
Reputation Power: 17
hey even i was getting the same problem but when i used the following code i was able to get the desired effect. so just try this..

rs.Open "select * from temp3", cn, adOpenKeyset, adLockPessimistic, adCmdText
Set DataReport1.DataSource = rs
DataReport1.Show vbModal



Quote:
Originally Posted by chinopk
Can anyone plz guide me, I am retrieving data through dataenvironemnt in visual basic, the problem is when I view the said report first time it gives me correct results, afterwards every time it appears with the same first time given results, unless I quit my application. I am using Parent and child command to get data and there are 2 parameters (1). date and (2) is ID... Plz Help.

Reply With Quote
  #3  
Old January 3rd, 2005, 05:19 AM
ssk ssk is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Dec 2004
Posts: 14 ssk User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 54 m
Reputation Power: 0
Quote:
Originally Posted by hithere
hey even i was getting the same problem but when i used the following code i was able to get the desired effect. so just try this..

rs.Open "select * from temp3", cn, adOpenKeyset, adLockPessimistic, adCmdText
Set DataReport1.DataSource = rs
DataReport1.Show vbModal

well after using this code it worked fine for the first time but from 2nd time onwards i keep getting the error "operation not allowed when object is open"
if i add rs.close to the code i keep getting "operation not allowed when object is closed" even at the fist attempt

Reply With Quote
Reply

Viewing: ASP Free ForumsProgrammingVisual Basic Programming > Problem in Data Reports through dataenvironment


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway
Stay green...Green IT