Subject Re: database in Dropdown list From Gaetano <gaetanodd@hotmail.com> Date Tue, 18 Aug 2020 07:25:57 +1000 Newsgroups dbase.getting-started On 17/08/2020 14:12, Ken Mayer wrote: > On 8/16/2020 7:01 PM, 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. > > You need to read up on User BDE Aliases, which don't need to be in the > BDE Administrator, they are defined in the .ini file (Plus.ini, but in > the location defined by _app.iniFile -- in the Command Window: >      ? _app.iniFile, then open that version and you will see these > aliases defined in there ...). > > These are pretty handy. I have started using them for the small number > of applications I work on in dBASE. > > Ken > Hi Ken, I had found the User BDE Alias section in Help but unfortunately, I had not found the right ini file. I must have been in the ProgramData folder when I ran the command window test but I didn't realize it because the DBASESIGNUP Alias was open, so because no database was open and the query didn't have a database property set, the SQL just looked for attendees in the current folder. That's how two mistakes made me go round in circles. Thanks for your inputs. There is one more query I have which I posted in the website group. Irrespective of the above mistakes, if I use the signup.exe file that came with dBase and put it under c:\xampp\cgi-bin, the web app signup.exe generates an access denied error. If I just rebuild the executable without any changes to the PRG or CC files, it works fine. The rebuilt executable is more than twice the size of the original one. Does that make sense to you? Is it a requirement to rebuild the EXE files for the program to work? If so, could you explain the reason? Cheers, Gaetano.