| View previous topic :: View next topic |
| Author |
Message |
gego
Newbie
Joined: 26 Feb 2005
Posts: 5
|
 Posted: Feb 28th, 2005 11:41 AM Post subject: Please help me,SQL statment problem |
 |
|
Im using VisualBasic6, Access97 and data control object , program works fine the problem appears when Im trying to use SELECT statement
Data1.RecordSource = "SELECT * FROM Table1 WHERE MoreInfo='2' "
this statment works fine with form load but when using it on a button after displaying all data of table it does not work
Please help me to discover the problem,
Thanks
_________________
Thanks |
|
| Back to top |
|
TriSight
Regular
Joined: 12 Oct 2004
Posts: 69
Location: Mobile, AL
|
| Posted: Feb 28th, 2005 11:59 AM Post subject: |
|
|
Is it giving you an error or just not displaying the data?
If it's just not displaying new data, your problem may be that you aren't refreshing the data control. Data1.Refresh will requery the data in your recordset. And then if you are using it on a data bound control you will need to refresh the control too..
_________________
/=--_The Nomad_--=\
"Men of lofty genius when they are doing the least work are most active. " - Leonardo da Vinci |
|
| Back to top |
|
gego
Newbie
Joined: 26 Feb 2005
Posts: 5
|
| Posted: Feb 28th, 2005 02:43 PM Post subject: |
|
|
I tried But it is also not displaying any data,
I Prefere to attach the files , How can I attach it to this page?
Thanks.
_________________
Thanks |
|
| Back to top |
|
TriSight
Regular
Joined: 12 Oct 2004
Posts: 69
Location: Mobile, AL
|
| Posted: Feb 28th, 2005 02:50 PM Post subject: |
|
|
I dunno if you can.. but if you want you can zip them up and email them to me trisight@yahoo.com and I'll take a look at them :-)
_________________
/=--_The Nomad_--=\
"Men of lofty genius when they are doing the least work are most active. " - Leonardo da Vinci |
|
| Back to top |
|
gego
Newbie
Joined: 26 Feb 2005
Posts: 5
|
| Posted: Feb 28th, 2005 03:56 PM Post subject: |
|
|
I sent files, but it works fine with me,
thanks
_________________
Thanks |
|
| Back to top |
|
TriSight
Regular
Joined: 12 Oct 2004
Posts: 69
Location: Mobile, AL
|
| Posted: Feb 28th, 2005 04:11 PM Post subject: |
|
|
Interestingly enough I had no problems.. it selected it fine for me.. Don't know man.. I even took out the comment and had it filter for 2 and then clicked the button for 5 and it worked fine..
_________________
/=--_The Nomad_--=\
"Men of lofty genius when they are doing the least work are most active. " - Leonardo da Vinci |
|
| Back to top |
|
|
