>Say I have databse named x
>
>When I issue the following command
>
>lcdata = "x"
>OPEN DATA &lcDATA
>
>in some cases it works and in some case it won't.
>
>Any ideas?
In general it's better to use a name expression here, e.g.
OPEN DATA (x)
This will also handle the situation where the expression "x" contains a space, that is, it is fully-qualified and one or more of the folders in the path contains a space. This will cause the macro substitution to fail, as it will insert multiple words.
If you are not fully qualifying the path to database "x" and it's not in your PATH, it won't be found/opened.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up