Board index » delphi » Error 10044 : Alias is not currently open

Error 10044 : Alias is not currently open

Hi,

I recently got this error when using Infopower'S QBE components. I was
"hand" building a QBE query and used table specifiers as

:alias:tablename.db

and got the above error message.

when I replaced above with

X:\path\tablename.db

It worked.

Any ideas as to what is going on? What is the implication of an
"un-opened/opened" alias?

Jim

 

Re:Error 10044 : Alias is not currently open


  I never use aliases anyway, so it should be fine ....  (an alias is
nothing more than a pointer to a given directory (so if you move your
database, your alias does you no good ...))

--

Jason Wallace
SL Software
Home:  Dark...@SLSoftware.reno.nv.us
Work:  Jason_Wall...@intuit.com

Quote
"Jim Eadie" <jim_ea...@mimotopes.com> wrote in message

news:kberks4uuqf4lej6nm43uro53cmuaftlo3@4ax.com...
Quote
> Hi,

> I recently got this error when using Infopower'S QBE components. I was
> "hand" building a QBE query and used table specifiers as

> :alias:tablename.db

> and got the above error message.

> when I replaced above with

> X:\path\tablename.db

> It worked.

> Any ideas as to what is going on? What is the implication of an
> "un-opened/opened" alias?

> Jim

Re:Error 10044 : Alias is not currently open


On Mon, 19 Jun 2000 00:40:20 -0700, "Jason Wallace"

Quote
<Dark...@SLSoftware.reno.nv.us> wrote:
>  I never use aliases anyway, so it should be fine ....  (an alias is
>nothing more than a pointer to a given directory (so if you move your
>database, your alias does you no good ...))

Well, Jason.....
There is at least one good reason to use aliases-- portability. For
example:

Using aliases, the user can decide where to put the datafiles. It may
be on a local or fileserver drive. The local C: drive may be full, and
the user has to put it on the D: drive. The path needs to be put in
just one place: the BDE configuration file.

Using hard coded paths: The user is stuck with the directory and drive
that the application programmer used. To put the data in a different
directory or on a different computer, wouldn't the user have to go
back to the programmer who would have to:
1. find all references in code to the data path.
2. change the path
3. recompile the app
4 install the new exe file on the user's machine

I know that these steps may not be difficult, but is there any way to
avoid recompiling?

FWIW,
Dan

--
Dan Brennand
CMDC systems, inc.
Configuration Management and Document Control: Consulting, Software,
and the only comprehesive textbook on this subject.
visit us at www.cmdcsystems.com
[Remove the SPAM from my e-mail address]

Re:Error 10044 : Alias is not currently open


Thanks both of you for your replies.

But the issue was the error message not use of aliases. I just don't
understand why I get an "unopened" alias message. What does that mean?

Jim

Re:Error 10044 : Alias is not currently open


On Mon, 19 Jun 2000 16:14:35 +1000, Jim Eadie

Quote
<jim_ea...@mimotopes.com> wrote:
>Hi,

>I recently got this error when using Infopower'S QBE components. I was
>"hand" building a QBE query and used table specifiers as

>:alias:tablename.db

>and got the above error message.

>when I replaced above with

>X:\path\tablename.db

>It worked.

>Any ideas as to what is going on? What is the implication of an
>"un-opened/opened" alias?

>Jim

Jim,
How are you connecting to tablename.db? I presume you were building
the query at runtime. I don't know the details of how the QBE
component works, but would guess that it has to get the table
structure before you can start building the query. This would require
the database connection to be open using the alias you are specifying.

Obviously, I pretty much guessing here, but it might help ;-]

Dan
--
Dan Brennand
CMDC systems, inc.
Configuration Management and Document Control: Consulting, Software,
and the only comprehesive textbook on this subject.
visit us at www.cmdcsystems.com
[Remove the SPAM from my e-mail address]

Other Threads