Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. articles. downloads. faq. members. files. rss.
 From: Barbara Peisch
  Where is Barbara Peisch?
 Oceanside
 California - United States
 Barbara Peisch
 To: sudhir
  Where is sudhir?
 
 India
 sudhir
Subject: RE: Using Same Table in Two Applications
Thread ID: 106721 Message ID: 106728 # Views: 1 # Ratings: 0
Version: Visual FoxPro 5 Category: Databases, Tables and SQL Server
Date: Tuesday, September 12, 2006 8:57:36 PM         
   



> Dear Friends
>
> I have a customer table which is being used in one application.
>
> Now I am in the proces on making another application in which I need to use the same table
>
> 1) Is it right to use the same table by giving full path. I shall not make any changes in the table in the new application and just use the data for viewing.
>
> 2) Or should I make a new table in the new directory and shall update it from the table which is in the original location.
>
> Pls also suggest if there is another way of doing this??
>
>
> Thanks in advance.
>
>
>
> Sudhir


You can use the same table, but assuming this new app is in a different directory, things could get a bit tricky. I would configure the location of this table in both apps so that it doesn't always have to stay in the same place. The problem comes when you use a form's DE to open tables. In cases like this, I only use a form's DE for making it easier to design the forms, e.g. having the fields and aliases available from property selections. But I'll set the AutoOpenTables to .F. and then open the tables myself in the form's Load.

-BP
www.peisch.com

ENTIRE THREAD

Using Same Table in Two Applications Posted by sudhir uppal @ 9/12/2006 8:16:37 PM
RE: Using Same Table in Two Applications Posted by Borislav Borissov @ 9/12/2006 8:52:43 PM
RE: Using Same Table in Two Applications Posted by Barbara Peisch @ 9/12/2006 8:57:36 PM
RE: Using Same Table in Two Applications Posted by Ken Murphy @ 9/12/2006 9:04:24 PM