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:
00513088
Views:
15
Hi!

>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.
>

Above is not correct. If you use table it is just opened without any change. If you CREATE table, it is put in the current databse by default if it is opened. If no current database selected, table is created as free by default. Finally, CREATE TABLE command have an option - FREE or DATABASE {databasename}.

>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. ?
>

No, do not worry about that. Better worry about what you lose when you move from database to free table. Long field names, field captions, default values etc etc. Could be messy if you already put a lot of stuff in DBC.

HTH.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.com
ICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs

It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.
Previous
Reply
Map
View

Click here to load this message in the networking platform