Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Free table question
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00513063
Message ID:
00513260
Views:
16
Thanks all. Now I get it.

>>>After reading the VFP docs about free tables, it appears to me that if I have a dbc open, then if I use a table, its automatically put in the dbc.
>>>
>>>Here is my concern, I have a dbc open during my applicaiton, I open the actual dbf's and use them, close them etc. but there is this part of my application, where I think it would be wise to not use the dbc, and have each user have a free table on their own computer....Like private data. local data to that user only.
>>>
>>>so really my quesiton is I can use create table free command in code to create a free table. then if a dbc is open, and that free table is used.... does that free table get put in a part of the dbc. ? and if so, is there some way I can tell vfp not to add this table ever to the dbc. ?
>>>
>>>Thanks
>>>Bob Lee
>>
>>Bob,
>>Free tables or fox2x
> tables are not autmatically put in a dbc. You can close-open them. There are few situations that would make them part of DBC like :
>>add table...
>>create table when a DBC is open
>>Also fox2x tables would remain as is if you don't trigger structural changes like null value support, new data type addition.
>>Cetin
>
>Just don't forget to use FREE clause when you create your tables, and they would not pollute your database. We had this problem few times...
In the beginning, there was a command prompt, and all was well.
Previous
Reply
Map
View

Click here to load this message in the networking platform