Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: bryan wetton
  Where is bryan wetton?
 Morphett Vale
 Australia
 bryan wetton
 To: Stefan Wuebbe
  Where is Stefan Wuebbe?
 Hamburg
 Germany
 Stefan Wuebbe
 Tags
Subject: RE: opening multiple tables in one routine
Thread ID: 209088 Message ID: 209526 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: General VFP Topics
Date: Monday, December 29, 2008 12:37:26 PM         
   


Sefan,

Thanks for your suggestion below

>
> If Not Used(mytable)
>     Select 0
>     Use (mytable) 
> Endif
> 


However the mystery/problem remains.

After a copy from one folder to another (target folder)I can manually open the copied table by X2 clicking in Windows Explorer and choosing VFP to open the file - thus the copy has succeeded.

After I set default to the target folder I use the debugger.

The following facts exist in the debugger.

1 curdir() shows me the target folder correctly

2 sys(5) shows me the correct drive.

3 The test for the existence of the file - file(myfullypathedfilename) returns a .T. -So VFP knows the dbf file is there.

4 The alias() is being watched and shows the previously open table ( before the copy routine)

5 (mytable) is juststem(myfullypathedfilename)

6 alias() does not show the new table when the USE command in either form is carried out. A browse in the Command Window opens the previous table.

Any further thoughts please?




-Bryan

ENTIRE THREAD

opening multiple tables in one routine Posted by bryan wetton @ 12/24/2008 6:58:11 AM
RE: opening multiple tables in one routine Posted by Brad Schulz @ 12/24/2008 8:09:38 AM
RE: opening multiple tables in one routine Posted by bryan wetton @ 12/25/2008 8:29:48 AM
RE: opening multiple tables in one routine Posted by Brad Schulz @ 12/27/2008 6:59:58 PM
RE: opening multiple tables in one routine Posted by bryan wetton @ 12/28/2008 2:48:51 AM
RE: opening multiple tables in one routine Posted by Stefan Wuebbe @ 12/28/2008 10:26:40 AM
RE: opening multiple tables in one routine Posted by bryan wetton @ 12/29/2008 12:37:26 PM
RE: opening multiple tables in one routine Posted by Brad Schulz @ 12/29/2008 7:26:41 PM
RE: opening multiple tables in one routine Posted by Stefan Wuebbe @ 12/29/2008 7:40:52 PM
RE: opening multiple tables in one routine Posted by bryan wetton @ 12/30/2008 7:59:40 AM
RE: opening multiple tables in one routine Posted by bryan wetton @ 12/30/2008 7:53:24 AM
RE: opening multiple tables in one routine Posted by Stefan Wuebbe @ 12/29/2008 7:38:40 PM
RE: opening multiple tables in one routine Posted by Jyothish KV @ 12/24/2008 8:49:56 AM
RE: opening multiple tables in one routine Posted by Andy Kramek @ 12/24/2008 12:20:17 PM