Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Yousfi Benameur
  Where is Yousfi Benameur?
 El Bayadh
 Algeria
 Yousfi Benameur
 To: Nandkishor Lande
  Where is Nandkishor Lande?
 Pune
 India
 Nandkishor Lande
 Tags
Subject: RE: Running Strip Bottom of Form
Thread ID: 310442 Message ID: 310778 # Views: 26 # Ratings: 0
Version: Visual FoxPro 9 Category: Forms
Date: Friday, June 24, 2011 10:40:43 AM         
   


> Nice thank for your valuable time
>
> if i use this facility in my form is my application would be slow?
>
> Yousfi Benameur
> Bhai, i have a simple problem, i cant understand why this not work properly
>
> I have form ACCOUNT
> I use free table for it
> the tables are Account,Group,City
>
> I use command in LOAD event
> select a
> use account
> select b
> use group
> select c
> use city
>
> I use command in UNLOAD event
> If used('Account')
> use
> endif
> If used('Group')
> use
> endif
> If used('City')
> use
> endif
>
> when i want to add new city
> I use command in KEYPRESS event
> if nkeycode=37
> do form city
> endif
>
> I use LOAD,UNLOAD event in Group form like Account form
> LOAD Event
> select a
> use group
>
> UNLOAD event
> If used('Group')
> use
> endif
>
> Here is a problem when i return from Group form there is an error message
> table group not found
>
> how could recovered it
>
> just i using dataenvorinment, but i want to use free table for speed up my application please guid me
> I cant understand
>
>
> NVL


in your form city you close the table and when you go back to your master form its already closed (its opened in the master form firstly).
then cut the code in the form city in unload event and your free table stays opened and dont fires error..
you can also navigate on tables with their alias only.dont "use..." with a table already opened (or "use...again" close).

NB: Please , if you have a new question post it as standalone in the forum to dont mix the principal question of the thread.

Regards
Yousfi Benameur

ENTIRE THREAD

Running Strip Bottom of Form Posted by Nandkishor Lande @ 6/21/2011 12:59:57 PM
RE: Running Strip Bottom of Form Posted by subhankar pandey @ 6/21/2011 5:56:34 PM
RE: Running Strip Bottom of Form Posted by sri kishan @ 6/22/2011 5:21:08 AM
RE: Running Strip Bottom of Form Posted by sri kishan @ 6/22/2011 6:25:02 AM
RE: Running Strip Bottom of Form Posted by Nandkishor Lande @ 6/22/2011 7:53:35 PM
RE: Running Strip Bottom of Form Posted by Yousfi Benameur @ 6/23/2011 12:55:27 AM
RE: Running Strip Bottom of Form Posted by andrew kabz @ 6/23/2011 7:26:58 AM
RE: Running Strip Bottom of Form Posted by Yousfi Benameur @ 6/23/2011 6:16:07 PM
RE: Running Strip Bottom of Form Posted by Nandkishor Lande @ 6/24/2011 5:09:43 AM
RE: Running Strip Bottom of Form Posted by Nandkishor Lande @ 6/24/2011 5:33:08 AM
RE: Running Strip Bottom of Form Posted by Yousfi Benameur @ 6/24/2011 9:02:48 AM
RE: Running Strip Bottom of Form Posted by Nandkishor Lande @ 6/24/2011 10:08:54 AM
RE: Running Strip Bottom of Form Posted by Yousfi Benameur @ 6/24/2011 10:40:43 AM