?
Solved

pls help me in displaying the data in my data report

Posted on 2003-03-20
3
Medium Priority
?
225 Views
Last Modified: 2010-05-18
my problem on my program about data report is, the data report doesn't change its data displayed eventhough i change already the command text value of the command object. what is the result of the first query would still be the same data displayed in my second and succeeding query using the same command object, eventhough i change my SQL statement to extract another record.

let us say my table is like this (TABLE NAME IS STUDENTS)
id    lastname    firstname    age
===============================
100   gallera       reden        22
200   sullaga       adel         26
300   domingo       sheila       22

First Query : SELECT * FROM STUDENTS WHERE ID=100
Data Report Output is (displaying the all data except [id]):

    gallera, reden     22

Second Query : SELECT * FROM STUDENTS WHERE ID=200
Data Report Output is (displaying the all data except [id]):

    gallera, reden     22


the same data will appear in my data report...

i had use the refresh method of the data report but nothing happen.... :(

what should i do? please help me...

can i get your email add for me to send my program to you so that you can see the real score of my program...please

my add is rdg577@yahoo.com

thank you so much....

what i want in my program is to preview/display the data of the record that i only selected....
0
Comment
Question by:rdg577
[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
3 Comments
 

Accepted Solution

by:
tejas_pathak earned 300 total points
ID: 8179632
hi,

The prob. seems to be with Recordset object not getting refreshed, when you had change the Command object.
So after changing the CommandText property of Command object , call the execute method of command object which will execute the query in CommandText property. for eg :
"command1.execute".

Let us know of the updates.
Bye.
0
 

Expert Comment

by:CleanupPing
ID: 9446952
rdg577:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

Today, the web development industry is booming, and many people consider it to be their vocation. The question you may be asking yourself is – how do I become a web developer?
The SignAloud Glove is capable of translating American Sign Language signs into text and audio.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

762 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