×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

When I open dbf in command window i
2

When I open dbf in command window i

When I open dbf in command window i

(OP)
When I open dbf in command window it opens in shared mode. When I create a table, I can add fields, but I can't add comments and input conditions. Im tried SET EXCLUSIVE. After i restarted my computer, it did work. It seems the issue is resolved, but I don't want to restart the computer every time in this situation))

What to do to add comments and another? Thx

RE: When I open dbf in command window i

If you open a table by typing USE <tablename> in the command window, it will open in shared mode by default. You can change that by ticking the "Open exclusive" box in Tools / Options / Data. That will change the default for the current session. To make it the default for future sessions, click Set As Default in the Options dialogue. You can also add the keywords SHARED or EXCLUSIVE to the USE command.

If you open a table from the project manager or the database designer, it will always open exclusively.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

RE: When I open dbf in command window i

(OP)
I cant change in Display, Field validation, Map field, AutoIncrement, F.commnet because table not in database?

RE: When I open dbf in command window i

2
If the table is not in a database, then those settings will not be available. A table that is not in a database is a "free table", and free tables don't support any of the properties shown in the right-hand side of the Table Designer (Format, Input Mask, Caption, Validation, Map fields, Comment, etc.)

The reason for this is to maintain backward compatibly with earlier versions FoxPro. If you want to take advantage of those properties, you will have to place the table in a DBC.

That said, some developers say that they rarely use those properties. The only ones that I regularly use are Autoincrement and Field comment. But DBC-bound tables also support long field names, which for me is often the deciding factor.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

RE: When I open dbf in command window i

(OP)
Thank you, Mike

RE: When I open dbf in command window i

Glad to have been of help, Sasha.

I made a small mistake in my previous post. Autoincrement settings (Next Table and Step) are in fact available for free tables - but only if the table actually contains a field of type Integer (Autoincrement). None of the other properties are available.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close