Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Anil Sharma
  Where is Anil Sharma?
 ludhiana
 India
 Anil Sharma
 To: Dianne Benedicto
  Where is Dianne Benedicto?
 Davao City
 Philippines
 Dianne Benedicto
 Tags
Subject: RE: set relation to tables
Thread ID: 189283 Message ID: 189313 # Views: 2 # Ratings: 0
Version: Visual FoxPro 7 Category: Databases, Tables and SQL Server
Date: Thursday, August 14, 2008 11:20:29 AM         
   


> > Hi Dianne
> >
> > Just do alltrim in thisform.csection.value in report parameters!
> > well u made the temp file to display report well u can do without making tempfile too.
> >
> > when u use relation just add word additive so the any other realtion from that table will not close.
> > see the help for detail.
> >
> > set relation to studentid INTO entrance additive
> >
> >
> > Anil
> > (Fox is the solution for almost everything!!)
>
> Hi Anil! I added alltrim to my report parameters but still no value will display :-(


o yes

copy to (tempfile) *while* ALLTRIM(sectioncode)=ALLTRIM(thisform.cSection.value)

while works fine only with indexs
so just use *for* instead of *while* i think thats the problem.
or another thing after making tempfile
just use browse to check if temp table have the records.



Anil
(Fox is the solution for almost everything!!)

ENTIRE THREAD

set relation to tables Posted by Dianne Benedicto @ 8/14/2008 9:13:34 AM
RE: set relation to tables Posted by Anil Sharma @ 8/14/2008 9:29:59 AM
RE: set relation to tables Posted by Dianne Benedicto @ 8/14/2008 9:49:04 AM
RE: set relation to tables Posted by Anil Sharma @ 8/14/2008 11:20:29 AM
RE: set relation to tables Posted by surinder singh @ 8/14/2008 10:05:26 AM
RE: set relation to tables Posted by Dianne Benedicto @ 8/14/2008 10:11:02 AM
RE: set relation to tables Posted by Stefan Wuebbe @ 8/14/2008 10:29:08 AM
RE: set relation to tables Posted by Anil Sharma @ 8/14/2008 11:18:33 AM
RE: set relation to tables Posted by tushar @ 8/14/2008 1:19:18 PM
RE: set relation to tables Posted by Anders Altberg @ 8/14/2008 2:09:54 PM
RE: set relation to tables Posted by Dianne Benedicto @ 8/20/2008 5:00:49 AM
RE: set relation to tables Posted by Anders Altberg @ 8/20/2008 11:23:41 AM
RE: set relation to tables Posted by Dianne Benedicto @ 8/26/2008 5:43:17 AM
RE: set relation to tables Posted by Anders Altberg @ 8/26/2008 11:06:13 AM
RE: set relation to tables Posted by Dianne Benedicto @ 8/27/2008 2:17:21 AM
RE: set relation to tables Posted by Glenn Villar @ 8/15/2008 7:40:57 AM
RE: set relation to tables Posted by tushar @ 8/15/2008 7:52:31 AM
RE: set relation to tables Posted by Glenn Villar @ 8/15/2008 7:56:35 AM
RE: set relation to tables Posted by Ulhas Amrite @ 8/27/2008 10:53:24 AM
RE: set relation to tables Posted by tushar @ 8/27/2008 4:53:58 PM
RE: set relation to tables Posted by Dianne Benedicto @ 8/20/2008 4:47:13 AM
RE: set relation to tables Posted by Glenn Villar @ 8/20/2008 6:16:51 AM
RE: set relation to tables Posted by Dianne Benedicto @ 8/26/2008 5:41:39 AM
RE: set relation to tables Posted by Glenn Villar @ 8/26/2008 6:02:59 AM
RE: set relation to tables Posted by Dianne Benedicto @ 8/26/2008 7:40:42 AM
RE: set relation to tables Posted by Dianne Benedicto @ 8/26/2008 7:44:25 AM
RE: set relation to tables Posted by Glenn Villar @ 8/26/2008 8:17:51 AM
RE: set relation to tables Posted by Dianne Benedicto @ 8/26/2008 8:46:57 AM
RE: set relation to tables Posted by tushar @ 8/26/2008 9:25:42 AM
RE: set relation to tables Posted by Dianne Benedicto @ 8/26/2008 9:31:54 AM
RE: set relation to tables Posted by Glenn Villar @ 8/26/2008 9:39:58 AM
RE: set relation to tables Posted by Dianne Benedicto @ 8/26/2008 9:55:15 AM
RE: set relation to tables Posted by Glenn Villar @ 8/26/2008 10:00:37 AM
RE: set relation to tables Posted by Dianne Benedicto @ 8/26/2008 10:08:17 AM
RE: set relation to tables Posted by Glenn Villar @ 8/26/2008 10:34:24 AM
RE: set relation to tables Posted by Dianne Benedicto @ 8/27/2008 10:41:48 AM
RE: set relation to tables Posted by Anders Altberg @ 8/26/2008 4:35:37 PM
RE: set relation to tables Posted by Dianne Benedicto @ 8/27/2008 2:18:53 AM
RE: set relation to tables Posted by Stefan Wuebbe @ 8/27/2008 7:54:29 AM
RE: set relation to tables Posted by Dianne Benedicto @ 8/27/2008 10:43:17 AM