Subject Re: database in Dropdown list From Gaetano <gaetanodd@hotmail.com> Date Mon, 17 Aug 2020 12:59:26 +1000 Newsgroups dbase.getting-started On 17/08/2020 12:26, Akshat Kapoor wrote: > On 17.08.2020 07:31, Gaetano wrote: >> Hi All, >> >> When you are in the navigator on the Tables tab, the dropdown list >> shows folders and databases. It was my understanding that databases >> with the yellow database symbol would be defined either in the >> Plus.ini file or in the BDE Administrator. >> >> While the Sample databases (Contax, DBSIGNUP...etc.) are present in >> the list, they are not appearing in the BDE administrator nor in the >> Plus.ini file. >> >> Can someone shed some light on this mystery? Is there some other place >> where those databases are defined? or are the Sample databases >> hard-coded in dBase with their location under c:\ProgramData\...? >> >> Plus.ini does have a few cryptic entries under the [Component] section >> that turn out to be Registry keys, but while searching the registry >> for those keys, I didn't find anything tying them a database. > > Good Morning Gaetano, > Can you outline the requirement for this query. I never went for this > route and hence cannot help you out on this but if I know WHY you want > this then may be able to help you out. > > Regards > Akshat Good Morning Akshat, This is related to my post in the web group. I was getting an access denied error while running the web app Signup.htm & stock SIGNUP.EXE file from the ProgramData folder. I tried to establish the database connection in the command window with a query object and set the databasename to dbasesignup. This gave me a path to ProgramData for the tables that the BDE could not access. From there, I thought I would copy the files to an unrestricted folder and try again. No change, the web form would not execute. This is why I was trying to find where the path to the DBASESIGNUP database is defined so I could update it. Meanwhile, I also tried to setup a BDE alias, hoping it would supersede any other database reference and path, and that didn't work either. My last attempt was to recompile the SIGNUP.PRG & other required files file with a slight tweak to the file BUILDALLTOSAMPLES.PRG because again the target folder defaults to ProgramData (which was blocked by BitDefender, and even after allowing it in BitDefender, the PRG file still can't write to that folder), so I just hard coded a non-protected path on my local drive D. The newly compiled executable (placed in the XAMPP\cgi-bin folder) paired with a BDE alias pointing to a non-protected folder got the app to work as expected. The new EXE file is more than double the size of the stock-version of signup.exe under ProgramData, so there must be some differences with the stock version of it. I am nevertheless still curious to understand where those dropdown databases get their details from (path) and why I do not have those sample databases in the BDE Administrator, I am pretty sure I used to have them in the BDE Administrator in past versions of dBase.