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