Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Cetin Basoz
  Where is Cetin Basoz?
 Izmir
 Turkey
 Cetin Basoz
 To: alan shulman
  Where is alan shulman?
 utica
 New York - United States
 alan shulman
 Tags
Subject: RE: rowsource table closing
Thread ID: 289002 Message ID: 289004 # Views: 41 # Ratings: 2
Version: Visual FoxPro 9 SP2 Category: Forms
Date: Monday, December 27, 2010 5:59:05 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)

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