Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: alan shulman
  Where is alan shulman?
 utica
 New York - United States
 alan shulman
 To: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 Tags
Subject: RE: rowsource table closing
Thread ID: 289002 Message ID: 289006 # Views: 29 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Forms
Date: Monday, December 27, 2010 6:05:43 PM         
   


> > I'm having the problem where my main form has a combo box with a rowsource being an indexed table that I seek on to change records that appear on the form. Then I call another form from the main form, and when I get back to the main form and go back to the combo box, I get the error "no table index set" on the seek command. Upon closing the child form I run a program where at the end I reopen the table in the combobox ( I was getting the "no table open" error before). First, what should I do to get the index set? Second, where should I put this command? In the destroy event of the child form?
>
> IMHO if a table\cursor is being used by a combo then it is a good idea to have a private datasession on that form. Alternatively you could set the called form's DE AutoOpenTables/AutoCloseTables property to .F.
>
> If you would set the index again anyway then, at the same routine that you open the table set the order.
>
> Cetin Basoz
>
> .Net has got better.Think about moving - check my blog:
> Blog (main)
> Blog (mirror)



I'm not that experienced so I need help with language. How would I make that main table a private data session? I don't know what that implies. My issue is I run a program that closes all tables when I close the child form, so I'm not sure if AutoOpenTables/AutoCloseTables property makes a difference. Does it?

ENTIRE THREAD

rowsource table closing Posted by alan shulman @ 12/27/2010 5:34:09 PM
RE: rowsource table closing Posted by Cetin Basoz @ 12/27/2010 5:59:05 PM
RE: rowsource table closing Posted by alan shulman @ 12/27/2010 6:05:43 PM
RE: rowsource table closing Posted by Cetin Basoz @ 12/27/2010 7:13:53 PM
RE: rowsource table closing Posted by alan shulman @ 12/27/2010 8:15:22 PM
RE: rowsource table closing Posted by Cetin Basoz @ 12/27/2010 8:28:13 PM
RE: rowsource table closing Posted by alan shulman @ 12/27/2010 8:33:38 PM
RE: rowsource table closing Posted by Samir H. @ 12/28/2010 1:48:03 AM