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!
  • Students Click Here

*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


DBCMD/1011 Alias in Use

DBCMD/1011 Alias in Use

DBCMD/1011 Alias in Use

I am trying to run to my Clipper 5.01 code using Clipper 5.3 and Blinker 1.0. I am getting the above mentioned error code when I try to open up a dbf in a second work area. This works very well in 5.01 but I cannot get it to work now. Does anyone know what I am doing wrong? Do I need to use any particular switches when compiling?

Any direction will be greatly appreciated!

Thanks.......... Brian

RE: DBCMD/1011 Alias in Use

If you are trying to open the same database is another workarea, you need to add the ALIAS <aliasname> clause to your USE statement, supplying a unique alias for every workarea.


RE: DBCMD/1011 Alias in Use


TonHu is correct, your program is trying to open a dbf file that is already open in another part of your program.  Does your program open all of the needed dbf files at start up or does it open and close them as needed.  If they are always open then just point to the select area and you should be OK.  But if you are opening and closing them then this dbf isn't getting closed after it is used.

Jim C.

RE: DBCMD/1011 Alias in Use

No, my program opens the files only when required and then closes when the task is complete. What puzzles me is this works fine under Clipper 5.01 with RtLink, but will not work under 5.3 with Blinker.

RE: DBCMD/1011 Alias in Use

You may be opening files with the same name, but in other subdirs, these get the name of the file as an Alias, and not parts of the path. Can't recall if 5.01 allowed duplicate aliasses, but that can also be the source of this problem.


RE: DBCMD/1011 Alias in Use

Older versions of clipper used to default the alias of the file being used to the area letter in which the file was opened, so you would refer to the database fields using the area letter as the alias (i.e. A->fieldname).

Newer versions default to the database name as the alias when none is specified. The database name does not include the path. Therefore if you need to open the same file in two areas or two different files with the same name then you must specify unique aliases.

If you are working with legacy code and don't want to have to chase down a ton of field references to change tha aliases, then just make each file alias the workarea letter in which it is opened and everything else remains the same.

I doubt the linker is causing this; possibly you were using 5.2 libs in the past? I know 5.2 aliased the old way, but I no longer have 5.3 to see if that is when this behavior changed.


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!

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