Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Database Container Questions
Message
De
06/03/1998 16:17:50
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00083081
Message ID:
00083138
Vues:
15
>>>>>We have a system that allows a user to import data into tables contained in a VFP database container from outside sources. It is possible for this source to be a table in another VFP database container. This additional container would be automatically opened by VFP when the table is opened for use.
>>>>>
>>>>>This brings up the following questions:
>>>>>
>>>>>How can we tell when an additional container has been opened?
>>>>>How can we determine which container is active?
>>>>>How can we switch between containers?
>>>>>How can we find out how many containers are open and what their names are?
>>>>>
>>>>>TIA
>>>>
>>>>Use DataEnvironment with toggled Cursor.Database properties.
>>>>See Help: ADATABASES(),DBC(),SET DATABASE, Database property
>>>
>>>Hi!
>>>We don't use DataEnvironment and trying to find solution around DBC(), but no luck so far.
>>>Marat
>>
>>DE is usually helpful, but what solution you're looking for (I see you are not initial poster).
>
>Hi, Edward.
>We (Garry and me) are working for the same company, so we are looking for the same solution. Here is our problem in more details. We have 2 the same containers located in the different folders. After importing file in the system program generates record in a log table, belonging to the container. When user imported data from the table which belongs to another container some time program creates record not in the container where we imported TO, but imported FROM.
>Marat

I believe that DE is suitable for this situation. When you want to change Database you just run:
****Form.Changedatabase method
lParameter cNewdatabase && new database path-name
With Thisform.Dataenvironment
.Closetables
Thisform.Setall("Database",cNewdatabase,"Cursor")
.Opentables
Endwith
Edward Pikman
Independent Consultant
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform